Speed Opening Forms for First Time

[Guest]

Hi

I have created a database which seems to be working ok, however when the
user is entering the a form for a first time after opening the database there
is quite a delay (approx 10seconds) not huge but rather frustrating. The form
once opened and used, closed and then opened again opens with no delay. This
is the same with all the forms.
They all have the following elements
1 Comboboxes
2 Subform(s)
3 Command Buttons

Has anyone any ideas why this would be so and if so any (polite) suggestions

Thanks

Richard

 

[Allen Browne]

First place to start would be with Tony Toews performance FAQ for Access:
http://www.granite.ab.ca/access/performancefaq.htm

It's quite a list, but really worth your working your way through--item by
item.

 

[UpRider]

Richard, you could have the autoexec macro call a function that opens all or
some of the forms hidden at startup:

Function fcnStartup
With DoCmd
.OpenForm "frmDataEntry", , , , , acHidden
.OpenForm "frmDBTCReports", , , , , acHidden
.OpenForm "frmShops", , , , , acHidden
'etc
End With
End Function

This would move the delay to the startup of the application. It might be
more acceptable with the morning coffee.

UpRider