Setting VBA Options Via Code

[dch3]

Is there a way to use code to programmically set options that appear in the
VBA Editor's TOOLS > OPTIONS dialog?

I would like use code to set the Error Handling to Break on Unhandled Errors.

 

[fredg]

Is there a way to use code to programmically set options that appear in the
VBA Editor's TOOLS > OPTIONS dialog?

I would like use code to set the Error Handling to Break on Unhandled Errors.

Look up the SetOption and GetOption methods in VBA help.

 

[dch3]

The online MSDN documentation didn't list those specific items.

 

[dch3]

::: RANTING :::
That *&@#^*$ MS Documentation, why the *@#&$^@* isn't it complete and
consistent.

::: SHOUTING :::
Why the @*(#$& does one bit of information provide you with a partial list
of options, while another *&#$^*@ bit provides you with other information?

::: STOMPING :::
Why the @*(#$&@(* is the only mention of the get/setOption("Error Trapping")
a *@&#$^8 note at the very bottom of the *&^@$ page in Access VBA help? Why
wasn't it explicity #*@&$^ listed in the MSDN documentation on line?

....and just today I decided to put into a scifi-Hitchiker-esque story that
I'm writting a HELP hologram that's never any help at all. "I'm sorry for
information on using the application please refer to the user's manual", (or
my favorite - the user's scream HELP and his response is "I'm sorry I didn't
understand that. Please restate your request.")

David H

 

[Stuart McCall]

The online MSDN documentation didn't list those specific items.

It does if you know where to look:

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

 

[dch3]

How utterly ridiculous of me to think that it'd make sense to have a table
for the options that are set via the VBA editor? God forbid that MS should
make it easy. Of course, it'd only make sense to put it as a foot note at the
bottom, how silly of me not to immediately scroll down to the bottom or to
look through the tables without reading the text above and below each.