I am able to retrieve old reports using the Parameter Query, but the Date bar shows the current date. Here is the code for the Date bar. I want the date that was input into the Parameter Query.
Code:=[Forms]![main].[ubRptDate]
I am able to retrieve old reports using the Parameter Query, but the Date bar shows the current date. Here is the code for the Date bar. I want the date that was input into the Parameter Query.
Code:=[Forms]![main].[ubRptDate]
If you used brackets for the parameter, you can do this:
=[Exact text of your parameter here]
I read something about Changing my default Printer to Adobe, and printing to PDF Writer. Is that a possibility with Access 2002?Dan Lee;354354]I found out how to go back to previous report dates. I used a Parameter Query in the Total Vote Query, so it found the report for that date in question, instead of the current date. This will help, but I really want a PDF generated for each report. I need to update my copy of Access.
My code might look like this:
Code:Change Printer Adobe DoCmd.Print_Output "rptVoteSummary" acViewNormal Restore default printer
Check out this utility by Allen Browne: http://www.allenbrowne.com/AppPrintMgt.html
It has a combo box for the user to select a printer. You can probably look at the code and figure out how to set it directly with code in the fashion you showed above.