Code Samples - Neevia docCreator

Example 5: Convert a MS Access report into PDF - Delphi 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
42
43
44
45
46
47
48
49
50
51
52
   procedure convertAccessToPDF();
   var
     DC,
     objAccess : Variant;
     RVal : Integer;
     docToConvert,
     defPrinter : String;
   begin
      docToConvert := 'c:\users\public\access.mdb';
      try
        DC := CreateOleObject('Neevia.docCreator');
   
        DC.setParameter('DocumentOutputFormat', 'PDF');
        DC.setParameter('DocumentOutputName', 'testAccess_Delphi');
        DC.setParameter('DocumentOutputFolder', 'c:\users\public\');

        RVal := DC.startPrinting;
        if (RVal <> 0) then
        begin
          ShowMessage('Error while calling StartPrinting method!!!');
          Exit;
        end;
        defPrinter := DC.getDefaultPrinter;

        try
          objAccess := CreateOleObject('Access.Application');
          DC.setDefaultPrinter(DC.newPrinterName);
          objAccess.OpenCurrentDatabase(docToConvert, true);

          //rptCtatalog is the repport name
          objAccess.DoCmd.OpenReport('rptCatalog', 0);

          objAccess.Quit(2);
          objAccess := Unassigned;

          DC.setDefaultPrinter(defPrinter);
          RVal := DC.create; // Create output document
          if (RVal <> 0) then
            ShowMessage('Error while creating document!!! Code: '+IntToStr(RVal))
          else
            ShowMessage('Document Created !!!');
        except
          on E: Exception do
            ShowMessage(E.Message);
        end;
      finally
        RVal := DC.stopPrinting;
        if (RVal <> 0) then ShowMessage('Error while calling StopPrinting!!!');
        DC := Unassigned;
        objAccess := Unassigned;
      end;
   end;