I have created a form for my supervisor so she can see all the pertinent information related to her hosptial accounts. (See attachment) The challenge I am having is the form takes a while to load. All of the tabs are build on different queries. Does anyone have some advice on how to speed up loading of the forms?
Form with multiple tabs loads very slow
- Thread starter cgemmill1
- Start date
Rx_
Nothing In Moderation
- Local time
- Today, 15:05
- Joined
- Oct 22, 2009
- Messages
- 2,803
Each of the forms in the tab are opening as you said.
You will need to look at each form and determine how to open it faster.
For example: if you are using a table for the form's recordset - can you use a query?
Is the form opening some first item in a list box. Could that be delayed.
You will need to look at each form and determine how to open it faster.
For example: if you are using a table for the form's recordset - can you use a query?
Is the form opening some first item in a list box. Could that be delayed.
spikepl
Eledittingent Beliped
- Local time
- Today, 23:05
- Joined
- Nov 3, 2010
- Messages
- 6,142
Performance of each subform:
http://www.fmsinc.com/microsoftaccess/performance.html
http://office.microsoft.com/en-us/a...rmance-of-an-access-database-HP005187453.aspx
http://www.granite.ab.ca/access/performancefaq.htm
and then, you can select to load each subform when its corresponding tab is clicked, rather than all of them at once
http://www.fmsinc.com/microsoftaccess/performance.html
http://office.microsoft.com/en-us/a...rmance-of-an-access-database-HP005187453.aspx
http://www.granite.ab.ca/access/performancefaq.htm
and then, you can select to load each subform when its corresponding tab is clicked, rather than all of them at once
