POP OUT ALERT: OUT OF DATE

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

I am trying to run a simple database with 4 columns:
1. Product;
2. Date (purchase date),
3. Frequency (from date of purchase f.e. 6months),
4. Expire date
What is my database going to do is generate pop out alert when I open a
database informing about a product which f.e gone off.
Please bear on mind I am just a begginer ! I haven't use a MA for a long,
long time. Please, can anybody help me?
 
Create a macro named Autoexec with OpenQuery action. The query will run upon
opening Access.
Set criteria for Expire date to <=Date()+7 to see
those that will expire within one week or already have.
 
Karl you are a STAR!!
Thank you so much for resolving my problem which was a pain in my arse!!
CHEERS!!
 
Back
Top