capture keypress on database open

Is there a way to capture a keypress as a database is open. i.e. Access
knows when the shift key is help on open is bypasses the startup options. Is
there a way to do something similar? Like holding down the ctrl key when the
database opens? Basically I have a module that runs on start up and I
occasionally want to bypass this code when I open the database.

TIA.

--
James B Gaylord
For the Wolf comes the strength of the Pack,
For the Pack comes the strength of the Wolf,
-R. Kipling
Office 2003 on Win XP SP2

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200907/1

Meant to put this in the VBA forums, sorry

Cyberwolf0000 wrote:
Is there a way to capture a keypress as a database is open. i.e. Access
knows when the shift key is help on open is bypasses the startup options. Is
there a way to do something similar? Like holding down the ctrl key when the
database opens? Basically I have a module that runs on start up and I
occasionally want to bypass this code when I open the database.

TIA.


--
James B Gaylord
For the Wolf comes the strength of the Pack,
For the Pack comes the strength of the Wolf,
-R. Kipling
Office 2003 on Win XP SP2

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200907/1

You don't have a module that runs. It is either a Sub or a Function.
Modules are only containers for Subs and Functions.

You can actually use the Shift key to do it. Instead of using the start
form option to start the code, use a macro named AutoExec and call your
Function using the RunCode Action. Note that the RunCode Action requires a
Function. It will not work with a Sub.
--
Dave Hargis, Microsoft Access MVP


"Cyberwolf0000 via AccessMonster.com" wrote:

Is there a way to capture a keypress as a database is open. i.e. Access
knows when the shift key is help on open is bypasses the startup options. Is
there a way to do something similar? Like holding down the ctrl key when the
database opens? Basically I have a module that runs on start up and I
occasionally want to bypass this code when I open the database.

TIA.

--
James B Gaylord
For the Wolf comes the strength of the Pack,
For the Pack comes the strength of the Wolf,
-R. Kipling
Office 2003 on Win XP SP2

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200907/1

On Wed, 08 Jul 2009 12:49:11 GMT, "Cyberwolf0000 via
AccessMonster.com" u42640@uwe wrote:

Not unless you go to extremes.

A much simpler solution would be to run an AutoExec macro, which opens
a form, which ticks a timer for 10 seconds, giving the user plenty of
time to click a Cancel button. If not clicked, the startup code fires.

-Tom.
Microsoft Access MVP



Is there a way to capture a keypress as a database is open. i.e. Access
knows when the shift key is help on open is bypasses the startup options. Is
there a way to do something similar? Like holding down the ctrl key when the
database opens? Basically I have a module that runs on start up and I
occasionally want to bypass this code when I open the database.

TIA.

thanks Tom,

Sounds like a much better way to go.

Tom van Stiphout wrote:
Not unless you go to extremes.

A much simpler solution would be to run an AutoExec macro, which opens
a form, which ticks a timer for 10 seconds, giving the user plenty of
time to click a Cancel button. If not clicked, the startup code fires.

-Tom.
Microsoft Access MVP

Is there a way to capture a keypress as a database is open. i.e. Access
knows when the shift key is help on open is bypasses the startup options. Is
[quoted text clipped - 3 lines]

TIA.

--
James B Gaylord
For the Wolf comes the strength of the Pack,
For the Pack comes the strength of the Wolf,
-R. Kipling
Office 2003 on Win XP SP2

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200907/1