Pop-up box?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that takes a few minutes to load since it contains over 3500
records as well as sorts and has a few functions to run. When someone clicks
to open the report, is there a way to have a pop-up box or something to
indicate the report takes a while? I have it explained in the description
notes but wanted another obvious indicator. Thank you!
 
I suppose what you need is another form with a message saying 'please wait
the report is loading'. I have a popup form on my form for a list of reports.

To keep my popup smaller then the main form I have used the Restore action
in the on activate event for the small form. In the main form I have the
maximise action in the on activate event. When I used this the main form
would go smaller when I clicked on the popup so I have set the popup property
in the other tab to yes. I don't know if you do need the restore and
maximise actions aswell as the popup property but I started with those and
then found the popup property and so don't wan't to change things incase it
stops working.
 
Hi Clare,

Thank you! How do I link the Popup to the report when someone clicks on the
report to open? I'm assuming the Popup will happen at the same time the
report will be loading.
 
I created my comand button using the wizard and this is the code it created

Private Sub cmdPrintreports_Click()
DoCmd.OpenForm (frmPrintreports)
End Sub

So I guess that you insert the DoCmd at the start of the code that is for
the button that the user has to click to start the report running. I've found
that my popup does stay on top of the report so the user would have to
manually close the popup. You could probably either insert a close form
command button or see if you can get the form to open for a certain length of
time. I'm sure you can do this as this is the theory behind splash pages
isn't it. You just have to make sure that access gets on with opening the
report instead of waiting for the timer to time out before it starts opening
the report.
 
Back
Top