How can I schedule microsoft access reports

[johnson34]

I would appreciate if somebody can help me of how to schedule microsoft access report. I don't want to use MARS to do it. I would appreciate if somebody can help me may be use macros and then use windows scheduler to run it.

 

[Zigzag]

If you create a new FE that is designed purely for running the report.
Set a start form and on that form set "On Open" Event (VBA) to run the report you want.
After the reports are run shut down the FE.
This way your application does not have to be running all the time.

Use Windows scheduler to open this new Front End.

Garry

 

[johnson34]

How will you refer a microsoft access report from VB form.

I know you said that set a start form and on that form set "On Open" Event (VBA) to run the report you want? First of all How will you refer a microsoft access report from VB form.

 

[Zigzag]

Hi johnson34,

In the "On Open" event property of the first form that opens when the Front End is opened, add code similar to this.

DoCmd.OpenReport "Report Name", acViewNormal, "", "", acNormal

The above code should print your report out.
After that the Front end can be closed using.

DoCmd.RunCommand acCmdExit

Garry

 

[johnson34]

When I open microsoft access database, I can access microsoft access report that I created inside the database. But physically I cannot find out where the microsoft access report is stored in my P.C. Thats where I am struck too. I would appreciate if you can help me of how to find out the physical location of the report. I did a search by the report name still cannot able to find out. Without knowing the location of report in my P.C how would I access the microsoft access report using visual basic code is my big doubt. Appreciate your help.

 

[Zigzag]

Ok,

I think you missunderstood my reply to your post.

Your report does not exist anywhere else other that inside your MS Access Application, unless you have saved it as a RTF file or something similar, but this would be a static report and would not show the latest info if any had changed.

What I would do (and have done and still do) is copy my reports from your current application into a new DB. Create new Table links (Ones needed to feed the reports) to your original DB tables.
Create a new form that when opens, automaticly opens your reports that you coppied from your original DB.

I hope I have put this in a way that can be understood, if it is still unclear then zip up your application post it to me telling me which reports you want to run and i will post back the solution.

Garry

 

[Villarreal68]

Hello Zigzag,

I think you are a very generous person, nothing wrong with that!, but I think doing it for him will not teach johnson34 how to do things within Access. I think that assisting him with the issues as HE creates the solution would prove to be a better option in the long run. what do you say? Just my thoughts.

Thanks for all your help as issues are brought to the forum. I'm sure some day (soon probably) I will need your assistance!

René

 

[Zigzag]

Hi Rene,

I do believe that more can be learnt by battling your way through problems, learning by mistakes, trial and error etc etc

However sometime it just needs a little example to view before the penny drops.

I agree with you that if someone does the work for you then nothing is learnt.

My intention was never going to be to do the complete job for him just start him off on the right track.

Thanx for you post, maybe this should be the start of a new post at the water cooler.
"Best learning practices"

Garry