Checkbox properties

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form with a check box. When this check box is checked I want it to print a document (an Adobe PDF tax form). I am trying to figure out how to write a macro to open and print a form that is not a db object but a file location or how to write the VBA code to do this. Can anyone help
 
Bradley,

You can use a RunApp macro to open the pdf file. I'm not sure whether
you can print it automatically from within Access. The Command Line for
the RunApp would be something like...
"C:\Program Files\Adobe\AcroRd32.exe" "C:\PathToFile\TaxForm.pdf"
 
Steve thanks this worked great. Now I need to take it another step. 1. How do I get the Adobe window to open maximized. 2. How can I get it to automatically print
I tired the PrinOut Action but that is only good for db objects, as well as the Maximize Action. What I would like it to do is when this checkbox is selected that it automaically print our this form. So far so good can you help me out with the rest

Bra

----- Steve Schapel wrote: ----

Bradley

You can use a RunApp macro to open the pdf file. I'm not sure whether
you can print it automatically from within Access. The Command Line for
the RunApp would be something like..
"C:\Program Files\Adobe\AcroRd32.exe" "C:\PathToFile\TaxForm.pdf
 
I am sorry, Brad, I am not sure whether this is possible. It certainly
is not possible with a macro. I think it may be possible with some API
calls via VBA code, but I don't myself know how. A post to the
microsoft.public.access.modulesdaovba newsgroup might reap an answer.
 
Back
Top