How do I input common data in ACCESS with one keystroke?

[Guest]

How can I create a keystroke to put the same piece of information in
different records without having to type it out. For example: Ctrl Q =
Insurance Policies

 

[Steve Schapel]

Future,

It may help you to know that Access has a built-in keyboard shortcut
being Ctrl+' which will enter the same value in a field as the entry in
the previous record.

The kind of functionality you are requesting is also commonly handled by
way of a combobox for data entry in fields where there is more or less a
fixed finite number of data options. In that case, the keyboard
shortcut for Insurance Policies is likely to be in-Enter.

Apart form that, you can make a macro which is named AutoKeys, and
specify actions for your own custom shortcut keystrokes. In the example
you mentioned, you would put like this in the macro...
Macro Name: ^q
Action: SetValue
Item: [Screen].[ActiveControl]
Expression: "Insurance Policies"

 

[Joseph Meehan]

How can I create a keystroke to put the same piece of information in
different records without having to type it out. For example: Ctrl Q
= Insurance Policies

You might take a look at the program "Perfect Keyboard" You can have it
pass keystrokes to Access. Just Google Perfect Keyboard.