having an access report generated by a user once a week?

[016]

It is urgent.<br>How can I have a user generating&nbsp;&nbsp;independently a report once a week. Thank you

 

[DougP]

It can be as automated as your ablity to make it so.<br>I created one but it got very involved.<br>I suppose you have your report done already.<br>It would be easier if your report was connected to a query.<br>The query would first of all prompt for the Dates <br>using a Between Like so: (Then later you would make a Function that would pass the dates to the same query)<br>I had 2 functions one called LastFriday and the other called LastMonday<br>Between LastFriday() And LastMonday()<br><br>This goes in the Criteria of the Date field in your query.<br>This will give you a range.<br>I suppose that you want a range to be printed say every Monday.<br>Create a Macro that opens the report.<br>The macro could be assigned to a Button So the user simply clicked on the button and the report showed up in the printer.<br>The report was set to &quot;Sepcifc printer&quot; so it did not go to the wrong printer is the user changed their default.<br><br>Anyway that's a start.<br><br><br><br><br><br><br><br><br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[elizabeth]

There is a Scheduler add-on called Access Agent you might want to look at.&nbsp;&nbsp;<A HREF="

http://www.fmsinc.com"

TARGET="_new">

http://www.fmsinc.com</A>