form

  • Thread starter Thread starter pat
  • Start date Start date
P

pat

I have done this once before successfully, but cant
remember how.

I need to record in a table a record of every key stroke
made by a user when entering or modifying data.

it is the on key press event function, but not sure how
to then get that information into a table.

can someone remind me please'

pat
..
 
Try using the KeyUp event to add a record to a table, and set the Key
Preview property to Yes.

Write the code to for each control that you want to record, and send the
control,name and the control,value to a table (aircode):

"Insert into Mytable ControlName, ControlValue Values ('" &
Me.MyControl.Name & "', '" & Me.MyControl.Value & "')"
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top