Access 2003 - Date Picker Function

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!
 
D

Daniel Pineault

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

Date Picker won't appear 0
Textbox Code for Date Format 1
Set date time picker to null (blank) 5
Show prior week in the Date Picker 2
Enter date in one cell, and the week ending date [Sunday] appears inthe "W/E" cell 4
Allen Browne's Date Picker 8
Set time interval on date/time picker when creating appointment. 1
Where do I find date-picker (to select date via calender) add-on? 0

Top