Solved

Access opens default form twice

Posted on 2013-05-17
5
408 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
  • 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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Suggested Solutions

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…

932 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now