Solved

Access opens default form twice

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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

776 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