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

   Dim DC : Set DC = CreateObject("Neevia.docCreator")
 
   DC.setParameter "DocumentOutputFormat", "PDF"
   DC.setParameter "DocumentOutputName", "testAccess_VB"
   DC.setParameter "DocumentOutputFolder", "c:\users\public\"
 
   Dim RVal : RVal = DC.startPrinting
   If (RVal <> 0) Then MsgBox "Error while calling StartPrinting method!!!"
 
   Dim objAccess
   Set objAccess = CreateObject("Access.Application")
 
   Dim defPrinter : defPrinter=DC.getDefaultPrinter
 
   DC.setDefaultPrinter DC.newPrinterName
   objAccess.OpenCurrentDatabase "c:\users\public\access.mdb", true

   objAccess.DoCmd.OpenReport "rptCatalog", 0
   'rptCtatalog is the repport name

   objAccess.Quit 2
   Set objAccess=nothing
 
   DC.setDefaultPrinter defPrinter
 
   DC.setParameter "DocumentResolution", "300"
  
   RVal = DC.create ' Create output document
   If (RVal <> 0) Then MsgBox "Error. Create returns "+CStr(Rval)
 
   RVal = DC.stopPrinting
   If (RVal <> 0) Then MsgBox "Error while calling StopPrinting method!!!"

   Set DC = Nothing

   MsgBox "Done converting!!!"