print file stored in database

[Dr G. Luco]

Greetings,

I have a large number of files soted in my Db- a variety of types such as
doc, xls, tiff, jpeg, txt. I found the function "fHandleFile" from the
Access Web is able to open the file with the correct application but is
there a way to print the file without user intervention. Sendkeys
sometimnes works but I would like to avoid the risks of using that
functions.

Any suggestions?

Thanks,
Gerry Luco

 

[John Nurick]

Hi Gerry,

This must be possible, though I've not yet found out how to do it.

I *think* the trick is to hook in to whatever is used by the "Print"
item in the context (right-click) menu for the file type in question.
Details for this are stored in the registry but can be seen and edited
in the Tools|Folder Options dialog of Windows Explorer (in the File
Types pane, select the file type, then click Advanced, select Print,
click on Edit).

I presume there's an API (or something in the Windows Scripting object
models) that can be called to execute this "print" command, but so far
haven't located it (but haven't tried very hard<g>).

Alternatively, if you just have a modest number of file types to handle,
you could get the information manually from the Folder Options dialog
and write code to do what's needed for each different file type.