Access 2007

[Guest]

What code do I write to open the Access 2007 Options form ?

 

[Jeff Conrad [MSFT]]

This should do it:

DoCmd.RunCommand acCmdOptions

--
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

 

[Guest]

Jeff, in the runtime version that gives an error. Are you not able to open
in runtime ?
BrerGoose

 

[Jeff Conrad [MSFT]]

I'm not 100% positive, but I don't think you can open the Access Options
dialog in the runtime environment.

--
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

 

[Guest]

What is a good place to get a list of all the 2007 options that can be
modified with VBA then ?

 

[Jeff Conrad [MSFT]]

Off the top of my head, I'm not sure if there is a definitive list posted
somewhere.

--
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com