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.

On Wed, 9 Jul 2008 21:39:00 -0700, dch3 wrote:

> 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.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

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

"fredg" wrote:

> On Wed, 9 Jul 2008 21:39:00 -0700, dch3 wrote:
>
> > 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.
> --
> Fred
> Please respond only to this newsgroup.
> I do not reply to personal e-mail
>

::: 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

"fredg" wrote:

> On Wed, 9 Jul 2008 21:39:00 -0700, dch3 wrote:
>
> > 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.
> --
> Fred
> Please respond only to this newsgroup.
> I do not reply to personal e-mail
>

"dch3" <(E-Mail Removed)> wrote in message
news:BED96996-F7C0-47C8-9EF6-(E-Mail Removed)...
> 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

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.


"Stuart McCall" wrote:

> "dch3" <(E-Mail Removed)> wrote in message
> news:BED96996-F7C0-47C8-9EF6-(E-Mail Removed)...
> > 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
>
>
>