hiding dialog boxes (2000(SP3))

Topic

New Reply

I have automated a loop that creates a report, saves it to PDF, then attaches the PDF to an email to send to the client. Because of some parameter issues, the PDF needs to be created in the On Activate event of the report so that the information is displayed correctly.

In the on click event of the the form that feeds date parameters to the form, I open the report in print preview to trigger the PDF creation then close it then attach the PDF to the email. Click Yes Express takes care of Outlook security nonsense.

The end result is a lot of fleeting dialog boxes flickering across the screen. Is there a way to make all of these dialogs not display and maybe just display an hourglass instead?

Reply | Quote

Replies

Do you mean the Outlook security warnings that are subsequently closed by ClickYes? They are not generated by Access, so you cannot get rid of them within Acccess. You’d have to use one of the other methods to suppress the Outlook security warnings mentioned in post 317,048.

Reply | Quote

Sorry I should have been clearer. The printer dialog box also pops up because I am sending a report to preview mode before it gets outputted to the PDF file. It is the report that is opening and closing as well as the printer dialog box when a document is spooling before it opens.

It’s not the end of the world, but stopping some of these screen repaints is what I’m talking about. For instance, is it possible to send a report to print preview but not have it visibly show up on the screen? Since I’m only using print preview as a means to get my PDF file generated properly.

Reply | Quote

You can suppress the display of the report by inserting the line

DoCmd.Echo False

at the beginning of the code, before opening the report, and the line

DoCmd.Echo True

at the end, when you’re done. I doubt whether this will suppress the dialogs.

Reply | Quote

That’s what I was looking for. Many thanks. You’re right, it doesn’t suppress the dialogues, but does cut down on the flashing screens. Now if I could also as easily suppress “outputting page 1 of 1” from the printer driver, I’d be a completely happy camper. Not that I’m being demanding…

Reply | Quote

See API: Suppress the “Printing” Dialog. I don’t like that approach, though – form timers tend to have undesired side effects.

Reply | Quote

I suspected as much. I think I will leave well enough alone. They can amuse themselves watching the screens flash by…

Thanks as always,

Reply | Quote