Solved

Access opens default form twice

Posted on 2013-05-17
5
422 Views
Last Modified: 2013-08-25
I have an Access application, running in 2003 mode, in Access 2010, on a server running Windows Server 2008 R2.

I have set a form called frmMainMenu to open on startup.  At startup, the following happens:
1. frmMainMenu is displayed twice, one version slightly overlapping the other, for a couple of seconds
2. the screen then goes blank for several seconds, with "Microsoft Access (not responding)" in the title bar
3. the application then opens, displaying frmMainMenu in the correct fashion

I have tried creating a new version of frmMainMenu - same problem.  I have also tried nominating a different form as the default - same problem.  I have also attempted to create a totally new database and import all the objects, but this did not work because there are over 1,000 of them, plus numerous ODBC links to the MySQL backend.

Advice on how to prevent this happening would be much appreciated.
0
Comment
Question by:Bellone
[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
  • 3
5 Comments
 
LVL 20

Expert Comment

by:clarkscott
ID: 39174680
Do you have any Form Events programmed (on open, on load, etc.).  
Also, do you star with a autoexec macro  or  is the apps form set to open upon load?

or perhaps it's both and thus your issue?

Scott C
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 39175240
Along the same lines, ...it looks like you have a start-up option to open the form.
You then might have code on the OnOpen (Or OnLoad) event of the form to open the form again.

Not really sure...
(This could even be a separate "Instance" of the form.)
I have also seen things like this that are issues with the screen/graphics.
Where the form moves, and the screen updates too slowly, ..Thus giving the appearance to the form being opened twice.

When did this problem start happening?
Can you post a simple version of the db that exhibits this issue?
0
 
LVL 5

Author Comment

by:Bellone
ID: 39186930
Hi Guys - thanks for your comments and apologies for the delay.

The form frmMainMenu does have an on-open event, but all this does is check the user's credentials.  In any event, I have tried using a different form at startup, with nothing on it but the words 'Main Menu', and it opens twice too.

I do have an autoexec macro, but all that does is causes the error trapping function to start, and it was only added quite recently.  The double-form phenomenon has been there for some weeks.

Boag2000 - I will try and reproduce the fault in a simple database and post it for you to see

Bellone
0
 
LVL 5

Accepted Solution

by:
Bellone earned 0 total points
ID: 39186967
Progress!  I took the 'Display form Main Menu' instruction out of Access Options in the File menu and, instead, used an open-form instruction in the Autoexec macro.  Result - the Main Menu only opens once.

The whole thing is still very slow to open - as described in 2 above - but I am wondering whether this may be a server problem?  It's a big, fast, new server, with dual processors and 32GB of RAM,  but what causes me to think this is that logging-in via RDP is also very slow.  Any thoughts?

Bellone
0
 
LVL 5

Author Closing Comment

by:Bellone
ID: 39436714
I believe I have sorted out the 'double-vision' problem myself.  The showness in opening referred to was caused by the error-trapping software needing a few seconds to open the query library.  I have hidden this delay with a 'Loading' form.
0

Featured Post

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

This article describes a serious pitfall that can happen when deleting shapes using VBA.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

623 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