Ctl-n Closes Database

[JamesJ]

Never heard of this one.
In Access 2007 I inadvertently pressed ctl-n instead of ctl-b to bold some
text.
My database closed, well I should say all objects closed and I am presented
with the 'Getting Started with Microsoft Office Access' screen. Except that
there
are no 'Open Recent Database' on the right side, simply a picture.
I have searched help for key combinations but didn't find anything that
helped.
Is this normal? Doea this key combination actually close the db in the
fashion
I described?

Thanks,
James

 

[Peter Hibbs]

James,

I don't think it closes the database, as such, it starts a new one.

On the version that you give to your users you should disable this
control code and a few others, otherwise your users will create
mayhem.

To do this create a new Macro (I don't know how you do this in 2007)
and enter the following in the Macro Name column (on separate lines).

^N
^O
^S
^P
^W
^G

Leave the Action column blank for each one. Save the Macro as AutoKeys
(important you use this name).

Try pressing CONTROL + O, etc before you do this to see what happens
(and what you users would do if they did it accidentally).

HTH

Peter Hibbs.

 

[JamesJ]

Right, it presents me with the new database screen and I can press esc to
exit back
to my db.
One question though. After creating this macro where do I assign it? Do I
call
it from my AutoExec macro or do I need to reference it at all?

James

 

[Peter Hibbs]

James,

No, you don't need to do anything else (assuming 2007 is the same as
earlier versions). The AutoKeys Macro will run by itself at start up.

Peter Hibbs.

 

[JamesJ]

Got it.

Thanks,
james

James,

No, you don't need to do anything else (assuming 2007 is the same as
earlier versions). The AutoKeys Macro will run by itself at start up.

Peter Hibbs.