Wait

[kirkm]

Hi Folks

Is there a 'wait' command in Access VB ?
Or a method to halt operation at a certain point
until a keypress or mouse click ?

Until now I've been using a msgbox to do this.

Thanks - Kirk

 

[MarkK]

Keypresses and mouse clicks are trappable events, and as such they want to initiate the execution of code. This being the case, it seems backwards to want to pause code execution until an event occurs.
Event Occurs -> Event Procedure handles event
I know this doesn't really answer your question, but you might be fighting the natural direction of cause and effect in your approach to the problem.
Care to say more about what you are trying to do?

 

[ghudson]

Hi Folks

Is there a 'wait' command in Access VB ?
Or a method to halt operation at a certain point
until a keypress or mouse click ?

Until now I've been using a msgbox to do this.

Thanks - Kirk

What are your trying to halt and for how long? A message box works if you need to user to "click" something before they can continue something.

 

[IR_Moon]

Hi I'm having a similar issue....

Basically my code goes a million miles an hour and does about 6 things... at the end of each of these 6 steps I'm trying to output a message to a text field on my form to let the user know whats going on... Only prob is the code executes WAY too fast and when I get to the processor intensive step 5 (takes roughly 2 minutes to execute) my text field hasn't updated leaving the user wondering what on earth is going on. I've tried programming a pop-up progress bar too which worked quite well when I was only doing the 2 minute long code execution, but now I've bundled a bunch of other stuff in, this suffers from the same problem... the main process takes over and I get NO progress bar :S Pausing to allow such things to update would be ideal

Any ideas?

 

[ghudson]

Pause

How to delay

Searching the forum is a great way to discover and learn the answers to your Access programming questions.

 

[IR_Moon]

Cheers ghudson... nice work!

Call me a forum n00b if you like!! I was trolling instead of searching...

I ended up initiating the status bar progress meter thru the syscmd function. Seems to work a treat, but I'm sure your code will come in handy! *bookmarked*