J Jeff Conrad [MSFT] Oct 26, 2007 #2 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
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
G Guest Oct 26, 2007 #3 Jeff, in the runtime version that gives an error. Are you not able to open in runtime ? BrerGoose
J Jeff Conrad [MSFT] Oct 26, 2007 #4 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
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
G Guest Oct 27, 2007 #5 What is a good place to get a list of all the 2007 options that can be modified with VBA then ?
J Jeff Conrad [MSFT] Oct 30, 2007 #6 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
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
