Speed Opening Forms for First Time

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

richard - 13 Sep 2007 16:08 GMT

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

Reply to this Message

Allen Browne - 13 Sep 2007 16:19 GMT

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.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> 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
[quoted text clipped - 15 lines]
>
> Richard

Reply to this Message

UpRider - 13 Sep 2007 21:41 GMT

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

> Hi
>
[quoted text clipped - 17 lines]
>
> Richard

Reply to this Message