HOW TO SET A DATE FIELD WITH CURRENT DATE TO SHOW A WARNING MESSA.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

sir,

I would like to know, how to set a warning message with a current date.

For eg: if my ID Card is expiring today I need to see a message box with a
warning message that "Your ID Card expires today.

Kindly help me.
 
Deepu,

You would need to identify a suitable event to use for checking the
data. For example, you could use the Open event of a form which is
always open when the application is open, so this might be good if the
application is opened every day. Anyway, then you could use code
something like this...
If DCount("*","YourTable","[YourDateField]=" & Date)>0 Then
MsgBox "Your ID Card expires today."
End If
 
You must log in or register to reply here.

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

Excel Formula - Count Dates from another Sheet 8
Date search query 0
If/Then Formula Using Dates 1
Simple dues expiration date flagger 2
Pop up message to warn of date expiring? 7
Text type date change to date type date 2
Annotating and expired date 3
Access MS Access 2010 IIF statement to check if one date is in or out of range of two other dates (fields) 0

Back
Top