Link to home
Create AccountLog in
Avatar of Bellone
Bellone

asked on

Access opens default form twice

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.
Avatar of clarkscott
clarkscott
Flag of United States of America image

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
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?
Avatar of Bellone
Bellone

ASKER

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
ASKER CERTIFIED SOLUTION
Avatar of Bellone
Bellone

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Bellone

ASKER

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.