Neevia Technology Sites:   www.neevia.com  |  docuPub.com  |  www.neeviaPDF.com
:: Home :: Products :: Technical Support :: About Us :: Contact Us
Technical support > Neevia docCreator code samples
Example 5: Convert a MS Access report into PDF from C#  Print Example 

1) Add a reference in your project to docCreator library.
To do this:
      a. On the Project menu, click Add Reference.
      b. On the COM tab, locate docCreator Library and then click Select.
      c. Click OK in the Add References dialog box to accept your selections.

2) Add a reference in your project to Microsoft Access.
To do this:
      a. On the Project menu, click Add Reference.
      b. On the COM tab, locate Microsoft Access and then click Select.
      c. Click OK in the Add References dialog box to accept your selections.
   Neevia.docCreator DC = new Neevia.docCreator();

   DC.setParameter("DocumentOutputFormat", "PDF");
   DC.setParameter("DocumentOutputName", "testACCESS_CSHARP");
   DC.setParameter("DocumentOutputFolder", @"d:\");
   DC.setParameter("PDFAutoRotatePage", "All");

   int RVal = DC.startPrinting();
   if (RVal != 0) { MessageBox.Show("Error while calling StartPrinting method!!!"); }

   // This works only with Access 2003
   Microsoft.Office.Interop.Access.Application objAccess =
      new Microsoft.Office.Interop.Access.Application();

   // This works only with Access 2000 and XP
   // Access.Application objAccess = new Access.Application();

   string defPrinter = DC.getDefaultPrinter();

   DC.setDefaultPrinter(DC.newPrinterName());
   objAccess.OpenCurrentDatabase(@"d:\access.mdb", true, "");

   object RN = System.Reflection.Missing.Value;

   // The lines below work only with Access 2003
   objAccess.DoCmd.OpenReport("rptCatalog", 0, RN, RN,
     Microsoft.Office.Interop.Access.AcWindowMode.acHidden, RN);
   //rptCtatalog is the repport name
   objAccess.Quit(Microsoft.Office.Interop.Access.AcQuitOption.acQuitSaveNone);

   // The lines below work only with Access 2000 and XP
   // objAccess.DoCmd.OpenReport("rptCatalog", 0, RN, RN,
   // Access.AcWindowMode.acHidden, RN);
   // objAccess.Quit(Access.AcQuitOption.acQuitSaveNone);

   objAccess = null;

   DC.setDefaultPrinter(defPrinter);

   DC.setParameter("DocumentResolution", "300");

   RVal = DC.create(); // Create output document
   if (RVal != 0) { MessageBox.Show("Error. create returns " + RVal); }

   RVal = DC.stopPrinting();
   if (RVal != 0) { MessageBox.Show("Error while calling stopPrinting method!!!"); }

   DC = null;

   if (RVal == 0) { MessageBox.Show("Done !!!"); }



Copyright © 1999-2016 Neevia Technology. All Rights Reserved. Home | Products | Technical Support | About Us | Contact Us