How do i set up a popup message at the opening of the database

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

Guest

i need to design a pop up message which will be displayed at the loading of
the database main menu form prompting expiration of an employee contract 35
days before expiration.
 
is the employee the current user of the system or is the employee one of the
records that you navigate to while using the program?

if the form is based on the employee table, just do a calculation in the
oncurrent event of the form based on ExpirationDate - now() <= 35 then give
a msgbox("Contract Expires in " & ExpirationDate - now() <= 35 & " Days" or
something like that.

if the contract is for the employee that is the user of the database then
you can do the above in the onload event using but you will have to locate
the currentuser() 's record to find the expiration date of the contract.

if I have misunderstood what you are asking, post back with clarification.
 
Back
Top