Can a macro be used to simplify data entry?

[Michelle W.]

I have a data entry person entering some data into a table using the
datasheet view. Occasionally she will have to enter a standardized title in
some of the columns. However, it is random so it is not something I can run
a query to update the table. Is there a way to create a macro (or keyboard
shortcut of some kind) so she can press that and it will fill in the
standardized title?

 

[Steve Schapel]

Michelle,

Tables in databases should normally be regarded as for the purpose of
data storage, accessible during the development and testing stages of
the application, but not seen for production data entry/editing.

If you were using a form, as recommended, for data entry, then yes,
there are ways to achieve what you are asking.

One way would be to make an AutoKeys macro, defining a keyboard
shortcut, to enter the standardised title. I think the Help topic on
AutoKeys is quite good.

Another possible approach would be to use a SetValue action in a macro,
with the macro assigned for example on the Dbl Click event of the
applicable textbox on the form.