Date Validation In calendar

[aparnawangu]

Hi Team,


I have a query regarding Date validation in access.
I have a field called Enquiry date and the criteria is that the user should be able to select dates past 15 days only beyond that the system should not allow dates to be selected.
Further the user should not be able to select the date later than current date.
Pls suggest me the solution.


Thanks Aparna

[JoeM]

Create a query that contains criteria that limits your data values, and then use that query as the Source of your Enquiry date selection field.

[Missinglinq]

Using the native DatePicker, that's been available since v2007, is no different than physically entering a date via the keyboard, and so you can do data validation using the Control's BeforeUpdate event.

Replacing DateFieldName with the actual name of your Textbox that holds the date, this will do the job:

Private Sub DateFieldName_BeforeUpdate(Cancel As Integer)
 If Me.DateFieldName > Date Or Me.DateFieldName < DateAdd("d", -15, Date) Then
   MsgBox "Invalid Date! Try Again"
   Cancel = True
 End If
End Sub

Linq ;0)>

[JoeM]

Sorry, I was assuming that they were picking the dates from a bunch of records that they had in a field in a table or query. However, it could be an unbound field.
It isn't entirely clear, so I probably should not have assumed that...

[Missinglinq]

You were probably mislead by the OP's statement "I have a query;" saying "I have a question" would probably have been less confusing!

Linq ;0)>