?
Solved

Access report prints to pdf, how do I close Adobe.

Posted on 2004-09-29
4
Medium Priority
?
252 Views
Last Modified: 2008-03-06
I have an Access procedure (written in Basic) that prints 2 Access reports, and then opens Acrobat 6.0 to build 2 pdf files (from the reports).  Is there a line of code I can add to the procedure to close Acrobat 6.0 after the files have been created????
Thanks...Debbie
0
Comment
Question by:Debbie12
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 41

Accepted Solution

by:
shanesuebsahakarn earned 2000 total points
ID: 12181674
There's an option in Acrobat somewhere (I think it's in the printer settings) that stops Acrobat from launching after a PDF file is created.
0
 
LVL 2

Expert Comment

by:grayderek
ID: 12182149
Shane is right, print any document to Acrobat PDFWriter printer and when you get the save as screen up you will see a check box 'view pdf file' check this box off and all should be well.  Would like to see the code.

0
 

Author Comment

by:Debbie12
ID: 12182158
I never would have thought of that!  Thanks so much, it worked!
Debbie
0
 
LVL 2

Expert Comment

by:grayderek
ID: 12182313
Q answered, shane got the points, hard life.  Ho Hum

But glad you solved the problem!
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question