 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / June 2007Query/ report- print report each wednesday with the data entered from the previously week
Hello all, My boss asked me to print a report each wednesday, my next print will be the 16 of May with data that I previously entered between 7 to 11 of May. If there a way to create a query and then create a report which I can print each wednesday with the data entered from the previously week? Your help will be much appreciated!! Thanking you all in advance, Fred's >Hello all, > [quoted text clipped - 6 lines] > >Your help will be much appreciated!! Base the Report on a query with a criterion on the date field in your table of BETWEEN DateAdd("d", -7, Date()) AND Date() If you want Access to be automatically opened and print the report, create a Macro to run the report, and use Windows Scheduler to open the database. The command line should contain a parameter to execute the macro, e.g. "C:\Program Files\Microsoft Office\Office12\msaccess.exe" "E:\somepath\yourdatabase.mdb" /x RunReport John W. Vinson [MVP] On May 10, 3:33 pm, John W. Vinson <jvinson@STOP_SPAM.WysardOfInfo.com> wrote: > >Hello all, > [quoted text clipped - 19 lines] > > John W. Vinson [MVP] Hi John, How access can guess which date to which date the report need to be printed? Thanks, Fred's >> If you want Access to be automatically opened and print the report, create a >> Macro to run the report, and use Windows Scheduler to open the database. The [quoted text clipped - 9 lines] >How access can guess which date to which date the report need to be >printed? Windows Scheduler is just that - a schedular. It lets you specify the exact date and time that the command will be launched, and the repeat interval (annually, daily, every ten seconds if you wish). John W. Vinson [MVP] SQL Server and Access Data Projects includes this thing called SQL Agent; this is 100 times more powerful. Do you want to send an email if a procedure fails? it doesn't take any code with Sql Agent! MDB is ridiculolus, move to a database with a future! -aaron >>> If you want Access to be automatically opened and print the report, >>> create a [quoted text clipped - 18 lines] > > John W. Vinson [MVP] Aaron Kem.pf is posting under a new alias. > SQL Server and Access Data Projects includes this thing called SQL Agent; > this is 100 times more powerful. [quoted text clipped - 28 lines] >> >> John W. Vinson [MVP] Warning! John Vinson is a known troll; he does nothing but run around promoting MDB I would reccomend finding a credible SQL Server developer / dba in order to suit your needs. >>> If you want Access to be automatically opened and print the report, >>> create a [quoted text clipped - 18 lines] > > John W. Vinson [MVP] On May 10, 3:33 pm, John W. Vinson <jvinson@STOP_SPAM.WysardOfInfo.com> wrote: > >Hello all, > [quoted text clipped - 19 lines] > > John W. Vinson [MVP] Hi John, How access can guess which date to which date the report need to be printed? Thanks, Fred's On May 10, 3:33 pm, John W. Vinson <jvinson@STOP_SPAM.WysardOfInfo.com> wrote: > >Hello all, > [quoted text clipped - 19 lines] > > John W. Vinson [MVP] Hi John, How access can guess which date to which date the report need to be printed? Thanks, Fred's On May 10, 3:33 pm, John W. Vinson <jvinson@STOP_SPAM.WysardOfInfo.com> wrote: > >Hello all, > [quoted text clipped - 19 lines] > > John W. Vinson [MVP] Hi John, where can I found Windows Scheduler on windows 2000? > On May 10, 3:33 pm, John W. Vinson > [quoted text clipped - 27 lines] > > - Show quoted text - Hi John, How can I create a Macro to run the report? Which macro action do I used? By the way, I 've found the Windows Scheduler Thank you, Fred's >Hi John, How can I create a Macro to run the report? Which macro >action do I used? OpenReport, oddly enough. John W. Vinson [MVP] On Jun 11, 10:42 pm, John W. Vinson <jvinson@STOP_SPAM.WysardOfInfo.com> wrote: > >Hi John, How can I create a Macro to run the report? Which macro > >action do I used? > > OpenReport, oddly enough. > > John W. Vinson [MVP] Hi John, what do you mean by "The command line should contain a parameter to execute the macro ? "C:\Program Files\Microsoft Office\Office12\msaccess.exe" "E:\somepath\yourdatabase.mdb" /x RunReport And where do I put these path? Thank you, Fred's >what do you mean by "The command line should contain a parameter to >execute the macro ? >"C:\Program Files\Microsoft Office\Office12\msaccess.exe" >"E:\somepath\yourdatabase.mdb" /x RunReport > >And where do I put these path? These two lines should be combined into one (messages word wrap so I can't show it as one line), edited to have the actual drive, path name, and database name, and put into the command line window on Windows Scheduler. John W. Vinson [MVP] |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.