Weekly monitor based on query result

[Jonny]

I wish to get notified every Sunday in 9AM o'clock with the results from the
MS Access query.
What's the best way to do that?

Thank you

 

[theDBguy]

Task Scheduler?

 

[Jonny]

It opens Access but not sending queries..

 

[mike60smart]

Hi

Are the notifications reminders of some sort?

 

[theDBguy]

It opens Access but not sending queries..

You don’t open Access directly. Instead, you create a script to open Access. You should create a macro to email the query and pass the name of the macro in your script.

 

[Jonny]

I wish to get every Sunday a list of employees with the upcoming birthday.

 

[Jonny]

You don’t open Access directly. Instead, you create a script to open Access. You should create a macro to email the query and pass the name of the macro in your script.

Sorry , but how I do that? Could you please clarify step by step.

 

[plog]

You can open Access directly in task scheduler and have this work. You just need to pass the Macro as a parameter. Here's how we did it:

1. Build VBA function to export queries to file, compose email, attache files and send.

2. Build Macro to run VBA function and then close Access. Task scheduler can run macros, but not code directly in a module, thus the need for this step.

3. Set up task scheduler to open access with that macro. Set up task scheduler like you want and then in the actual task you point it to Access and use a switch to tel it what Macro to run.

https://social.msdn.microsoft.com/F...run-a-macro-in-task-scheduler?forum=accessdev

 

[plog]

That link doesn't show how to use the macro, this one is better:

https://answers.microsoft.com/en-us...s-access/474aaa3c-50a7-40d9-9a43-a367933e7a8d

 

[Jonny]

Solved , thanks everyone!