Allow form to display fully

[Arry]

I am running so complex code from a form button. While the code is running i would like to display another form which displays the work busy.
I have included code from the button to Docmd. openform etc.. but the problem is that the form is not displayed fully. i e you get the outline but no text. i have tried to pause my code for 20 seconds but it still doesn't show the form fully.

I just need to have some sort of screen to show the database as working otherwise the users may think it has crashed etc...

Any Ideas.

 

[Oldsoftboss]

You may be able to include this progress meter. It needs to be put on the active form some where as it will run into the same problem you are presently having. Access will only process 1 thing at a time. Even if you put a Docmd.OpenForm at the start of the code, it seems to do the rest before actually oening the form.
Dave

 

[Arry]

Apologies.

I am running access 97 and cannot open your attachment.

 

[Oldsoftboss]

Sorry....

 

[Arry]

Apologies.

I am running access 97 and cannot open your attachment.

 

[Arry]

Okay, Thanks for that.

I think it may take a while to incorporate this but i will have a go.

Thanks for your help.

 

[Oldsoftboss]

The hardest thing is deciding how to update the counter.

 

[Arry]

yeah, i think that is going to be very tricky.

Could you update the counter on the number of seconds passed.
When the total is reached the counter would just start again.

Wouldn't really be a progress indicator but would so that the DB was working??

 

[Arry]

yeah, i think that is going to be very tricky.

Could you update the counter on the number of seconds passed.
When the total is reached the counter would just start again.

Wouldn't really be a progress indicator but would so that the DB was working??

 

[Oldsoftboss]

As I said, Access seems to only want to do one thing at a time, so counting the seconds AND running your code may be tricky. Good Luck.
Dave