Everyone,

I am using Acrobat 7.0 Professional edition. In MS Access, I am using the
following lines of code to open and print the document.

sAcrobatReaderExe = "C:\Program Files\Adobe\Acrobat 7.0 Acrobat\Acrobat.exe"
retval = Shell(sAcrobatReaderExe & " /t " & " " & strFolder & strFile)

However, each time I loop through this code anothe instance of Acrobat opens
up.

Is there a command line switch to close the file?

Thanks,

Hi,
have a look here:
http://accessblog.net/2008/01/printi...from-code.html

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


"Michael Cochran" <Michael (E-Mail Removed)> wrote in
message news7C6A03B-31C7-4132-91F6-(E-Mail Removed)...
> Everyone,
>
> I am using Acrobat 7.0 Professional edition. In MS Access, I am using the
> following lines of code to open and print the document.
>
> sAcrobatReaderExe = "C:\Program Files\Adobe\Acrobat 7.0
> Acrobat\Acrobat.exe"
> retval = Shell(sAcrobatReaderExe & " /t " & " " & strFolder & strFile)
>
> However, each time I loop through this code anothe instance of Acrobat
> opens
> up.
>
> Is there a command line switch to close the file?
>
> Thanks,
>
>