HOTKEY NEEDED TO OPEN FORMS

[fsweb2002]

Hi there

I have 5 different forms that I jump from one to another all the time.

I would like to add Hotkeys (alt+number) so the form required opens with the same hotkey regardless in which form you are at the time.

Any ideas ?

 

[Gazer44]

look up 'access keys' in help menu, this may help. If not you could put 4 buttons at top of each form so when clicked they each open 1 of the other forms!

 

[suntsu]

Have you tried changing the captions of each command button to include the ampersand?

e.g. "&1. Form1name"
"&2. Form2name"

This would allow you to use the alt+number keys to run the code for that button.

 

[fsweb2002]

thanks to all for your reply

I am looking for an easier answer...
A global hotkey that will work whetever it you are at the time.

I know I can put the buttons of all the forms on EACH form, however I am trying to avoid doing that (if there is another way!)

thanks anyway

 

[GHolden]

If you have the following public sub in a module, obviously you can add whatever key combos you want.

Public Sub mOpenForm(ByRef vintKey As Integer, ByVal vintShift As Integer)
If vintKey = vbKeyF3 And (vintShift And acAltMask) > 0 Then
'open form on alt - F3
End If

If vintKey = Asc("A&quot And (vintShift And acAltMask) > 0 Then
'open form on alt - A
End If

If vintKey = Asc("1&quot And (vintShift And acAltMask) > 0 Then
'open form on alt - 1
End If
End Sub


on each form set the key preview to true.

and in the Form_KeyDown for each form put the following

mOpenForm KeyCode, Shift

Hope this is a help

 

[chriswatson]

You could try using the AUTOKEYS macro (see HELP Autokeys)
This allows you to set up hot keys.
The AUTOKEYS macro runs automatically when the database is opened.

 

[fsweb2002]

GHolden

That´s exactly what I was looking for !!!

You are a legend "!!!!!

Thanks everyone else for helping too