Access 2003 - Date Picker Function

  • Thread starter Thread starter Vick
  • Start date Start date
V

Vick

We have a timekeeping database that uses the Date Picker function to choose
the week ending date when our employees enter their time. Our payroll week
ends on a Sunday. Is it possible to make the date picker allow only Sunday
dates as their choice? If so, how do I set this up?

Thanks for your help!
 
Without the Date Picker function to review it is impossible for anyone to
tell. Which date picker are you using?

What you can do howeverm is use a control event to validate the value
entered by the user using the afterupdate event and code like

If WeekdayName(DatePart("w",[txtMydate])) <> "Sunday" Then
Msgbox "The date entered is not a 'Sunday'. Please select another date
value"
Me.txtMydate = ""
End If

Where txtMydate is the name of the date control .
 
Back
Top