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 .
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set date to Date and time picker 1
ActiveX control - Date/Time picker 2
Date Picker Default? 1
Textbox Code for Date Format 1
Date Time Picker 4
There is no object in this control 2
Date/Time Picker in Form 1
Date and Time Picker 2

Back
Top