Report to PDF

[HubbardUK]

I am using lebans method for producing a pdf from an Access Report.
It works really well in most circumstances but for one report it has a
strange issue.

The report is a repeating row directory type format.
When printing to a pdf using lebans code, the first record on each page
(except page one) does not display the contents of most of the fields. Only
about two fields display information (the same ones each time) but the rest
are blank. For the rest of the page it is fine.

It displays no problem as a normal access report.
I can print to a pdf using primopdf
but when using lebans code it always has this problem.

Any suggestions please?

Richard

 

[Stephen Lebans]

Forget about my code for a moment. Manually Export the problem report to
Snapshot format. Is the problem you described evident in the Snapshot file?

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Keith G Hicks]

Stephen,

Before you had any PDF code available I set up a client app to do this using
Ghostscript. It's been running fine for a long time but it's kind of a pain
to set up on each workstation. Ghostscript has to be installed and then you
have to create a PS printer. Is your solution easier to implement? Are the
results as dependable?

Thanks,

Keith

 

[Albert D. Kallal]

Stephen,

Before you had any PDF code available I set up a client app to do this
using
Ghostscript. It's been running fine for a long time but it's kind of a
pain
to set up on each workstation. Ghostscript has to be installed and then
you
have to create a PS printer. Is your solution easier to implement? Are the
results as dependable?

Thanks,

Keith

Stephens solution is much easier to implement.

The first thing you realize is that you don't have to install a printer
driver. In fact in a sense you really don't even install any PDF software at
all. Further when you have to convert a report to a PDF file, you don't have
to write a bunch of code to switch the current active printer to some pdf
printer (you don't use a pdf pritner here). The fact that you don't have to
switch printers also saves a bunch of code here and again makes the
installation more simple.

To say that it's simpler to use, easier to install, and is more reliable is
in my humble opinion an understatement. It's nothing short of brilliant, and
it's very reliable.

The only additional software you need is the placement of two DLL files in
the same directory, and that's it.

If you need pdf ability for your access reports, I highly recommend
Stehpans solution.

 

[Keith G Hicks]

Thanks Albert. I'll definitely try this out.

Keith

 

[HubbardUK]

Thank you for your swift reply.
I opened the report as preview, and exported to a snp file.

It formatted with all the information correctly.

Trusting I am not rushing ahead, I ran your code again, but stepping through
it so I could stop when it created to snp file in the temp directory.

Checking the snp file, it was fine, so it is something when the snp file is
converted to a pdf.

This issue is not just on my computer. It happens other computers using the
MS Access file and your code (which is brilliant by the way - thanks for
making it available)

Am very grateful for any further help.

Richard


Richard

 

[Stephen Lebans]

It looks like it could be a printer driver issue then. Can you EMail me the
Snapshot file?
(e-mail address removed)


--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.