I have a table in which one of the fields is a short date. I've created a delete query to drop out records before and after a "begin date" and "end date" input by the user in a parameter box.
To keep unnecessary errors to a minimum, I'd like to be able to instruct the user in the Parameter Box as to the correct date format to use: eg, 01/01/2009
I suspect this requires VBA coding. If so, how is such a thing accomplished?
The VBA coding behind the macro button to run my delete query is shown below, as well as a screenshot of what the parameter boxes looks like.
Private Sub Macro___Delete_Qry_for_Period_of_Review_Click()
On Error GoTo Err_Macro___Delete_Qry_for_Period_of_Review_Click
Dim stDocName As String
stDocName = "Delete 4 Period of Review 2-1-09"