A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How to display progress on slow opening form.



 
 
Thread Tools Display Modes
  #1  
Old May 29th, 2010, 10:32 PM posted to microsoft.public.access.forms
cr113
external usenet poster
 
Posts: 33
Default How to display progress on slow opening form.


I've got a form1 that calls form2. The load event of form2 takes
several minutes to run, it has to do a lot of data processing. I'd
like to display some sort of message that either shows how the load is
progressing or at the very least that this is going to take awhile.
The problem is I can't seem to get control of the screen while the
load is taking place, it's basically locked up.
  #2  
Old May 29th, 2010, 11:21 PM posted to microsoft.public.access.forms
cr113
external usenet poster
 
Posts: 33
Default How to display progress on slow opening form.

On May 29, 4:32*pm, cr113 wrote:
I've got a form1 that calls form2. The load event of form2 takes
several minutes to run, it has to do a lot of data processing. I'd
like to display some sort of message that either shows how the load is
progressing or at the very least that this is going to take awhile.
The problem is I can't seem to get control of the screen while the
load is taking place, it's basically locked up.


I forgot to mention I'm using Access 2007.
  #3  
Old May 30th, 2010, 09:43 AM posted to microsoft.public.access.forms
Jeanette Cunningham
external usenet poster
 
Posts: 2,190
Default How to display progress on slow opening form.

Create another form that shows the message about taking a long time and open
it just before you open the form that is slow to load.
When the slow form has loaded, then you can close the form with the message.

If you want to show a progress bar, there is a sample one in Albert Kallal's
Word Merge sample database.

Open this page
http://www.members.shaw.ca/AlbertKal.../msaccess.html

and scroll down to Super Easy Word Merge. Download the 2000 merge code.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


"cr113" wrote in message
...
On May 29, 4:32 pm, cr113 wrote:
I've got a form1 that calls form2. The load event of form2 takes
several minutes to run, it has to do a lot of data processing. I'd
like to display some sort of message that either shows how the load is
progressing or at the very least that this is going to take awhile.
The problem is I can't seem to get control of the screen while the
load is taking place, it's basically locked up.


I forgot to mention I'm using Access 2007.


  #4  
Old May 30th, 2010, 04:37 PM posted to microsoft.public.access.forms
cr113
external usenet poster
 
Posts: 33
Default How to display progress on slow opening form.

On May 30, 3:43*am, "Jeanette Cunningham"
wrote:
Create another form that shows the message about taking a long time and open
it just before you open the form that is slow to load.
When the slow form has loaded, then you can close the form with the message.



I tried that but couldn't get it to work. The form with the loading
message doesn't display. I tried changing the modal and popup settings
and it still didn't work. Here's my code in form1:

Private Sub Command0_Click()
DoCmd.OpenForm "FormWithLoadMessage"
DoCmd.OpenForm "Form2"
End Sub








If you want to show a progress bar, there is a sample one in Albert Kallal's
Word Merge sample database.

Open this pagehttp://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

and scroll down to Super Easy Word Merge. Download the 2000 merge code.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

"cr113" wrote in message

...
On May 29, 4:32 pm, cr113 wrote:

I've got a form1 that calls form2. The load event of form2 takes
several minutes to run, it has to do a lot of data processing. I'd
like to display some sort of message that either shows how the load is
progressing or at the very least that this is going to take awhile.
The problem is I can't seem to get control of the screen while the
load is taking place, it's basically locked up.


I forgot to mention I'm using Access 2007.


  #5  
Old May 30th, 2010, 10:29 PM posted to microsoft.public.access.forms
Jeanette Cunningham
external usenet poster
 
Posts: 2,190
Default How to display progress on slow opening form.

I would use the 'form with load message' to open form2.
You could use the current event of 'form with load message' to open form2
hidden.
At the last line of code in the load event of form2, you could make form2
visible then close 'form with load message'.

You mentioned that there is a lot of code on form2 that runs, perhaps some
or all of that code could be run before you open form2?
There are variations on the way to do this, depending on what that long
running code is doing and where it gets the values it needs to be able to
run.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

"cr113" wrote in message
...
On May 30, 3:43 am, "Jeanette Cunningham"
wrote:
Create another form that shows the message about taking a long time and
open
it just before you open the form that is slow to load.
When the slow form has loaded, then you can close the form with the
message.



I tried that but couldn't get it to work. The form with the loading
message doesn't display. I tried changing the modal and popup settings
and it still didn't work. Here's my code in form1:

Private Sub Command0_Click()
DoCmd.OpenForm "FormWithLoadMessage"
DoCmd.OpenForm "Form2"
End Sub








If you want to show a progress bar, there is a sample one in Albert
Kallal's
Word Merge sample database.

Open this
pagehttp://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

and scroll down to Super Easy Word Merge. Download the 2000 merge code.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

"cr113" wrote in message

...
On May 29, 4:32 pm, cr113 wrote:

I've got a form1 that calls form2. The load event of form2 takes
several minutes to run, it has to do a lot of data processing. I'd
like to display some sort of message that either shows how the load is
progressing or at the very least that this is going to take awhile.
The problem is I can't seem to get control of the screen while the
load is taking place, it's basically locked up.


I forgot to mention I'm using Access 2007.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:19 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.