Any access gurus out there? I need to be able to pause some code

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

When I open my database I open a frmIntro and straight after that I
open 3 forms.
docmd.openform "frmIntro"
Forms("frmIntro").SetFocus

docmd.openform "frmA"

docmd.openform "frmB"

docmd.openform "frmC"

Forms("frmIntro").SetFocus
docmd.Close

frmIntro just simply says on it "Please wait while the database opens"
however, because Access executes the other open commands straight
away, it does not let frmIntro open fully and all I can see on the
frmIntro is the title bar of the window, it doesn't show the body of
the window. I have tried to halt opening the other forms. Can anyone
help me? Even just pausing the code and allowing frmIntro to open
fully would be good.
 
I use a RepaintObject in that situation

Example:
DoCmd.OpenForm "ProcessingMessage", acNormal
DoCmd.RepaintObject acForm, "ProcessingMessage"

Then I continue to to the processing ...
then close the form at the end of the processing.

SteveD
 
Back
Top