Form Loading Status Bar

[edd]

I have some very complex forms that take around 1 minute
to open on my machine and around 5 minutes on the older
machines at my place of work.

I want to add some sort of bar that shows the percent
that the form has loaded so that pople have an idea of
how long remains.

Can anybody help with this??

Edd

 

[Nikos Yannacopoulos]

Edd,

Not sure this can be done, but the main problem remains the delay, which
seems rather long. You might find some useful tips to speed up your app in
the following link:

http://www.granite.ab.ca/access/performancefaq.htm


HTH,
Nikos

 

[Guest]

I have some very complex forms that take around 1 minute
to open on my machine and around 5 minutes on the older
machines at my place of work.

I want to add some sort of bar that shows the percent
that the form has loaded so that pople have an idea of
how long remains.

Can anybody help with this??

Edd

Edd ,
Do you have any code in the forms on_load or On_open events?

Rosco

 

[Edd]

Nikos

Thanks for the response, setting the recordsource at
runtime using the Form_Load Event seems a logical step in
improving the speed at which my forms open.

I will try these tips and report back ASAP.

Thanks again!

Edd

 

[Edd]

Made changes, now assigning recordsources/rowsources on
form_load - identified massive improvements, < 1 minute
to load, system build time greatly improved.

I-OWE-U-1

TY

Edd

 

[Nikos Yannacopoulos]

Edd,

Glad you got improvement. The three tips I have found to make a big
difference are the subdatasheet > none, the persistent recordset (if split
db), and the name autocorrect. Did you try those?

Nikos