Validation rule question

[Iowa Joe]

I have a form that is used to release specific items from hold. I have a
table for holds and a table for releases. The release form is used to look up
holds and to release them. I have a validation rule in place to make sure
that the release date is after the hold date but also on or before today's
date. This works fine, except that I am using a popup calendar to input the
date into the text box on my form. When I use the calendar function, it does
not validate my date. I am using one I found on the internet written by Allen
Browne (http://www.everythingaccess.com/tutorials.asp?ID=Popup-Calendar). Is
there any code I can add to check the validate the date after using the popup
calendar?

Thank you very much for any help.

 

[Allen Browne]

Set the On Click property of your command button to:
[Event Procedure]

Click the Build button beside the property.
Access opens the code window.

Add code that changes the value back if it doesn't meet your requirements.

Example:

Call CalendarFor(Me.SaleDate, "Select the sale date")
If Me.SaleDate > Date Then
MsgBox "Cannot be sold in the future"
Me.SaleDate = Me.SaleDate.OldValue
End If

 

[Iowa Joe]

Hey, thanks a lot. That works great. One more thing. Is there any way to
check if it is before the initial hold date? This value is stored in a Holds
table and is linked to the release table through the HoldID. I would like the
form to make sure that the user does not enter a release date that was before
the hold date. I will continue to try to solve this, but if you know a quick
fix, that would be great.

Again, thank you so much for the help.

Set the On Click property of your command button to:
[Event Procedure]

Click the Build button beside the property.
Access opens the code window.

Add code that changes the value back if it doesn't meet your requirements.

Example:

Call CalendarFor(Me.SaleDate, "Select the sale date")
If Me.SaleDate > Date Then
MsgBox "Cannot be sold in the future"
Me.SaleDate = Me.SaleDate.OldValue
End If

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I have a form that is used to release specific items from hold. I have a
table for holds and a table for releases. The release form is used to look
up
holds and to release them. I have a validation rule in place to make sure
that the release date is after the hold date but also on or before today's
date. This works fine, except that I am using a popup calendar to input
the
date into the text box on my form. When I use the calendar function, it
does
not validate my date. I am using one I found on the internet written by
Allen
Browne (http://www.everythingaccess.com/tutorials.asp?ID=Popup-Calendar).
Is
there any code I can add to check the validate the date after using the
popup
calendar?

Thank you very much for any help.

 

[Iowa Joe]

Nevermind Allen, I figured it out (mainly due to your help). It brings me
back to some of my old C programming days (laughs). Thanks a lot for the help
and the awesome popup calendar.

Hey, thanks a lot. That works great. One more thing. Is there any way to
check if it is before the initial hold date? This value is stored in a Holds
table and is linked to the release table through the HoldID. I would like the
form to make sure that the user does not enter a release date that was before
the hold date. I will continue to try to solve this, but if you know a quick
fix, that would be great.

Again, thank you so much for the help.

Set the On Click property of your command button to:
[Event Procedure]

Click the Build button beside the property.
Access opens the code window.

Add code that changes the value back if it doesn't meet your requirements.

Example:

Call CalendarFor(Me.SaleDate, "Select the sale date")
If Me.SaleDate > Date Then
MsgBox "Cannot be sold in the future"
Me.SaleDate = Me.SaleDate.OldValue
End If

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I have a form that is used to release specific items from hold. I have a
table for holds and a table for releases. The release form is used to look
up
holds and to release them. I have a validation rule in place to make sure
that the release date is after the hold date but also on or before today's
date. This works fine, except that I am using a popup calendar to input
the
date into the text box on my form. When I use the calendar function, it
does
not validate my date. I am using one I found on the internet written by
Allen
Browne (http://www.everythingaccess.com/tutorials.asp?ID=Popup-Calendar).
Is
there any code I can add to check the validate the date after using the
popup
calendar?

Thank you very much for any help.