ACCESS FEED: Re: [MS_AccessPros] Command button to print multiple reports

Rabu, 03 Desember 2014

Re: [MS_AccessPros] Command button to print multiple reports

Thanks John,

At 3/12/2014 07:19 PM, you wrote:

Are you using VBA or an embedded macro to run the reports? If VBA (recommended), what is your code?

I have only made the button with the wizard. I have very little VBA experience. Pressing Enter would be acceptable for each dialog. I do not have the expertise to produce the VBA.

Robin

If you are using VBA and you are willing to accept the "default" button (what would happen if you just pressed Enter on each dialog) on each of the dialog boxes, a DoCmd.SetWarnings False might work for you. If the overprint dialog doesn't have overwrite as the default, then you can add code to find out if the file exists and delete the file before running the code to avoid the dialog.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

On Dec 3, 2014, at 6:24 AM, Robin Chapple robinski@westnet.com.au [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

I am using Access 2103. The database is a telephone directory. I have
five reports that need to be printed each time the data is changed.

I have made a command button with the wizard for the first report
which asks for confirmation at the 'print' window, confirmation that
the filename is correct and confirmation to overprint the previous version.

My questions are:

i) can I add the 'yes' to each within the command button routine?

ii) can I have all five reports printed from the one button.

Paper is not a concern because the output is to PDF.

Thanks,

Robin Chapple

------------------------------------
Posted by: Robin Chapple <robinski@westnet.com.au>
------------------------------------

------------------------------------

Yahoo Groups Links