Solved

Access Form takes too long to load

Posted on 2013-11-24
3
691 Views
Last Modified: 2013-11-27
I have an access form with several sub-forms that takes too long to load.

I have used the Page control so that each sub-form is on a separate page because the users don't need to see all the info in one go, but they do need quick access when required.

Something I have tried is to make the sub-form control unbound and then use the Page's on_click event to set the Source Object value.  However, clicking the page's tab doesn't seem to trigger the on_click event.  The user has to click the middle of the page, which means an extra click is required.

What other techniques can I use to speed-up the load?
0
Comment
Question by:LJKMartin
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 61

Expert Comment

by:mbizup
ID: 39672620
You can use the tab control's change or after update event and use a select case statement to bind/unbind subforms according to the selected tab.

But I would also recommend looking into using separate forms to handle some of the subforms, especially if your tabs/subforms contain a lot of bound controls.  That really adds up in slowing your forms down.
0
 
LVL 61

Accepted Solution

by:
mbizup earned 400 total points
ID: 39672689
This shows the Tab Control Change event method I mentioned:
http://www.fmsinc.com/microsoftaccess/performance/Forms/LateBinding.asp

Also worth looking into are these form performance tips:
http://www.fmsinc.com/microsoftaccess/Performance.html#Forms

(Note that this article also suggests minimizing the number of controls on a form, citing loading controls as the 'biggest performance hit when loading a form')
0
 
LVL 24

Assisted Solution

by:Bitsqueezer
Bitsqueezer earned 100 total points
ID: 39674251
Hi,

if you have at least Access 2007 I would recommend to use a ribbon instead. You can for example add a tab with all the page headers as buttons so this would give the user quick access to all forms in the same way as a register can. But the difference is that only the needed form will be loaded when the button in the ribbon is clicked.

Additionally if you switch the forms to "tabbed controls" (default for new databases since Access 2007) you already have tabs which the user can click. So if you have that setting and the ribbon you can quickly open the needed form and switch between any opened form - and the user has full control over all forms which should be open at the same time.

You can of course do that also with MDI forms or popup forms but in this case you would need to use a window switch control in the ribbon if the wanted form is under another.

Cheers,

Christian
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
linked sql server tables - should I or shouldn't I and why 4 61
docmd has stopped working 3 43
Access Form - Button Format Issue 13 43
access vba 5 55
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question