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

Rabu, 03 Desember 2014

Re: [MS_AccessPros] Command button to print multiple reports

Robin-

Following that link got me:

HTTP Error 404.0 - Not Found

The resource you are looking for has been removed, had its name changed, or is temporarily unavailable.

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 10:39 PM, Robin Chapple robinski@westnet.com.au [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Thanks John,

It was an embedded macro. Illustrated in that link,

Cheers,

Robin

At 4/12/2014 07:59 AM, you wrote:

Robin-

What did the Wizard create? Open your form in Design View, select the command button, then look at the Properties window to see what's in the On Click property. If it's [Event Procedure], select the property and then click the Build button (…) to see the code and then copy and paste the code back in a reply. If it says [Embedded Macro], then select the property, click the Build button, and tell us what it says in the Macro Builder.

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 9:47 PM, Robin Chapple robinski@westnet.com.au [MS_Access_Professionals] < MS_Access_Professionals@yahoogroups.com> wrote:

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