Adhoc querying and reporting

By | 2002-06-01

Enables the user to create adhoc queries and reports from user-chosen access databases.
User needs to have Word97 to run the reports and references to word 8, ado 2 recordset and dao 3.51 object libraries.
Dragndrop fields/tables to choose selection fields and double-click field name for selection criteria.

Original Author: Colin McAllister

Assumptions

User needs to add the following references :
Microsoft Word 8.0 Object Library
Microsoft DAO 3.51 Ojbect Library
Microsoft ActiveX Data Objects 2.0 Library
Add the following components:
ADO Data control
CommonDialog control
Microsoft DataGrid Control (6.0)

Side Effects

none – except I’m too lazy to put much errorhandling in.

Attachments

FileUploadedSize
CODE_UPLOAD91.zip9/3/2020 3:45:00 PM8419
Author: dwirch

Derek Wirch is a seasoned IT professional with an impressive career dating back to 1986. He brings a wealth of knowledge and hands-on experience that is invaluable to those embarking on their journey in the tech industry.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.