Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2011

    Question Unanswered: OpenForm using VBA delay issue

    Morning Everyone,

    I am hoping someone can help with an issue i have.
    I have a form with a command button on, when pressing the command button it performs an outputto command (outputting report to pdf)

    Prior to the outputto command in vba it opens the report in print preview mode but the report fails to finish generating before the outputto command fires causing the report not to finish generating until the outputto process completes. is there a way i can delay the outputto from firing until after the report has finished generating so i am not left with just the border and controlbox showing and a transparent report.

    Any help will be greatly appreciated

  2. #2
    Join Date
    Mar 2009
    Provided Answers: 15
    Try to insert a DoEvents instruction after opening the report in Preview mode.
    Have a nice day!

Posting Permissions

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