I am looking for some guidance before I build some automated reports. I already know how I will output/distribute the reports(s), but I am trying to understand the best way to trigger the reports. Basically I want to trigger a couple of reports to be sent out say at 6 pm every weekday night.
My db has a BE and multiple FE's distributed out. I first thought i could have a code to execute on the Current Event for the Main Form of the db to say such in the below example, but I thought of two scenarios that might not work with this idea. 1) Anyone who had the db Open when then execute possible multiple e-mails that are sent out and also I would have to ensure to keep a db Open to at least execute the code at the set time.
My idea is to create a separate FE basically to run the automated reports and keep it open at all times.
Any suggestions or different approaches to this scenario... so basically I just need a way to execute a timed event every weekday.
If Time = 6:00 pm Then
DoCmd.Output..... <- Output Reports
SendEmail <--- A Sub to distribute attached Reports to users.