Application.Assistant.On = False

When I compile

Application.Assistant.On = False

I get an error complaining "Method or data
member not found". I'm unable to turn off the
Assistant. Its annoying.

Try "Visible" instead of "On".

--
Wayne Morgan
MS Access MVP


"MLH" <CRCI@NorthState.net> wrote in message
news:7r9592tofdg3nalbujnbp71t4citoagbv0@4ax.com...[color=blue]
> When I compile
>
> Application.Assistant.On = False
>
> I get an error complaining "Method or data
> member not found". I'm unable to turn off the
> Assistant. Its annoying.[/color]

Alright, I got no compilation error. I ran it in the immediate
window, hoping the little bubble with the question mark in
it would go away from the toolbar. It didn't. Clicking on it,
the darned paperclip started its dance. Am I supposed to
notice anything different after running the line?

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx


On Fri, 16 Jun 2006 13:18:14 GMT, "Wayne Morgan"
<comprev_gothroughthenewsgroup@hotmail.com> wrote:
[color=blue]
>Try "Visible" instead of "On".
>
>--
>Wayne Morgan
>MS Access MVP[/color]

Sorry, I didn't dig deeply enough the first time. "On" and "Visible" are
both good properties. On enables/disables the assistant while Visible just
hides it but leaves it enabled in case you ask for help again. Your syntax
appears to be correct. The first thing I would check for would be a typo in
the spelling of the line. Check for extra embedded spaces also. If that
doesn't fix it, then I would suggest checking the References. For more
information on this, follow this link.

http://www.allenbrowne.com/ser-38.html

--
Wayne Morgan
MS Access MVP


"MLH" <CRCI@NorthState.net> wrote in message
news:i6b692h7vmv2t1u22hr2mpvde2i3tdlrtl@4ax.com...[color=blue]
> Alright, I got no compilation error. I ran it in the immediate
> window, hoping the little bubble with the question mark in
> it would go away from the toolbar. It didn't. Clicking on it,
> the darned paperclip started its dance. Am I supposed to
> notice anything different after running the line?[/color]