Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Unhide a hidden field at the months end
- Thread starter moles
- Start date
Hi!
Assuming you have a form that opens whenever the Db is opened you can use the following:
If Date() = DateSerial(Year(Date()), Month(Date()) + 1, 0) Then
Here you can call a form to change the password or pop up a message box as a reminder, make the control visible etc. You can also put in the condition that this stuff only happens if you are the user.
hth
Jeff Bridgham
bridgham@purdue.edu
Assuming you have a form that opens whenever the Db is opened you can use the following:
If Date() = DateSerial(Year(Date()), Month(Date()) + 1, 0) Then
Here you can call a form to change the password or pop up a message box as a reminder, make the control visible etc. You can also put in the condition that this stuff only happens if you are the user.
hth
Jeff Bridgham
bridgham@purdue.edu
- Status
Similar threads
