OpenCurrentDatabase

[Steve]

Got a problem. I have a .mdb that is used all day for
significant data entry. Every 4 minutes a report is
exported as an HTML doc to the server for the employees
to view. However, each time the report is exported, the
windows print dialog comes up and ceases data entry until
the print job is done. I am unable to suppress the
dialog and this ceases data entry.

My answer was to open a linked database to the data using
appAccess.OpenCurrentDatabase. This opens the database
in the Processes of Windows, but not as an app which is
perfect. It supresses the dialog box each time the
report is exported, so it is working perfectly.

Question: Anyone see anything wrong with this or anyone
have any ideas how to suppress the dialog. I know I am
eating up some memory, but it seems to be working like a
champ.

Thanks,

 

[Chris Nebinger]

Is there a reason that you are exporting a HTML doc as
opposed to using .asp pages?

Also, how are you printing to HTML? What command?

Chris Nebinger

 

[Steve]

This is just an internal HTML doc so that employees can
track data. Nothing going in or out of the HTML doc,
just for viewing.

To print, I am using:

DoCmd.OutputTo acReport, "qry1050Txt1", "HTML*.html)",
"C:\00SSBE\1050.html", False, ""