MakeAccess2007 front and create word in WinForms DocIO

You can make Access 2007 a front end to create Word documents by creating COM Interop assemblies and then binding them to the Access 2007 form using macros.

Steps to generate a report from MS-Access:

• Create a .NET library to generate a report using DocIO.
• On the "Application" tab, click the "Assembly Information" and make the assembly COM-visible as "true."
• On the "Build" tab, check the "Register for COM interop" checkbox (towards the bottom: you may need to scroll down). Also, strong name the assembly by signing it.
• Build the application to generate the signed and interop assemblies.
• Open Access 2007. Now, go to the VBA editor (Tools->Macros).
• Include a reference to our newly created library. Select "References" on the Visual Basic Editor "Tools" menu.
• Add a new code module. You can do this with the Insert/Module command on the menu. Values can be bound dynamically with a Form to generate the report.
• Now, run the macro to generate a report.
• Please download the sample from the link below, which demonstrates the use of the Access 2007 database.
  Note:

  • Place the "Data" folder in [C:]. This part of the code is hard-coded.
  • Open the Northwind.accdb from the "FinalResult" folder.
  • Enable macros when prompted.
  • Go to Forms and select Form12.
  • Run it, and then click "Generate report" to generate the Word documents.
  • Browse through the data by navigating, and then click "Generate report" for generating reports based on OrderID.