Listing Startup and Tools options in VBA

[RLN]

Re: Access 2003
Is there a way to list via text (or set via VBA) the items in the
Tools/Startup (App title, App Icon, Display Form Page, Show DB Window,
etc.) as well as items in the Tools/Options Tabs: (Advanced, View,
General, Edit/Find, etc….) I'm particularly interested in this since I
always customize the editor section of "tools".

I use 3 machines between home, the university and work. While I realize
the startup options can sometimes be application specific, I would like
to take my Access Startup Options and Tools Options and duplicate them
on the other two machines.
*** Sent via Developersdex http://www.developersdex.com ***

[Stuart McCall]

"RLN" <no*******@devdex.comwrote in message
news:12************@news.newsfeeds.com...

Re: Access 2003
Is there a way to list via text (or set via VBA) the items in the
Tools/Startup (App title, App Icon, Display Form Page, Show DB Window,
etc.) as well as items in the Tools/Options Tabs: (Advanced, View,
General, Edit/Find, etc..) I'm particularly interested in this since I
always customize the editor section of "tools".

I use 3 machines between home, the university and work. While I realize
the startup options can sometimes be application specific, I would like
to take my Access Startup Options and Tools Options and duplicate them
on the other two machines.
*** Sent via Developersdex http://www.developersdex.com ***

The commands you're looking for are Application.GetOption and
Application.SetOption. The definitive documentation for use of these methods
is:

http://msdn2.microsoft.com/en-us/lib...ffice.11).aspx

[RLN]

This is a great reference...thank you for this link.
*** Sent via Developersdex http://www.developersdex.com ***