Bypass Shift function

[Eric]

In Access, you can hold the shift key down to bypass
startup functions. Is there a way to bypass this? or
password it so that only one person can access the
data/forms/etc?

Also can I programmaticaly controll menu items?
e.g. File/Edit/View/etc and Tool bars.

 

[Douglas J. Steele]

You can create an AllowBypassKey property for the database and set it to
False.

See http://www.mvps.org/access/general/gen0040.htm for the proper way to do
this (the example in the Help file neglects to use the 4th DDL argument, so
it's easily reset)

You can also apply Access Security it you only want to allow one person to
be able to get to the objects.

I'm not 100% certain what you're looking for in your last question. You can
programmatically work with the Menu items. One way involves adding a
reference to Office in your application. Once you've done that, you can work
with the CommandBars collection, such as is shown in
http://msdn.microsoft.com/library/en-us/office97/html/output/F1/D6/S5B306.as
p

 

[Albert D. Kallal]

In Access, you can hold the shift key down to bypass
startup functions. Is there a way to bypass this? or
password it so that only one person can access the
data/forms/etc?

Yes, I have some code here that lets you browse to any mdb/mde file, and
set/un-set the shift by-pass.

You can check it out here:
http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html

Also can I programmaticaly controll menu items?
e.g. File/Edit/View/etc and Tool bars.

Yes, the best way is not to use code. Try downloading my sample ap here:
http://www.attcanada.net/~kallal.msn/msaccess/DownLoad.htm

(grab the 3rd one). If you run it...note how when you jump from one form to
another, the options on the menu bar change. It did not take code to make
those menu change.

 

['69 Camaro]

Hi, Eric.

In Access, you can hold the shift key down to bypass
startup functions. Is there a way to bypass this?

You can find the code for disabling the AllowBypassKey on this Web page:

http://www.mvps.org/access/general/gen0040.htm

Also can I programmaticaly controll menu items?
e.g. File/Edit/View/etc and Tool bars.

You can create your own custom CommandBars and display them instead of the
built-in CommandBars to allow the users to see only what you want them to
see. You can programmatically control whether the built-in menu and
Toolbars are displayed at startup by setting the Database Properties, such
as AllowFullMenus and AllowBuiltInToolbars, but it would probably be easiest
to set these properties using the Startup dialog window.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)