Print each page of report to individual PDF or MDI files

[dmuroff]

Hi,

I have a report 30 page report within Access. I would like to be able to automatically save each page to an individual PDF, MDI or any other commonly known viewer not having to do each one separately.

Any help would be greatly appreciated.

Dan

 

[genomon]

If you are using Access 2002 or better, the new printer object model has exactly what you need. Here is some stuff to get you going:

http://msdn2.microsoft.com/en-us/library/Aa139946(office.10).aspx

All I ask is a chance to prove that money can't make me happy.

 

[jbuzz7373]

Take a look at this thread.

http://tek-tips.com/viewthread.cfm?qid=1131288

I think it covers what you are wanting to do.

 

[genomon]

Seems a bit complicated for what 4 lines of code can accomplish...

"Before you criticize someone, you should walk a mile in their shoes.
That way, when you criticize them, you're a mile away and you have their shoes."