473,756 Members | 1,810 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Generate PDF with VB code in Acrobat 6.0

My VB Application opens an Access Report and has an option to generate the
report in PDF once the report is closed. This is accomplished by:

- Switching over to the Acrobat Printer (i.e. PDFWriter) from the default
printer.

- Setting a string type sub key "PDFFilenam e" in the registry
"HKEY_CURRENT_U SER\Software\Ad obe\Acrobat PDFWriter" to store the PDF in
a user selected directory with a filename that's determined by VB codes.

- Generating the PDF by issuing the command ".DoCmd.OpenRep ort sReport,
acViewNormal".

- Closing the report by issuing the command ".DoCmd.Clo se acReport,
ReportName, acSaveNo".

- Resetting to the default printer from Acrobat Printer "PDFWriter" .

This works fine with Acrobat 5.0. When I recently installed Acrobat 6.0, I
managed to set the directory and name of the PDF into a string type sub key
"PDFFilenam e" in the registry "HKEY_CURRENT_U SER\Software\Ad obe\Acrobat
PDFMaker". However, I ran into a host of problems:

- Acrobat 6.0 does not recognize the filename in the string type sub key
"PDFFilenam e" in the registry. Instead, it uses its own default filename to
save the PDF.

- Acrobat 6.0 does not recognize the user selected directory in the string
type sub key "PDFFilenam e" in the registry. Instead, it saves the PDF in the
"My Documents" directory even though I left the "Location" textbox blank in
the printing preference property of Acrobat 6.0 printer "Adobe PDF" in
Window's printer setting.

Can you please show me the proper procedures to automatically generate PDF
by using Acrobat 6.0?

The methods that I used in Acrobat 5.0 to set up PDFWriter does not
work with Acrobat 6.0. Would I have to work with the registry, or
postscripts, or distiller?

Your help is greatly appreciated.

Thank you


Nov 12 '05 #1
4 7337
Set the printer to "Acrobat Distiller" rather than "PDFWriter" ?

On Thu, 19 Feb 2004 14:22:43 -0500, "Andrew" <an****@abc.c a> wrote:
My VB Application opens an Access Report and has an option to generate the
report in PDF once the report is closed. This is accomplished by:

- Switching over to the Acrobat Printer (i.e. PDFWriter) from the default
printer.

- Setting a string type sub key "PDFFilenam e" in the registry
"HKEY_CURRENT_U SER\Software\Ad obe\Acrobat PDFWriter" to store the PDF in
a user selected directory with a filename that's determined by VB codes.

- Generating the PDF by issuing the command ".DoCmd.OpenRep ort sReport,
acViewNormal ".

- Closing the report by issuing the command ".DoCmd.Clo se acReport,
ReportName, acSaveNo".

- Resetting to the default printer from Acrobat Printer "PDFWriter" .

This works fine with Acrobat 5.0. When I recently installed Acrobat 6.0, I
managed to set the directory and name of the PDF into a string type sub key
"PDFFilename " in the registry "HKEY_CURRENT_U SER\Software\Ad obe\Acrobat
PDFMaker". However, I ran into a host of problems:

- Acrobat 6.0 does not recognize the filename in the string type sub key
"PDFFilename " in the registry. Instead, it uses its own default filename to
save the PDF.

- Acrobat 6.0 does not recognize the user selected directory in the string
type sub key "PDFFilenam e" in the registry. Instead, it saves the PDF in the
"My Documents" directory even though I left the "Location" textbox blank in
the printing preference property of Acrobat 6.0 printer "Adobe PDF" in
Window's printer setting.

Can you please show me the proper procedures to automatically generate PDF
by using Acrobat 6.0?

The methods that I used in Acrobat 5.0 to set up PDFWriter does not
work with Acrobat 6.0. Would I have to work with the registry, or
postscripts, or distiller?

Your help is greatly appreciated.

Thank you


Nov 12 '05 #2
Thanks for replying. After I installed Acrobat 6.0, "Adobe PDF" is listed
as the printer. How do I set the printer to "Acrobat Distiller"?
Since I want to use VB codes to generate the PDF, would I have to modify the
registry just like I did in Acrobat 5.0?
"Elaine" <no************ ******@dced.sta te.ak.us> wrote in message
news:40******** *******@news.st ate.ak.us...
Set the printer to "Acrobat Distiller" rather than "PDFWriter" ?

On Thu, 19 Feb 2004 14:22:43 -0500, "Andrew" <an****@abc.c a> wrote:
My VB Application opens an Access Report and has an option to generate thereport in PDF once the report is closed. This is accomplished by:

- Switching over to the Acrobat Printer (i.e. PDFWriter) from the default
printer.

- Setting a string type sub key "PDFFilenam e" in the registry
"HKEY_CURRENT_U SER\Software\Ad obe\Acrobat PDFWriter" to store the PDF in
a user selected directory with a filename that's determined by VB codes.

- Generating the PDF by issuing the command ".DoCmd.OpenRep ort sReport,
acViewNormal ".

- Closing the report by issuing the command ".DoCmd.Clo se acReport,
ReportName, acSaveNo".

- Resetting to the default printer from Acrobat Printer "PDFWriter" .

This works fine with Acrobat 5.0. When I recently installed Acrobat 6.0, Imanaged to set the directory and name of the PDF into a string type sub key"PDFFilename " in the registry "HKEY_CURRENT_U SER\Software\Ad obe\Acrobat
PDFMaker". However, I ran into a host of problems:

- Acrobat 6.0 does not recognize the filename in the string type sub key
"PDFFilename " in the registry. Instead, it uses its own default filename tosave the PDF.

- Acrobat 6.0 does not recognize the user selected directory in the stringtype sub key "PDFFilenam e" in the registry. Instead, it saves the PDF in the"My Documents" directory even though I left the "Location" textbox blank inthe printing preference property of Acrobat 6.0 printer "Adobe PDF" in
Window's printer setting.

Can you please show me the proper procedures to automatically generate PDFby using Acrobat 6.0?

The methods that I used in Acrobat 5.0 to set up PDFWriter does not
work with Acrobat 6.0. Would I have to work with the registry, or
postscripts, or distiller?

Your help is greatly appreciated.

Thank you

Nov 12 '05 #3
"Andrew" <an****@abc.c a> wrote:
When I recently installed Acrobat 6.0,


You could try searching at Adobe.com or at groups.google.c om. I've read another
posting along the same lines stating that Adobe blew it on this issue.

Say what you will about Microsoft but Microsoft is very good at providing backward
compatibility.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 12 '05 #4
SA
Andrew:

As you've found Acrobat 6 is totally different that Acro 5's PDF writer.
Acrobat 6's Adobe PDF Printer is essentially the Distiller Printer from
Acrobat 5, updated with new functionality. Adobe has never exposed an easy
method to work with Distiller (e.g. registry or com objects) unless you
start with a postscript file (where in you can use the Distiller's com
object.)

That said, we make a VBA library that you can call from within your Access
db (by using a function wrapper, and then using the Application.Run method
to run that function from VB) that supports outputting Access reports to PDF
files, even using Acrobat 6. Its pretty easy to use with very little code.
You can find it on our web.
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

"Andrew" <an****@abc.c a> wrote in message
news:x0******** ***********@new s20.bellglobal. com...
My VB Application opens an Access Report and has an option to generate the
report in PDF once the report is closed. This is accomplished by:

- Switching over to the Acrobat Printer (i.e. PDFWriter) from the default
printer.

- Setting a string type sub key "PDFFilenam e" in the registry
"HKEY_CURRENT_U SER\Software\Ad obe\Acrobat PDFWriter" to store the PDF in
a user selected directory with a filename that's determined by VB codes.

- Generating the PDF by issuing the command ".DoCmd.OpenRep ort sReport,
acViewNormal".

- Closing the report by issuing the command ".DoCmd.Clo se acReport,
ReportName, acSaveNo".

- Resetting to the default printer from Acrobat Printer "PDFWriter" .

This works fine with Acrobat 5.0. When I recently installed Acrobat 6.0, I
managed to set the directory and name of the PDF into a string type sub key "PDFFilenam e" in the registry "HKEY_CURRENT_U SER\Software\Ad obe\Acrobat
PDFMaker". However, I ran into a host of problems:

- Acrobat 6.0 does not recognize the filename in the string type sub key
"PDFFilenam e" in the registry. Instead, it uses its own default filename to save the PDF.

- Acrobat 6.0 does not recognize the user selected directory in the string
type sub key "PDFFilenam e" in the registry. Instead, it saves the PDF in the "My Documents" directory even though I left the "Location" textbox blank in the printing preference property of Acrobat 6.0 printer "Adobe PDF" in
Window's printer setting.

Can you please show me the proper procedures to automatically generate PDF
by using Acrobat 6.0?

The methods that I used in Acrobat 5.0 to set up PDFWriter does not
work with Acrobat 6.0. Would I have to work with the registry, or
postscripts, or distiller?

Your help is greatly appreciated.

Thank you

Nov 12 '05 #5

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

Similar topics

2
3666
by: jimfortune | last post by:
I have modified my GetAcroPath function to: Function GetAcroDir() As String Const LatestVer = 7 Dim strAcroDir(LatestVer - 2) As String Dim I As Integer strAcroDir(1) = "C:\Program Files\Adobe\Acrobat 3.0\Reader\" strAcroDir(2) = "C:\Program Files\Adobe\Acrobat 4.0\Reader\" strAcroDir(3) = "C:\Program Files\Adobe\Acrobat 5.0\Reader\"
1
1840
by: Wayne Aprato | last post by:
Tooltips in Access have not worked on my machine for a long time despite several reinstalls of the operating system and applications at fairly regular intervals. I have finally pinned down the culprit. I have just performed a reformat and reinstallation of all apps and utilites one at a time and checked that tooltips in Access was working after each new application was installed. Acrobat 5 was the culprit. With it installed tooltips...
3
2132
by: lanem | last post by:
I have created an Outlook Addin using VB.NET. In it, I have added a reference to Acrobat so that I can manipulate some pdf email attachments. Along the way, in my development and testing, I lose the reference to Acrobat somehow. In the Solution Explorer under References, there is a yellow exclamation point on "Acrobat". The only way I've been able to get this back so far is to reinstall Acrobat on my machine(which is a pain). This has...
4
5894
by: William LaMartin | last post by:
I have a vb.net win form where I want to output some text to a printer. Everything works fine when printing to my laser or inkjet printers. However when I print to the Acrobat PDFWriter printer driver, I get correct formatting but the text is gibberish. I am using ev.Graphics.DrawString(line, printFont, Brushes.Black, leftMargin, yPos, New StringFormat) , where line is the text that I wish to print on each line, to print the text. ...
5
7462
by: CDMAPoster | last post by:
I have changed how I get the shell path for Acrobat Reader based on code posted by John deKrafft. Does anyone see any problems with this code running on various Windows OS's? '--Begin Module Code 'Support functions and constants for reading a string from the registry 'I have modified the code posted by John deKrafft slightly '---- Declare Function RegQueryValueEx Lib "advapi32.dll" Alias
21
2238
by: Grant Edwards | last post by:
I need to be able to generate a PDF report which consists mostly of vector images (which I can generate as encapsulated Postscript, PDF, or SVG). What I need is a way to combine these figures into a single PDF document. Right now the reports consist entire of these figures, so I just write the figures out to temp files and then use os.system() to run ghostscript with appropriate options to combine them into a single PDF file. I'd...
10
10363
by: Mauro | last post by:
I'm trying to use the following VB function to transform a pdf document to a tiff one: http://forums.microsoft.com/msdn/showpost.aspx?postid=1665127&siteid=1&sb=0&d=1&at=7&ft=11&tf=0&pageid=1 Private Sub savePDFtoTIF(ByVal fullPathPDF As String, ByVal fullPathTIF As String) Dim PDFApp As Acrobat.AcroApp Dim PDDoc As Acrobat.CAcroPDDoc Dim AVDoc As Acrobat.CAcroAVDoc Dim JSObj As Object
0
1820
by: =?Utf-8?B?QWxoYW1icmEgRWlkb3MgRGVzYXJyb2xsbw==?= | last post by:
Hi all people, everybody, We have multiple versions of Acrobat Reader from 5.x to 8.x, I want to create a method in C# or VB.NET to check to see if the registry key for the versions exists, and if so uninstall it, then install the latest
0
9431
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9255
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10014
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9844
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9819
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9689
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7226
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5119
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5289
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?

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.