"Type a question for help" box

[Silvester]

Hi,

Does anyone know how to programmatically get rid of the "Type a question for
help" Helpbox that appears on the top right of the Access XP toolbar ?

Thanks for any info

 

[[MVP] S.Clark]

That is a built-in menu bar, which you can disallow in the Startup Dialog
box. By Disallowing, you will also loose some of the functionality
associated to the rest of the menu bar, but you can create your own menu
bars that don't have the question box.

 

[Steve Huff]

I was looking into this question and became baffled myself as I usually only
use Access 2000. In Access XP that "Type a question for help" box seems
quite tricky. I read this MS article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;283633

That seems to be specific to how you customize your copy of Access, so
turning it off for you will not turn it off for the user on another machine
using your DB. I tried to create a custom toolbar and set that as the
default but the custom toolbar also shows that "Type a question for help"
box and I assume that turning it on and off is again specific to your copy
of Access isn't it? I would think you would have to find the registry
setting and manually change it back and forth when you launch your MDB file
unless Micrsoft has provided a way to do it in code??

--Steve Huff

 

[Silvester]

Thanks for the info. There must be some way to disable it on app startup and
reenable on app shutdown ??

 

[Steve Huff]

Here is a registry setting to turn it off then you'd have to delete the
setting to turn it back on:

http://www.winguides.com/registry/display.php/1002/

There is code out there you can lookup for working with the registry in VBA.

I highly recommend that you check to see if it's on before you turn it off
so you can set it back to the setting they had previously.

--Steve Huff

 

[Silvester]

Wow, looks dangerous ! Can't we manipulate access on startup using vba ?