Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / October 2007

Tip: Looking for answers? Try searching our database.

Report Distribution

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Regina - 11 Oct 2007 21:36 GMT
I have a report sorted by physicians and it prints to 600 pages.  I need to
save the report pdf format individually for each physician so I can e-mail it
to them.  Is there a way of doing this automaticall without me having to run
about 100 separate reports?  Any help/suggestion will be greatly appreciated.

Thanks
HiTechCoach - 12 Oct 2007 06:10 GMT
To answer another thread, I have posted a working example of how  to do this
type of task here

http://www.utteraccess.com/forums/showflat.php?Cat=&Number=1319913&page=&view=&s
b=5&o=&fpart=1&vc=1


using a tools to create PDF's from here

http://www.lebans.com/reporttopdf.htm

Code for the above example:

   Dim qdf As DAO.QueryDef
   Dim strSQL As String
   Dim strPathName As String
   Dim blRet As Boolean
   Dim rs As Recordset
   
 
   strSQL = "SELECT customer.customerID, customer.cusname FROM customer;"
   
   Set rs = CurrentDb.OpenRecordset(strSQL, dbOpenSnapshot)
   
   
   If rs.RecordCount < 1 Then
      Exit Sub
   End If
   
   Do
   
       Set qdf = CurrentDb.QueryDefs("customer Query")
       strSQL = "SELECT customer.customerID, customer.cusname, customer.
cusnum, customer.testmemo FROM customer"
       strSQL = strSQL & " WHERE (((customer.customerID)=" & rs!customerID &
"));"
       qdf.SQL = strSQL
       qdf.Close
       Set qdf = Nothing
   
       ' put in the my documnets folder
       ' strPathName = Environ("userprofile") & "\my documents\" & Me.
cbocustomerID.Column(1) & ".pdf"
   
        strPathName = rs!cusname & ".pdf"
   
   
       blRet = ConvertReportToPDF("customer Query", vbNullString,
strPathName, False, False, 0, "", "", 0, 0)

       rs.MoveNext
   
  Loop Until rs.EOF

  rs.Close
 
  Set rs = Nothing

>I have a report sorted by physicians and it prints to 600 pages.  I need to
>save the report pdf format individually for each physician so I can e-mail it
>to them.  Is there a way of doing this automaticall without me having to run
>about 100 separate reports?  Any help/suggestion will be greatly appreciated.
>
>Thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.