Hi, im using access 2007 to write surveys up. When ive finished i then individually PDF the reports up, numbered from 1-9. Is there a way of PDF-ing all 9 reports in one go?
The next survey i write up will be on a new access document. Im also fairly new to access.
Thank you.
Yes with a Macro
OPENREPORT
Open: (report name)
Filtername: blank
where condition: blank
window mode: hidden
Create more Open Reports for all the different reports you want to print, then
PRINTOUT
printrange: all
print Quality: high (or what ever you want
copies: # Howmany you need
Then
CLOSEWINDOW
Hi,thank you for your reply, this has been extremely helpful and can pottentially save loads of time.
Im new to MACRO but i managed to follow your instructions. I did a OPEN REPORT for each of my reports.
I dont have a 'PRINTOUT' option, i have nothing begining with P. I have 'OUTPUT TO', which i chose instead.
I chose OBJECT TYPE as report
i chose OBJECT NAME as the 1st report name, it wouldnt let me leave it blank when runnung macro.
I left OUTPUT FILE blank as the next time i do this it will be using different reports with a different file name. And because it was blank i left AUTO START on NO.
I then had to create a OUTPUT TO for each of the reports.
When i run the macro, it asks me to save each file individually, the first time it asks for the location, which i choose the location of the access file, then i click save for every report after.
Is it possible to save all reports in one go instead of individually?
thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks