?
Solved

Quickie.  Why do I have to press "shift" when I click on my database to open it

Posted on 2013-02-01
16
Medium Priority
?
331 Views
Last Modified: 2013-02-01
Hi,

I was tinkering a few days ago and changed a fundamental part of my database.

Now, I am forced to press "shift" if I want to open my database in full design mode.

How do I reverse this change?
0
Comment
Question by:Patrick O'Dea
[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
  • 10
  • 5
16 Comments
 
LVL 75
ID: 38845477
Holding down Shift prevents (bypasses) the AutoExec macro from running AND prevent (bypasses) any StartUp form (in options) from opening.

So ... look at your Auto Exec macro.

mx
0
 
LVL 58
ID: 38845481
You added an autoexec macro or a startup form in options.

Jim.
0
 
LVL 75
ID: 38845490
1
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:Patrick O'Dea
ID: 38845493
Nope!  There does not appear to be an autoexec.

..I attach the database!

(...all a bit embarrassing ... considering I put the restriction there and can't remember)

The "Mainmenu" is the first form used.
EnnisBudgetActuals.accdb
0
 
LVL 75
ID: 38845504
1
0
 
LVL 75
ID: 38845508
1
0
 
LVL 75
ID: 38845513
This code is running:

1
0
 

Author Comment

by:Patrick O'Dea
ID: 38845543
Thanks DatabaseMX,

I can see the code that is running from "MainMenu" but can't see why this is forcing my "shift" start that I asked about.

Am I missing something?? (I must be!)
0
 
LVL 75
ID: 38845558
Well ... for one thing,  that code is Maximizing the main form.  Of course, it's your choice to hold the Shift key down.

Is this causing you a problem ?  If you need to get in for dev work, then hold down Shift key to bypass that form opening, etc., and get to your objects in the Nav Pane, etc.

mx
0
 

Author Comment

by:Patrick O'Dea
ID: 38845585
mx,

I removed the maximise command.  But to little avail..

I have solved the problem by creating a new database and "importing" all the forms from the original.

Nonetheless I am baffled when I need to "shift" the original database.
(I do not need to "shift" the new database).
0
 
LVL 75
ID: 38845609
" But to little avail.."
Well, not sure what you mean by that?
The form will still open. You can stop that by the property 'Display Form' (image above) to None.  This will keep that form from opening.

Is this what you are trying to stop?

Sorry ... I'm not clear what the actual issue is.

You should not have had to create a new db in this case ...

All holding down the Shift key does is ... either bypass running an AutoExec macro (if present) and/or opening a Form specified in the Display Form property.
0
 

Author Comment

by:Patrick O'Dea
ID: 38845629
Let me try and clarify;

I have 20 databases. 19 behave in the same way.

To open each one of the 19  I simply click on the file and it opens with full view of;
 "File    Home   Create   External Data    Database Tools"

However, the problematic database only gives the "File  Home" options.

Why do I have to press "shift" when opening one database whereas the 19 other databases all do not require this.


(Does this help explain things?)
0
 
LVL 75
ID: 38845656
yes ... ok, let me take a look ....
0
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 2000 total points
ID: 38845663
You need to check (select) the two options shown in the Image ...

1
0
 

Author Closing Comment

by:Patrick O'Dea
ID: 38845684
That's it.

I was playing around with some of these options a couple of days ago.

Thanks again for all your help.
0
 
LVL 75
ID: 38845701
Sure - you are welcome.
mx
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Suggested Courses

762 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