Setting VBA Options Via Code

  • Thread starter Thread starter dch3
  • Start date Start date
D

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.
 
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.
Click to expand...

Look up the SetOption and GetOption methods in VBA help.
 
::: 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
 
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.
 
Back
Top