Access opening PDF's 1

[shadyness]

I have an an access 2000 database that archives a list of scanned invoices by a hyperlink that refers to a location on the same network as the database. These invoives are stored in the .PDF format. In my base I developed a query in SQL that calls up the hyperlinks from the squel BE utilizing a user defined key word search. So for instance, if a user searches for "Company X" 17 hyperlinks may appear listing all relevant PDF's that are stored on the network. The client would like to be able to simply "print all", so to speak. So my question is, can access open up several hyperlinks located on a network and print them all, without opening each PDF individually?The user can already view each one individually, the ability to print is what would be key. Any suggestions would be greatly appreciated. Thank you.

 

[TrojanRabbit]

It may take a Shell command to print the file. One direction you can look in. Commands like ShellExecute. Explorer gives the option to print a file, so there ought to be some Shell method for doing so.

 

[shadyness]

would this be an API declaration type deal? i found some code that would work from VB like this:

+++++++++++++++++++++++++++++++++++++++++++++
Option Explicit

'========================================================
' API declaration
'========================================================
Private Declare Function ShellExecute _
Lib "shell32.dll" Alias "ShellExecuteA" ( _
ByVal hwnd As Long, _
ByVal lpOperation As String, _
ByVal lpFile As String, _
ByVal lpParameters As String, _
ByVal lpDirectory As String, _
ByVal nShowCmd As Long) As Long

Private Sub Form_Load()
Dim sFile As String
Dim sCommand As String
Dim sWorkDir As String

sFile = "C:\albums\index.html" 'The file to execute
sCommand = vbNullString 'Command line parameters
sWorkDir = "C:\albums" 'The working directory

ShellExecute hwnd, "open", sFile, sCommand, sWorkDir, 1
End Sub

+++++++++++++++++++++++++++++++++++++++++++++++

But I dont know if I could populate the SFile with the hyperlinks from the query.