Convert Word Macros to Access macro for form entry

[cindy smith]

How do I convert a macro i've created in word to automate
form entry in access? I am completing redundant
transcription notes and many of the normal findings are
the same text input. The transcriptionists now use word
perfect to complete their notes. They've created macros
in wordperfect to "shortcut" the redundant keying. Can
this be done in access too? Please advise, thanks for
your help, cindy

 

[Steve Schapel]

Cindy,

The concept of macros in Word is quite different from the concept of
macros in Access. Sorry, you can't convert one to the other.

To use a macro in Access to do the kind of thing you are asking,
create a macro which will be called AutoKeys. In the macro design
window, if there is not a column 'Macro Name' you can enable this by
selecting Macro Names from the View menu. In the Macro Name column,
type a description of the keystroke you wan to use to insert your
text. For example ^3 will mean Ctrl+3 key combination. In the Action
column, put SetValue and then set the arguments in the bottom panel
like this...
Item: [Screen].[ActiveControl]
Expression: "Whatever your text is..."

You can enter a separate SetValue line for each text you want to use,
each with its own key combination. Allowable key combinations are
explained in Access Help.

Then, when you are working on your form, press the designated keys and
the text will be entered in the textbox where the cursor is located.

Another 'tip' which might be applicable if you are entering multiple
records, is that in Access, Ctrl+' (ctrl and apostrophe) will
automatically enter the same as the entry in the same field in the
previously entered record.

- Steve Schapel, Microsoft Access MVP