Hot Key / Autokeys

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi trying to create a hotkey in Access 2003 to enter yesterday's date in a
form similiar to ctrl+; (semicolon) which enters today's date
any idea's I have tried creating a autokey but don't seem to populate the
form
 
you can use the following function, as

Public Function isYesterday()

On Error Resume Next

Screen.ActiveForm.ActiveControl = Date - 1

End Function

make sure you save it in a standard module (not a form module), and call it
from the Autokeys macro using the RunCode action.

hth
 
Thanks " tina" problem solved
--
Regards
David


tina said:
you can use the following function, as

Public Function isYesterday()

On Error Resume Next

Screen.ActiveForm.ActiveControl = Date - 1

End Function

make sure you save it in a standard module (not a form module), and call it
from the Autokeys macro using the RunCode action.

hth
Click to expand...
 
Back
Top