Printing Problem

[Frank]

Hello!

My app records "attachments" in a table like -

lngParentID, strDocumentPathAndName
10001, "C:\MyApp\Attachments\10001_Attachment1.xls"
10001, "C:\MyApp\Attachments\10001_Attachment2.txt"
10001, "C:\MyApp\Attachments\10001_Attachment3.pdf"
10002, "C:\MyApp\Attachments\10002_Attachment1.pdf"

The attachment files can be of any type (.pdf, .doc, .txt, etc.).

Can anyone suggest some code to loop throught the attachments for a given
'parent' and print each attachment to th default printer?

Thanks in advance ...

 

[Alex Dybenko]

hi,
you can try to use ShellExecute to print files, see:
http://www.mvps.org/access/api/api0018.htm

for PDF you can try this:
http://accessblog.net/2008/01/printing-pdf-from-code.html

Loop through attachments - see OpenRecordset in online help

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com