[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

VBA Code to make a procudure stop/pause/wait for X number of seconds

Posted on 2004-11-22
6
Medium Priority
?
265 Views
Last Modified: 2008-01-09
I know this has been asked before, but i'm pulling my hair out trying to find a solution.

I just need a peice of code that i can insert half way into a procedure that will cause the procedure to pause for a second or so.

Using just Standard Access 2000

Thanks in advance!
0
Comment
Question by:lightcomputers
  • 3
  • 3
6 Comments
 
LVL 41

Accepted Solution

by:
shanesuebsahakarn earned 500 total points
ID: 12644840
0
 
LVL 1

Author Comment

by:lightcomputers
ID: 12666620
Not really what i'm looking for - any more ideas??
0
 
LVL 41

Expert Comment

by:shanesuebsahakarn
ID: 12666765
Why isn't it what you are looking for?
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 1

Author Comment

by:lightcomputers
ID: 12666809
I dont really need a timer in there - that will just complicate things
0
 
LVL 41

Expert Comment

by:shanesuebsahakarn
ID: 12666827
Sorry, I don't follow you. If you want your code to wait for, say, 5 seconds, you just call the sSleep sub with:
sSleep 5000
0
 
LVL 1

Author Comment

by:lightcomputers
ID: 12666840
Errrm - ok, you win!
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question