Solved

Access opens default form twice

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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

This collection of functions covers all the normal rounding methods of just about any numeric value.
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

758 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

18 Experts available now in Live!

Get 1:1 Help Now