Automatically check query and send a report

[ebiscaro]

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

 

[KeithG]

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.

 

[ebiscaro]

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