Date validation

[Learning123]

Hi,

I am creating a bookings database. I need to stop people from making a booking on Mondays.

Does anyone know how to make a validation rule stopping people from booking on Mondays in the Date field?

I am thinking that I need to have a Day field, where the Weekday number (1,2,3, etc) is updated according to the date entered in the Date field (and then validation on that field can be entered to stop the number "2" being entered) - but I have no idea how to do this.

Would be grateful for any help as time is running fast! Thanks

 

[boblarson]

In the control's Before Update event you can put

If Format(Me.YourControlNameHere.Text,"dddd") = "Monday" Then
    MsgBox "You cannot select a Monday", vbInformation, "Validation Error"
    Cancel = True
End If

 

[Learning123]

Thanks - but I can't seem to get that to work - do I use this in the Date field, where the format is general (dd/mm/yyyy), or do I need to change something to make this work?

 

[boblarson]

No, you don't use it IN the date field, you use it in the date field's BEFORE UPDATE event (and if you're not sure where to put code for events you would do something like this - only with the Before Update event and not the one shown):
http://www.btabdevelopment.com/main/QuickTutorials/Wheretoputcodeforevents/tabid/56/Default.aspx

 

[Learning123]

Thanks - sorry I wasn't being clear enough, I did understand that - but it's working now anyway...I made a mistake in the expression before.

Thanks again!