Access Freezes

[chuck.streb]

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

[PC Datasheet]

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

[Arno R]

"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