expiring dates

K

kawaii1

I want to make a automatic alert that will pop up when my date on a form gets
old. I am an access novice. I don't know how to string code or anything like
that. I just need to have something that will ensure that updates are made in
a timely fashion on my form, thanks.
 
A

Al Campagna

Kawaii,
The term "gets old" is not a logical statement. What constitutes an "old" date?
And, I'm assuming from your post, that when you come to a record on your form, you
would like to be alerted to some Date "problem".
Use the OnCurrent event of the form itself. This code would fire every time you visit
a record.
Here's an very simple example of alerting the user that your form's date field value is
older than the today's date.
Private Sub YourFormName_Current()
If YourDateField < Date() Then
Beep
MsgBox "Date less than Today"
End if
End Sub
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 
Top