HOW: print access 2000 reports to pdf using vb code? 
Author Message
 HOW: print access 2000 reports to pdf using vb code?

How can you print access 2000 reports to pdf without the user having to fill
in any dialogue boxes or manually goto print themselves? Ive seen a few
sites where you can purchase add-ins that output access reports to pdf
completely automatically
( http://www.***.com/ ) - but I
really dont want to use an addin, I'd rather develop the code and be able to
implement it myself.  Apparently adobe (www.adobe.com) has some examples on
their site explaining how to do this, but I cant seem to find them.  If
anyone has any knowledge of how this would be done, please email me or reply
to this post!! Thanks!


Mon, 28 Jun 2004 04:20:18 GMT
 HOW: print access 2000 reports to pdf using vb code?

I found this on planet source code.  There was a lot more involved in the
original coding statment, but after a little cleanup this worked.  It
printed out the reports perfectly. The only problem is that actually opens ,
makes visible and closes  Access.  This slows down the App somewhat.  I
think if you Set  an Object (Access.Application) or set your References to
Access and then use the Docmd.OpenReport "Whatever" it might work.  Have not
had time to try that.

Dim dbPath As String
Application.OpenCurrentDatabase "DatabasePath", False
DoCmd.OpenReport "ReportName"
Application.CloseCurrentDatabase


Quote:
> How can you print access 2000 reports to pdf without the user having to
fill
> in any dialogue boxes or manually goto print themselves? Ive seen a few
> sites where you can purchase add-ins that output access reports to pdf
> completely automatically
> (http://ourworld.compuserve.com/homepages/attac-cg/acgsoft.htm) - but I
> really dont want to use an addin, I'd rather develop the code and be able
to
> implement it myself.  Apparently adobe (www.adobe.com) has some examples
on
> their site explaining how to do this, but I cant seem to find them.  If
> anyone has any knowledge of how this would be done, please email me or
reply
> to this post!! Thanks!



Mon, 28 Jun 2004 10:04:55 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Printing Access reports or using Access to print/preview reports

2. Print Access report w/VB code

3. Importing an Access 2000 table into another Access 2000 database with VB Code

4. Newbie needs code pages for SQL Server 2000 access from asp.net page using vb.net

5. Exporting data to excel report from access database using vb code

6. Getting list of reports and printing from Access DB using VB

7. preview access report using VB code...

8. Printing current report from VB using access

9. Code report print <> Manual report print

10. Crystal Reports ANd VB 6.0 Printing reports using CRPEAUTO Object, specifying paper orientation problem

11. Printing report from Dynaset using Crystal Report and VB


 
Powered by phpBB® Forum Software