Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Print to PDF from Access, Data Disappears

Status
Not open for further replies.

originalxavier

Programmer
Mar 5, 2003
69
US
Here we go... I have a report that is generated in Access 2000 from data collected in an Access form. As everyone knows, when you export to a Word file, you lose all of the formatting and things that make the report itself come together. So the alternative to this is to print to PDF and retain all of the formatting.

Here is where it gets tricky. Embedded into the report is an ActiveX Control called SigPlus which displays a signature that is captured from a USB device. It displays on the screen fine in Form View, Report view and when you print to PDF on one of the laptops. Everything from the DB to the specific report as well as the coding for the signature device were all written on the laptop that functions. Of course, when I copied the DB as well as installed the drivers for the Signature device on any other laptop, for some reason, it will not show the signature when you print to PDF.

I am at a loss. Everything is the same. All the references, the code, the installation, the hardware, software... you name it, it is IDENTICAL. Even Adobe Writer is installed from the same CD with all of the same options. I have tried researching this on the Net hoping to find some kind of help but to no avail. My assumption is that this is an Access issue since it comes bundled with so many problems or "Undocumented Features" but I am not sure.

Any help, tips, suggestions, guidance, references would be greatly appreciated.

Thanks in advance,

Xavier

----------------------------------------
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far the Universe is winning."
Rick Cook
----------------------------------------
 
I am assuming the lack of responses means no one has any kind of suggestions for me...

[sad]

Xavier

----------------------------------------
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far the Universe is winning."
Rick Cook
----------------------------------------
 
I've never had a problem pulling records from a db and using asp or php to input the values into a PDF form for printing. You need to send the values to the PDF via URL encoded string and then have a JS script to interpret those values.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top