473,322 Members | 1,911 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,322 software developers and data experts.

pdf printing

I have looked through many newsgroups to see how I can print several
pdf documents to a printer, from Access using vba. The documents are
scans of images, so I don't think they can be open through Word as
text files. Ideally, I would like to use more solid code other than
Shell, but it seems that it is only the way. Using switches. /h /p, I
think!!

I do not alot about using switches and the Shell command, but would
like my code to do something like this

1. Open Adobe Reader
2. Loop through various pdf files, print & close them
3. Close Adobe Reader

Do I have to launch Adobe Reader everytime I open the pdf document?
How do I locate reader if my users are using different versions?

I have also noticed that the documents open up in internet explorer,
is there any way of controlling Internet Explorer from Access? If so
what is the Type Library.

Please, please, could somebody point me in the right direction?
Thanks.

Regards,
Steven Taylor
Nov 13 '05 #1
1 3374
it******@manx.net (S Taylor) wrote in message news:<55**************************@posting.google. com>...
I have looked through many newsgroups to see how I can print several
pdf documents to a printer, from Access using vba. The documents are
scans of images, so I don't think they can be open through Word as
text files. Ideally, I would like to use more solid code other than
Shell, but it seems that it is only the way. Using switches. /h /p, I
think!!

I do not alot about using switches and the Shell command, but would
like my code to do something like this

1. Open Adobe Reader
2. Loop through various pdf files, print & close them
3. Close Adobe Reader

Do I have to launch Adobe Reader everytime I open the pdf document?
How do I locate reader if my users are using different versions?

I have also noticed that the documents open up in internet explorer,
is there any way of controlling Internet Explorer from Access? If so
what is the Type Library.

Please, please, could somebody point me in the right direction?
Thanks.

Regards,
Steven Taylor


If you use the default folder when you install Acrobat Reader you can
use the following function:

'----------------------
Public Function GetAcroPath() As String
Const LatestVer = 6
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\"
strAcroDir(4) = "C:\Program Files\Adobe\Acrobat 6.0\Reader\"
'strAcroDir(5) = "C:\Program Files\Adobe\Acrobat 7.0\Reader\"
strLocatedAcroDir = ""
For I = LatestVer - 2 To 1 Step -1
If Dir(strAcroDir(I), vbDirectory) <> "" Then
strLocatedAcroDir = strAcroDir(I)
Exit For
End If
Next I
GetAcroPath = strLocatedAcroDir & "AcroRd32.exe"
End Function
'----------------------
Note: You can check for the existence of this file before trying a
ShellExecute API function. Acrobat Reader works much faster when the
files are opened and closed without exiting.

If Acrobat Reader doesn't have all the command line switches you need
it may also be possible to use the Acrobat SDK to set up automation.
Acrobat Reader does not provide natively the automation interface that
would solve your problem simply. Perhaps Acrobat Reader Extensions
exposes such an interface. I would also check out the 3rd party
plug-ins listed on Adobe's site:

http://www.adobe.com/products/plugins/acrobat/main.html

Using the IE interface provides some other automation possibilities
when something like pdf.ocx is used.

I hope some of this helps,
James A. Fortune

Is a novice EBay user an EBaby?
Nov 13 '05 #2

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

Similar topics

4
by: Jody Gelowitz | last post by:
I am having a problem with printing selected pages. Actually, the problem isn't with printing selected pages as it is more to do with having blank pages print for those pages that have not been...
0
by: Programatix | last post by:
Hi, I am working on the PrintDocument, PrintDialog, PageSetupDialog and PrintPreviewControl components of Visual Studio .NET 2003. My developement machine is running Windows XP. There are...
9
by: Jody Gelowitz | last post by:
I am trying to find the definition of "Safe Printing" and cannot find out exactly what this entitles. The reason is that I am trying to print contents from a single textbox to no avail using the...
4
by: Suzanka | last post by:
Hello, I have an application written in C# on visual studio .NET. It is a web aplication. The application consists of many different forms, that users occassionaly want to print out for filing....
4
by: Arif | last post by:
I C# code prints very slow as compared to a third party barcode printing software. That software prints approximately 10 labels in 2 seconds while my C# code prints 10 labels in 5 to 6 seconds. And...
6
by: Siv | last post by:
Hi, I am getting into printing with VB.NET 2005 and want to implement the usual capability that a user can select a selection of pages. I have a report that is generated by my application that if...
8
by: Neo Geshel | last post by:
Greetings. BACKGROUND: My sites are pure XHTML 1.1 with CSS 2.1 for markup. My pages are delivered as application/xhtml+xml for all non-MS web clients, and as text/xml for all MS web...
0
by: nikhilgargi | last post by:
Requirement: I need to provide printing capability in a C# desktop application that I am developing The documents that need to be printed can be in Rich Text Format (RTF) or HTML. Custom...
18
by: Brett | last post by:
I have an ASP.NET page that displays work orders in a GridView. In that GridView is a checkbox column. When the user clicks a "Print" button, I create a report, using the .NET Framework printing...
0
it0ny
by: it0ny | last post by:
Hi guys, thanks I am fairly new to this forum so I hope I chose the right place to post this question. I try to make my program printout a deposit's report. I created a class to store the...
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...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
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)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
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...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.