Function Key - F1 F2 etc

[Simon Glencross]

Does anyone know if it is possible to use a function key to open a form in
access?

Thanks in advance!

 

[steve]

Sorry, you cannot do this with Microsoft Access 2003. You must upgreade to
micorosoft Acces 2004

Click yere to upgrade:
http://www.ammara.com/access_image_faq/access_loading_image_dialog.html


HTH

Steve

 

[Dirk Goldgar]

Sorry, you cannot do this with Microsoft Access 2003. You must
upgreade to micorosoft Acces 2004

Click yere to upgrade:

http://www.ammara.com/access_image_faq/access_loading_image_dialog.html

Huh?

 

[Simon Glencross]

You have lost me there???

Does anyone else have a suggestion??

 

[Ron Hinds]

Does anyone know if it is possible to use a function key to open a form in
access?

Thanks in advance!

Yes, it is, using a macro. Set the Macro Name to {F2}, or whatever F-key you
want (use the braces). Set the Action to OpenForm. Enter the name of the
form in the Form Name box. Be careful which F-key you use, though. Many have
default actions which you might not want to override (e.g. F1 = Help).

 

[Ron Hinds]

http://www.ammara.com/access_image_faq/access_loading_image_dialog.html

Huh?

Looks like a troll...

 

[Guest]

Ignore Steve. He is our resident idiot and occasionally pops in with
irritating nonsense.

If you go to Access Help and seacrch for "Assign an action or set of actions
to a key", I think this is what you want. Non of the Key events in VBA
recognize the function keys. The one thing to keep in mind is create a
function key macro will disable the normal use of the function key in the
Access application mdb where you have these macros. It will not affect other
mdb files.

 

[Steve Schapel]

Simon,

Just to add to Ron's otherwise excellent advice... The macro object
needs to me named AutoKeys. Where Ron referred to the Macro Name, this
goes in the Macro Name column in the macro design window... if you can't
see a Macro Name column, select it from the View menu.