Application.Wait for Access?

Montez659

Well-known Member
Joined
May 4, 2005
Messages
918
I am working on a db in which I want to include a form frmStatus that has a label in it that I only want to display for a quick second. Essentially, the label will say either "Processing" or "Processed!". The problem is that in some cases, whatever is processing happens so quickly that the form flashes but you can never see the message. I know that Application.Wait would work in Excel but have discovered that it doesn't work in Access. Any ways around this or is there a different command for this in Access?

Thanks in advance!
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
For your code -

1. Display the form
2. Have the code
Code:
DoEvents
after that.
3. Then have the rest of your code.
 
Upvote 0
Thanks for the help! Didn't quite understand how you were wanting me to use that, but I was able to check DoEvents in MS help and got an idea on how to do it. Got the result I was looking for. Thanks again!
 
Upvote 0

Forum statistics

Threads
1,224,509
Messages
6,179,192
Members
452,893
Latest member
denay

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top