Setting VBA Options Via Code

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.
 
F

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.
 
D

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
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top