Access 97 - Setting Startup

[Jennifer]

Has anyone ever tried to program in vba code the startup.
I need to set two different startup functions based on the
user. I cannot find any code to show me how to disable the
Holding the shift key on startup. I have seen reference to
the "AllowBypassKey" and know i need to set this to false.
But where is it???

Any help is much appreciated.
Thanks

 

[Arvin Meyer]

Here's the code you need:

http://www.mvps.org/access/general/gen0040.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Albert D. Kallal]

Unfortunately, when you make the shift key setting, you have to be ALREADY
in the system. So, you would have to set the shift key, and then
exit....

I have a simply example utility that when run pops up the file dialog and
lets your "browse" to any of your mdb/mde files, and set/un-set
the shift key setting.

Thus, give it a try, as it means you don't even have to put any code in
*your* application...

....you can find it here:

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