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

1) Add a reference in your Visual Studio project to docuPrinter library.
To do this:
  • On the Project menu, click Add Reference;
  • On the COM tab, locate docuPrinter Library and then click Select;
  • 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:
  • On the Project menu, click Add Reference.
  • On the COM tab, locate Microsoft Access and then click Select.
  • Click OK in the Add References dialog box to accept your selections.
private void button1_Click(object sender, EventArgs e)
{

   docuPrinter.SDK DPSDK = new docuPrinter.SDK();

   DPSDK.DocumentOutputFormat = "PDF";
   DPSDK.DocumentOutputName = "demoAccess";
   DPSDK.DocumentOutputFolder = @"c:\ ";

   DPSDK.HideSaveAsWindow = true;
   DPSDK.DefaultAction = 1;
   DPSDK.ApplySettings();

   // 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 = DPSDK.GetDefaultPrinter();

   DPSDK.SetDefaultPrinter("docuPrinter");
   objAccess.OpenCurrentDatabase(@"c:\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;
          
   int RVal = DPSDK.Create(100); // Create output document
           
   DPSDK.SetDefaultPrinter(defPrinter);

   DPSDK = null;

   if (RVal != 0) {
      MessageBox.Show("Error. Create returns " + RVal);
   } else {
      MessageBox.Show("Done !!!");
   }

}



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