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]

Re: Listing Startup and Tools options in VBA

"RLN" <nospamrln@devd ex.comwrote in message
news:1209070230 _373@news.newsf eeds.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.Get Option and
Application.Set Option. The definitive documentation for use of these methods
is:

http://msdn2.microsoft.com/en-us/library/aa172326(office.11).aspx

[RLN]

Re: Listing Startup and Tools options in VBA

This is a great reference...tha nk you for this link.


*** Sent via Developersdex http://www.developersdex.com ***