Turn off the "Type a question" in menu

[Guest]

Is there a way the programatically turn off the "Type a question for help" at
the right end of the toolbar.

I have tried to uncheck it from the customize option for toolbars. It works
fine for me on my computer, but when the application is started from another
users machine, the option is back in the toolbar. I have even created a
custom menu, and not put anything in it. The same thing occurs. This seems
to be Access specific. So I though I would see if there is a way to
programatically turn this option off at runtime.

Thanks in advance for any help on this.

Mr B

 

[Guest]

Hi, Mr. B.

Is there a way the programatically turn off the "Type a question for help" at
the right end of the toolbar.

Yes. Try:

Public Sub removeCboAskAQ()

On Error GoTo ErrHandler

Application.CommandBars.DisableAskAQuestionDropdown = True

Exit Sub

ErrHandler:

MsgBox "Error in removeCboAskAQ( )." & vbCrLf & vbCrLf & _
"Error #" & Err.Number & vbCrLf & Err.Description
Err.Clear

End Sub


HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.

 

[Guest]

Thank you so much, '69 Camaro,

I really appreciate it. I did not know what the code was. Can you point me
to where you would find this kind of thing?

 

['69 Camaro]

Hi.

Can you point me
to where you would find this kind of thing?

I found it in the Object Browser, but I already had a reference set to the
Microsoft Office 11.0 Object Library, so I can easily see it. Another way
is to use Intellisense and start typing:

Application.CommandBars.

.. . . and when you type the period, the combo box shows a list of the
CommandBars class members, including DisableAskAQuestionDropdown, but you
have to know that this is a property with a boolean data type, so that you
can type the appropriate value to make it a valid VBA statement:

Application.CommandBars.DisableAskAQuestionDropdown = True

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[david epsom dot com dot au]

to where you would find this kind of thing?

Go to Google (www.google.com) and paste in

"Type a question for help" group:*access*

You'll have to sort through a couple of different kinds
of solutions, but the code solution is one of them.

(david)