Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Automatic printing

Status
Not open for further replies.

JPMontreal

Programmer
Feb 18, 2002
153
US
Hi,

I use Access to send information with Lotus note, it must be sent automatically. I print a report and e-mail it, it work find until for formatting raison we need to print the report with Acrobat.

I set Acrobat as the default printer on the computer where the e-mails are send.
Use the following code to print it:

Sub PrintRPT()
DoCmd.SetWarnings False
DoCmd.OpenReport "rptTasksWeb", acViewNormal
DoCmd.PrintOut
DoCmd.Close acReport, "rptTasksWeb", acSaveNo
DoCmd.SetWarnings True
End Sub

With it, a window popup and ask for the name of the acrobat file that will be created and it want to print as well the active form and ask for a name. Another procedure sends the rapport, this work well.

This must be automatic, so nobody will be there to answer the questions. How could I fix it?

Thanks,


Jean-Paul
Programmer.
 
Jean-Paul,
That's an Acrobat option to ask you for the file name and view the document. I think you will find it in File|Preferences, or Edit|Preferences. I believe the Option is called "Output Options" or something similar.

I don't have Acrobat on this computer or I'd look it up for you.

Tranman
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top