Hello:
I have disabled the Menu bars using Startup
options and want that enforced. I only see a trivial
difference between enabling and disabling the SHIFT
bypasskey. If the AllowByPassKey property is set to True,
then on opening the database, the Startup Options are
ignored and the Menu bars are active and DB window is
open. On setting the "AllowByPassKey" property to False,
as long as I *hold* the SHIFT key pressed, the menu bar is
visible and accessible. Only on releasing the SHIFT key,
the Startup options are enforced. I don't see how that
helps as the Tools Menu exposes the all-important Startup
options!

But, I am reading everywhere that I can set the
AllowByPassKey to False to completely disable the use of
the SHIFT key and strictly enforce the Startup options.

Please advise! I am up against a deadline that is fast
approaching.

Thanks.

No, you information is wrong. If you disable the shift key by-pass, then the
start-up setting ALWAYS run.

Of course, you have to set the allowbypass key, and THEN EXIT the database.
From that point on, the database will ignore the by-pass settings. If you
don't give you self some option to un-do this, you will lock your self out.

You can grab my sample code that lets you browse to your mdb or mde file,
and set the by-pass setting. Just don't give this program to your users! So,
my example code is kind of nice, since then you don't have to have the
by-pass setting code in your application.

You can find this utility that lets browse to and set the by-pass setting
for a mde or mde file at:

http://www.attcanada.net/~kallal.msn.../msaccess.html


--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
(E-Mail Removed)
http://www.attcanada.net/~kallal.msn

I was not able to duplicate your example. However, give the following mdb a
try:

http://www.attcanada.net/~kallal.msn...ordMerge22.zip

I have disabled the shift key by pass. I also set the main menu bar to my
custom bar (as you really need to do also).

I don't have any code that "deactivates" the menu bar in the above. I just
used the start-up options, and did specify a menu bar for the application.

If the main menu bar does not dis-appear when you hold down the shift key,
then that might be the case. I don't know of a work around, but then I never
had that problem, as I always build a replacement menu bar anyway.

I will bet you are hard pressed to find any application on your computer
that does not have a menu bar, so, it makes little sense to be the only
software developer that does not have a menu bar.

I never used code to hide anything...and did not think you do need any code!

Try the above. (actually, give the word merge thing a try too...you might
like it!)

--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
(E-Mail Removed)
http://www.attcanada.net/~kallal.msn

Thanks for the app, Mr. Kallal.

Much thanks to you, I think I have found a way to do what
I want to do... But, if you have time, please try this
out.
A. Open the WordMerge22 database with SHIFT pressed. You
will see the default Toolbar visible as long as you press
the SHIFT key but none of the Menu can actually be clicked.
Great, what's what I want to do in my case too!
B. Enable the bypasskey. Then, enter Start-Up and do the
following changes:
(1) Change Menubar to "default"
(2) Uncheck the Allow Full Menus box. In other words, you
are asking Access not to allow the default Full Menu.
Now disable the bypass key and when you try opening the
database while pressing SHIFT, do you notice the Menu
active? Isn't that weird?





>-----Original Message-----
>I was not able to duplicate your example. However, give
the following mdb a
>try:
>
>http://www.attcanada.net/~kallal.msn...ss/WordMerge22.
zip
>
>I have disabled the shift key by pass. I also set the
main menu bar to my
>custom bar (as you really need to do also).
>
>I don't have any code that "deactivates" the menu bar in
the above. I just
>used the start-up options, and did specify a menu bar for
the application.
>
>
If the main menu bar does not dis-appear when you hold
down the shift key,
>then that might be the case. I don't know of a work
around, but then I never
>had that problem, as I always build a replacement menu
bar anyway.
>
>I will bet you are hard pressed to find any application
on your computer
>that does not have a menu bar, so, it makes little sense
to be the only
>software developer that does not have a menu bar.
>
>I never used code to hide anything...and did not think
you do need any code!
>
>Try the above. (actually, give the word merge thing a try
too...you might
>like it!)
>
>--
>Albert D. Kallal (MVP)
>Edmonton, Alberta Canada
>(E-Mail Removed)
>http://www.attcanada.net/~kallal.msn
>
>
>.
>

"Arp" <(E-Mail Removed)> wrote in message
news:0c8201c3682f$f45b94a0$(E-Mail Removed)...
> Now disable the bypass key and when you try opening the
> database while pressing SHIFT, do you notice the Menu
> active? Isn't that weird?

Yes it's visible until you get off the shift key, but it isn't active i.e.
you can't actually open any menu and do anything.

--
Joan Wild
Microsoft Access MVP

Oh, I could actually use the Tools Menu, and importantly,
the pivotal Startup options. I hope you selected "default"
as the Menu Bar.

>Yes it's visible until you get off the shift key, but it
isn't active i.e.
>you can't actually open any menu and do anything.
>
>--
>Joan Wild
>Microsoft Access MVP
>
>
>.
>

I just tested this in one of my applications, and could not use any of the
menus (even though I could see them with the shift key down)

--
Joan Wild
Microsoft Access MVP

"Arp" <(E-Mail Removed)> wrote in message
news:086f01c36999$1ec86c30$(E-Mail Removed)...
>
> Oh, I could actually use the Tools Menu, and importantly,
> the pivotal Startup options. I hope you selected "default"
> as the Menu Bar.
>
> >Yes it's visible until you get off the shift key, but it
> isn't active i.e.
> >you can't actually open any menu and do anything.
> >
> >--
> >Joan Wild
> >Microsoft Access MVP
> >
> >
> >.
> >