Sending report to Adobe PDf

[Ed Picillo]

I am sending a report that contains sub reports to a default Adobe PDF
printer. I have a macro that runs with the ON PRINT function of the main
report.

The Macro always runs fine if I print preview or actually print the report
to a printer and not to the Adobe driver. The Macro will not run if I send
the report to the Adobe PDF default printer.

Is the macro not running because Access does not think it is Printing? And
if so is there a way around this?

 

[Alan Z. Scharf]

Ed,

1. Which section of the report' has the OnPrint event are you working with?

2. Have you tried the OnFormat event?

3. You should give more info on what your macro is doing.

Alan

 

[Ed Picillo]

Alan,

Thanks for responding. First I appolagize, The macro is running in the
report section in the ON Open event. I don't know why I typed this as On
Print. Sorry about that.

So to answer your questions.

1. The macro is running in the Report section of the Main Report in the On
Open event.

2. I have not tried to run the macro in the On Format Event. I could try
to run the macro in the On Format Event for the report group that the
subreport is in.

3. The macro is setting the value of the source object in a subreport that
is in a group on the main report.

 

[Ed Picillo]

Alan,

I tried to run the macro in the On Format event of the Group Header that the
subreport is in and I get an error that says that you cannot set a source
object because the report has already started to print. The message states
to set the Source Object in the On Open Event. That seems to make sense.
However setting the source object using the On Open Event does not seem to
execute when sending the report directly to the Adobe PDF printer.

 

[Alan Z. Scharf]

Ed,

I don't know the anser to that one.

I posted a question a few minutes before you about saving printer settings
in a report for Adobe.

If I can get that to work, maybe the answer is having the printer set to
Adobe programmatically in your report based on a condition.

Alan

 

[Alan Z. Scharf]

Ed,

I don't know the anser to that one.

I posted a question a few minutes before you about saving printer settings
in a report for Adobe.

If I can get that to work, maybe the answer is having the printer set to
Adobe programmatically in your report based on a condition.

Alan

 

[Alan Z. Scharf]

Ed,

Two other things:

1. You may want to try another PDF driver. There probably are at least 30
on the market in the $50 - 100 range.

I have used Win2PDFPro in another project trouble-free for a year now. They
have a 30 day trial.

It also prints PDF's at least twice as fast as Adobe. That's why I
sweitched to it, because my project required batch printing of a couple
hundred PDF's at once.

http://www.daneprairie.com/



2. If you are dong any considerable amount of PDF printing, then I recommend
looking at the ACG's PDFProPlus Accesss Library for $99.00

I have been using that in projects since 1998. I'm not sure what I would
have done without it for my Access report batch printing requirements.

The ACG site also has many valuable tips on printing Access reports and
using MS Graph with them.

http://ourworld.compuserve.com/homepages/attac-cg/


Regards,

Alan

 

[Ed Picillo]

Alan,

Thanks for your help. I am just curious. Why would the On Open event work
if you send a report directly to Snapshot, not ever opening the report, and
not work when you send it to the Adobe PDF driver? And why might it work
with a different driver?

Any Ideas?

 

[Alan Z. Scharf]

ED,

The Win2PDF driver bypasses the Adobe Distiller.

If the setup you have is sending to distiller and then PDF Writer, then that
is the difference.

It doesn't cost anything to try another driver.

Alan