Automatically check query and send a report

ebiscaro

Registered User.
Local time
Today, 18:03
Joined
Apr 5, 2003
Messages
37
Good Day!

I have a simple table where the user enter expiry date for visa. User also enter return date of visa holder.

I am looking for a way whereby, every time I start my database a report is automatically sent if Visa Expiry daye is close to departure date.


I already have the query and the report based on it, but how to have this checked and sent?
This is in my query

VISA_CHECK: IIf([Visa_LOI_end_date]-[Return Date]<7,'Fail','Pass')

If it fails this should trigger the report being sent.

I hope I have been clear and that someone can help.

Thank you in Advance

Enrico
 
Do you have a switchboard or StartUp form? If so you can use the On open event to check werher any records fail and if so send the report.
 
Switchboard yes

Thank for your reply,

Yes, I do have a switchboard, as a matter of fact I was able to achieve what I wanted using a macro but it seems pretty convoluted and I need also to open a form for the check to be performed. Is there a code I could use to check the data?

Regards
 

Users who are viewing this thread

Back
Top Bottom