Not sure if this is the right forum for this. I have a switchboard that one of the buttons is tied to run a specifc report. Once the user clicks this button, is there a way to show a loading bar so they know its on the way (outside of the loading bar in the lower left). I'm looking to make it obvious to someone who's never used Access before that the report it coming up. Any ideas?
Showa "loading" message while a report/query is still running (1 Viewer)
- Thread starter mab9
- Start date
mhartman
Dr. Data
- Local time
- Today, 09:02
- Joined
- Jun 5, 2006
- Messages
- 442
jeremypaule
Registered User.
- Local time
- Today, 12:02
- Joined
- Aug 21, 2006
- Messages
- 135
any chance of having this in VBA code?
KernelK
Registered User.
- Local time
- Today, 12:02
- Joined
- Oct 3, 2006
- Messages
- 173
To do it with VBA code, all you need to do is create a form with the properties specified in the MSDN article. Put a label on it that says "Please Wait" or whatnot. Then make the button on the switchboard open the form instead of the report, and use the form's timer event to open the report after 1 milisecond, that way the form comes up, displays its text and stays there while the report is loading. You can put code into the reports load event that closes the form.
