Code Samples - Neevia docuPrinter SDK

Example 7: Convert a MS Access report into PDF - Visual Basic Copy 

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
   Sub AccessConverter()

      Dim DPSDK : Set DPSDK = CreateObject("docuPrinter.SDK")
      DPSDK.BackupSettings
 
      DPSDK.DocumentOutputFormat = "PDF"
      DPSDK.DocumentOutputName = "demoAccess"
      DPSDK.DocumentOutputFolder = "c:\users\public\"
 
      DPSDK.DocumentResolution = 300
 
      DPSDK.HideSaveAsWindow = true
      DPSDK.DefaultAction=1
 
      DPSDK.ApplySettings
 
      Dim objAccess
      Set objAccess = CreateObject("Access.Application")
 
      Dim defPrinter : defPrinter=DPSDK.GetDefaultPrinter
 
      DPSDK.SetDefaultPrinter "docuPrinter"
      objAccess.OpenCurrentDatabase "c:\users\public\access.mdb", true
 
      objAccess.DoCmd.OpenReport "rptCatalog", 0
      'rptCtatalog is the repport name
 
      objAccess.Quit 2
      Set objAccess=nothing
   
      RVal = DPSDK.Create ' Create output document
      If (RVal <> 0) Then MsgBox "Error. Create returns "+CStr(Rval)
 
      DPSDK.SetDefaultPrinter defPrinter

      DPSDK.RestoreSettings
      Set DPSDK = Nothing
 
      MsgBox "Done converting!!!"

   End Sub