Results 1 to 7 of 7
  1. #1
    4 Star Lounger
    Join Date
    Dec 2002
    Location
    Kitchener, Ontario, Canada
    Posts
    421
    Thanks
    0
    Thanked 0 Times in 0 Posts

    hiding dialog boxes (2000(SP3))

    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?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: hiding dialog boxes (2000(SP3))

    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>post 317,048</post:>.

  3. #3
    4 Star Lounger
    Join Date
    Dec 2002
    Location
    Kitchener, Ontario, Canada
    Posts
    421
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: hiding dialog boxes (2000(SP3))

    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.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: hiding dialog boxes (2000(SP3))

    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.

  5. #5
    4 Star Lounger
    Join Date
    Dec 2002
    Location
    Kitchener, Ontario, Canada
    Posts
    421
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: hiding dialog boxes (2000(SP3))

    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...
    <img src=/S/crossfingers.gif border=0 alt=crossfingers width=17 height=16> <img src=/S/wink.gif border=0 alt=wink width=15 height=15>

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: hiding dialog boxes (2000(SP3))

    See API: Suppress the "Printing" Dialog. I don't like that approach, though - form timers tend to have undesired side effects.

  7. #7
    4 Star Lounger
    Join Date
    Dec 2002
    Location
    Kitchener, Ontario, Canada
    Posts
    421
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: hiding dialog boxes (2000(SP3))

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

    Thanks as always,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •