By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,225 Members | 1,434 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,225 IT Pros & Developers. It's quick & easy.

Access Freezes

P: n/a
On a button event, I call a VB subroutine.
The subroutine takes some time, it is importing from excel.
I have a progressbar that works while the subroutine is looping.

Before the loop I write the excel worksheet name to an unbounded text
field next to the button.

It does not appear in the text box until the looping is done.
Also my VB and Access windows are frozen until looping is done.

I thought it may be that there is no time left for other processes, I
used the sleep API, but it did not work as I thought it would.
Any IDEAS?

Access Access Access ....

Thanks

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Chuck,

Take a look at the DoEvents function.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com

If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee.
Over 1000 Access users have come to me for help.
Need a month calendar or 7 day calendar? Contact me.
<ch*********@gm.com> wrote in message
news:11*********************@o13g2000cwo.googlegro ups.com...
On a button event, I call a VB subroutine.
The subroutine takes some time, it is importing from excel.
I have a progressbar that works while the subroutine is looping.

Before the loop I write the excel worksheet name to an unbounded text
field next to the button.

It does not appear in the text box until the looping is done.
Also my VB and Access windows are frozen until looping is done.

I thought it may be that there is no time left for other processes, I
used the sleep API, but it did not work as I thought it would.
Any IDEAS?

Access Access Access ....

Thanks

Nov 13 '05 #2

P: n/a

"PC Datasheet" <no****@nospam.spam> schreef in bericht news:k0*****************@newsread1.news.atl.earthl ink.net...
If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee.
Over 1000 Access users have come to me for help.
Need a month calendar or 7 day calendar? Contact me.


These 1000 (if at all a real figure..) is only the result of
-- 4 years abusing the newsgroups.
-- 4 years blatantly advertising and job hunting.

You only care about making money, and you act as if the groups are your private hunting ground.
So why would ANYBODY ever trust a person like you and hire you?
************************************************** ******

Explanation and more on this answer to Steve:
http://home.tiscali.nl/arracom/stopsteve.html

Arno R
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.