I agree with you on using VB, baileyhp, but I am working with an existing database written by a former employee and trying to modifyu it to print these documents. I was able to get it to work, but it does not seem to work on all of our computers, only a few select ones.
Thanks.
I should have clarified that the error I am getting is that the file does not exist. The shell command does call Acrobat. I inserted a message box to verify it was calling the right path, and it is calling the correct path to the test file.
Thanks again!
Rafe
Thanks Manny!
We only have one person on Win NT at my office, everyone else is on Win 98...soon to be Win 2000. Maybe the problem is not with his OS...I will keep investigating!
Rafe
I am using the Shell Command to call Adobe Acrobat Reader from an Access 97 form to display a pdf report:
Shell (C:\Acrobat\Reader\AcroRd32.exe " & strDocName, vbNormalFocus
This works fine on my Win 98 machine, but not on a Win NT machine. Are there any know conflicts or alternative...
Update!
My success was short-lived. I have VB 6.0 and Adobe Acrobat 5.0 on my desktop and the code worked fine. However, when I tried to run the code from a desktop with only Acrobat Reader installed (no VB), it was not able to call the Acrobat Exchange. Someone has suggested using a shell...
Update!
My previously posted success was short lived. The code works fine on my desktop with VB 6.0 and Adobe Acrobat 5.0 installed. The code to open the Adobe Exchange did not work on desktops with only Adobe Reader installed (no VB). Someone suggested I use a shell command, so I will...
Thanks to Jes from the VBA Coding Forum, I was able to use a program written by Dev Ashish on a site called "The Access Web" which uses an API to call the standard windows dialog box. www.mvps.org/access/api/api0001.htm
The code is over my head, but I was able to decipher it enough...
Thanks Jes!
I was able to use the program written by Dev Ashish to call the standard windows dialog box.
The code is over my head, but I was able to decipher it enough to open in the desired directory and limit the available (viewed) files to those with a .pdf extension. I would also like to...
I am trying to allow a user to choose a pdf file from a specified directory and either open or print the file. Is there something similar (API...?) to VB's CommonDialog Control that will accomplish this?
Thank you,
Rafe
I am trying to allow a user to choose a pdf file from a specified directory and either open or print the file. Is there something similar (API...?) to VB's CommonDialog Control that will accomplish this?
Thank you,
Rafe
I am trying to allow a user to choose a pdf file from a specified directory and either open or print the file. Is there something similar (API...?) to VB's CommonDialog Control that will accomplish this?
Thank you,
Rafe
Hello everyone. I need help printing pdf documents from an Access 97 form. The documents are inspection reports for various buildings owned by a govertment entity, one report per building. I would like the user to be able to pick the requested report from the directory where all the reports...
Hello Everyone. I need help (code examples & advice) to program two buttons (or CommonDialog Controls..?), one on each of two seperate forms. I am not a programmer, but have played around with Access and Visual Basic to create some basic databases and VB programs.
Form #1: The button...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.