473,320 Members | 1,865 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

MS Access Report to PDF

Hello All,

I have been doing quite a bit of research in this group and have not
been able to find the answer that I am looking for.

Here is my issue. We currently have Adobe Acrobat v5 installed on our
system (under Windows 2000 Professional). Currently, we are using MS
Access 2000. Early next year we will be moving to Windows XP (probably
converting to MS Access XP as well) and have been told that Adobe
Acrobat v6 is to be installed as the new standard. Oh yeah - they have
also told us NO to having Acrobat v5 installed. This means that we will
no longer have access to PDF Writer, which we currently utilise to
generate PDF documents from reports. PDF Distiller apparently is
replaced with PDF Print (if memory serves me well). I have tried
working with PDF Distiller and have not had any success, very messy,
unlike PDF Writer.

My question for the group is; does any know how I am will be able to
generate PDF documents from MS Access 2000/XP without PDF writer using
Adobe Acrobat v6 PDF print? Oh yeah - third party tools (other then MS
Office and Adobe Acrobat v6 standards) are a NO NO, for example Win2PDF
etc.

Does anyone have any suggestions? Has anyone been able to PDF Print to
work from VBA?

Please note: I'd rather not get into creating SNP (snapshot views)
since we send our documents externally at times).

Thank-you all, in advance, for your time and attention to this
matter...

Regards,
Dave

Nov 13 '05 #1
12 5551
We have a full version of Acrobat. I used something else simpler than
Acrobat to program. It is pdf995. On their site, there are examples for
developers in VBA.

http://www.freeware995.com/misc/vbacode.txt

"DGB @ Sun" <Da***************@SunLife.com> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...
Hello All,

I have been doing quite a bit of research in this group and have not
been able to find the answer that I am looking for.

Here is my issue. We currently have Adobe Acrobat v5 installed on our
system (under Windows 2000 Professional). Currently, we are using MS
Access 2000. Early next year we will be moving to Windows XP (probably
converting to MS Access XP as well) and have been told that Adobe
Acrobat v6 is to be installed as the new standard. Oh yeah - they have
also told us NO to having Acrobat v5 installed. This means that we will
no longer have access to PDF Writer, which we currently utilise to
generate PDF documents from reports. PDF Distiller apparently is
replaced with PDF Print (if memory serves me well). I have tried
working with PDF Distiller and have not had any success, very messy,
unlike PDF Writer.

My question for the group is; does any know how I am will be able to
generate PDF documents from MS Access 2000/XP without PDF writer using
Adobe Acrobat v6 PDF print? Oh yeah - third party tools (other then MS
Office and Adobe Acrobat v6 standards) are a NO NO, for example Win2PDF
etc.

Does anyone have any suggestions? Has anyone been able to PDF Print to
work from VBA?

Please note: I'd rather not get into creating SNP (snapshot views)
since we send our documents externally at times).

Thank-you all, in advance, for your time and attention to this
matter...

Regards,
Dave

Nov 13 '05 #2
"Saintor" <sa******@REMOVETHIShotmail.com> wrote in
news:hC********************@weber.videotron.net:
We have a full version of Acrobat. I used something else simpler
than Acrobat to program. It is pdf995. On their site, there are
examples for developers in VBA.

http://www.freeware995.com/misc/vbacode.txt


Wow, that's ugly code.

I'd suggest replacing the hardwired All Users reference with the
environment variable ALLUSERSPROFILE, for one.

The code also reminds me of PDF995's poor behavior in insisting that
install itself in the root of your C: drive. That's *extremely* bad
design for an application designed to run under any NT-based version
of Windows other than NT 4 itself, since by default, the root of C:
is read-only accessible to users.

I use PPF995, but this one thing is very, very poorly implemented.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #3
I too have struggled with the automated conversion of a report to PDF.
I finally ended up automating snapshot outputs and then converting
those to PDF...

Nov 13 '05 #4
Even if it is ugly (or may be not), if it works and is reliable...who cares?

..
Wow, that's ugly code.

I'd suggest replacing the hardwired All Users reference with the
environment variable ALLUSERSPROFILE, for one.

The code also reminds me of PDF995's poor behavior in insisting that
install itself in the root of your C: drive. That's *extremely* bad
design for an application designed to run under any NT-based version
of Windows other than NT 4 itself, since by default, the root of C:
is read-only accessible to users.

I use PPF995, but this one thing is very, very poorly implemented.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

Nov 13 '05 #5
"Saintor" <sa******@REMOVETHIShotmail.com> wrote in
news:yQ*******************@wagner.videotron.net:
Even if it is ugly (or may be not), if it works and is
reliable...who cares?


Ugliness in code generally indicates to me that:

1. there are design problems that necessitate the ugliness, AND

2. it's a maintenance problem, particularly with hardwired paths.

When I see ugly code provided by a 3rd party, it makes me think
"Hmm, looks like this was not written by someone who knows too much
about conventions for programming in this particular language." and
that makes me suspect the code overall.

It may very well work.

It may very well be the best code that can be used to accomplish the
task.

And I might very well use it.

But I still would feel uncomfortable about it.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #6
Hi Nick,

Thank you very much for your input...
I looked into this option as well but was unclear on how to convert SNP
to PDF. Do you have any suggestions and/or code?

Thanks again Nick...

Regards,
Dave

Nov 13 '05 #7
Hi David and Saintor,

Thank-you both for your input...
Saintor, I will look into this code more carefully. Although I am very
interested in Nick's suggestion, i.e. the conversion from SNP to PDF.
Any case, I open to all suggestions. Fact of the matter all, what was
Adobe thinking? You would think a company would want to retain
functionality that promotes their product ?!? Such is life...

Dave

Nov 13 '05 #8

Thank you very much for your input...
I looked into this option as well but was unclear on how to convert SNP
to PDF. Do you have any suggestions and/or code?


Once Acrobat is installed, I believe you can just right-click the
Snapshot file and choose 'Convert to PDF.'

I didn't have any luck automating this process with VBA.

Nov 13 '05 #9
Hi Nick,

Thanks for your quick response...
I, unfortunately, don't get the option 'Convert to PDF' when I right
click on the file. In any case, I would have to implement something
that converts the file through code.

Thanks for your time...

Regards,
Dave

Nov 13 '05 #10
I have a solution I will be posting this weekend hopefully. It converts
Reports or Snapshots to PDF documents. The Snapshot file is comprised of
Enhanced Metafiles(EMF), one for each page of the report. Each EMF is
comprised of records that render the elements of the output page.
I purchased a developer's license for a third party PDF library. It has the
capability to convert the records of an EMF file to their PDf counterparts.
This is a one to one mapping of Metafile to PDF records. The resultant PDF
document is as fully editable as any normal PDF doc. The developer of the
library has kindly consented to allow me to redistribute his library in my
Freeware solution.

This solution is comprised of an MDE file and the PDF library DLL. It's a
standard Windows DLL, not an ActiveX DLL so no registration is required. No
printer driver is required therefore the solution will work even on desktops
locked down by corporate IT.

If you want, send me an Email and I'll forward you a Beta for you test. I
have tested it on more than 40 reports where it has converted perfectly but
it's time to broaden the tests.
My Email address is:
my*********@mylastname.com

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"DGB @ Sun" <Da***************@SunLife.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...
Hi Nick,

Thanks for your quick response...
I, unfortunately, don't get the option 'Convert to PDF' when I right
click on the file. In any case, I would have to implement something
that converts the file through code.

Thanks for your time...

Regards,
Dave

Nov 13 '05 #11
What about CutePDF Writer - http://www.cutepdf.com/ a shareware utility
(with a freeware version) that installs itself to look like an optional
printer?

On 14 Oct 2005 12:30:47 -0700, "DGB @ Sun" <Da***************@SunLife.com>
wrote:
Hello All,

I have been doing quite a bit of research in this group and have not
been able to find the answer that I am looking for.

Here is my issue. We currently have Adobe Acrobat v5 installed on our
system (under Windows 2000 Professional). Currently, we are using MS
Access 2000. Early next year we will be moving to Windows XP (probably
converting to MS Access XP as well) and have been told that Adobe
Acrobat v6 is to be installed as the new standard. Oh yeah - they have
also told us NO to having Acrobat v5 installed. This means that we will
no longer have access to PDF Writer, which we currently utilise to
generate PDF documents from reports. PDF Distiller apparently is
replaced with PDF Print (if memory serves me well). I have tried
working with PDF Distiller and have not had any success, very messy,
unlike PDF Writer.

My question for the group is; does any know how I am will be able to
generate PDF documents from MS Access 2000/XP without PDF writer using
Adobe Acrobat v6 PDF print? Oh yeah - third party tools (other then MS
Office and Adobe Acrobat v6 standards) are a NO NO, for example Win2PDF
etc.

Does anyone have any suggestions? Has anyone been able to PDF Print to
work from VBA?

Please note: I'd rather not get into creating SNP (snapshot views)
since we send our documents externally at times).

Thank-you all, in advance, for your time and attention to this
matter...

Regards,
Dave

Nov 18 '05 #12
There are some problems printing to it programmatically: I don't believe
it's possible without some user interaction. However, PDF995
http://www.pdf995.com does support automation.

Of course, David did say no third part products.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

<lo*****@internet.com> wrote in message
news:gs********************************@4ax.com...
What about CutePDF Writer - http://www.cutepdf.com/ a shareware utility
(with a freeware version) that installs itself to look like an optional
printer?

On 14 Oct 2005 12:30:47 -0700, "DGB @ Sun" <Da***************@SunLife.com>
wrote:
Hello All,

I have been doing quite a bit of research in this group and have not
been able to find the answer that I am looking for.

Here is my issue. We currently have Adobe Acrobat v5 installed on our
system (under Windows 2000 Professional). Currently, we are using MS
Access 2000. Early next year we will be moving to Windows XP (probably
converting to MS Access XP as well) and have been told that Adobe
Acrobat v6 is to be installed as the new standard. Oh yeah - they have
also told us NO to having Acrobat v5 installed. This means that we will
no longer have access to PDF Writer, which we currently utilise to
generate PDF documents from reports. PDF Distiller apparently is
replaced with PDF Print (if memory serves me well). I have tried
working with PDF Distiller and have not had any success, very messy,
unlike PDF Writer.

My question for the group is; does any know how I am will be able to
generate PDF documents from MS Access 2000/XP without PDF writer using
Adobe Acrobat v6 PDF print? Oh yeah - third party tools (other then MS
Office and Adobe Acrobat v6 standards) are a NO NO, for example Win2PDF
etc.

Does anyone have any suggestions? Has anyone been able to PDF Print to
work from VBA?

Please note: I'd rather not get into creating SNP (snapshot views)
since we send our documents externally at times).

Thank-you all, in advance, for your time and attention to this
matter...

Regards,
Dave

Nov 18 '05 #13

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Nicola | last post by:
Hi Everyone, I am new to programming and would like to know how to open an access Report from within vb 6. I am trying to write a program to organise cross stitch threads. I have found out how...
2
by: Tom Weddell | last post by:
Can I call an Access report from VB.Net? (I'm using access as the backend.) Thanks in advance.
2
by: Vikrant | last post by:
Hey Friends I need to export an Access Report using a filter. I am using the method OutputTo m_pDoCmd->OutputTo( 3, // asOutputReport COleVariant(strReportName), // <report name>...
15
by: Mark C | last post by:
All, I have exhaustingly been looking through the newsgroups in search of a way to systemically output an Access 97 report to a pdf file using the full version of Adobe Acrobat. I want the user...
8
by: Mike MacSween | last post by:
tblCourses one to many to tblEvents. A course may have an intro workshop (a type of event), a mid course workshop, a final exam. Or any combination. Or something different in the future. At...
4
by: Greg Teets | last post by:
I am running an Access report from VB via ADO. The report has a field that shows the time it was run. Is it possible to return the data from this field to VB when the report runs? Or to find...
3
by: Newbie | last post by:
This is my first try at running Access Report by Visual Basic I have the following code in my button press event: ' 2 - Show print preview objAccess.DoCmd.OpenReport "Invoices", 2, , ".=" & _...
9
by: RMC | last post by:
Hello, I'm looking for a way to parse/format a memo field within a report. The Access 2000 database (application) has an equipment table that holds a memo field. Within the report, the memo...
6
by: DeniseY | last post by:
I have an Access report that is created on the fly by the user selecting the fields to be included. The Access report comes out fine, but I want it to automatically output to an Excel spreadsheet....
1
by: sonicfun2006 | last post by:
I have SQL Server Database and MS Access 2003 is connected with ODBC. I have very large amount of records in various tables. The database is very dynamic as it changes every minute. I’m trying to...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.