Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > MS Access MVP Libraries > Hookom, Duane
  New Posts New Posts RSS Feed - DH Query By Form
  FAQ FAQ  Forum Search   Events   Register Register  Login Login


Please consider donating $1 per sample downloaded, (find out why here)

DH Query By Form

 Post Reply Post Reply
Author
Message
Duane Hookom View Drop Down
Microsoft MVP
Microsoft MVP


Joined: 20 Feb 2008
Location: Eau Claire, WI
Status: Offline
Points: 12
Post Options Post Options   Thanks (0) Thanks(0)   Quote Duane Hookom Quote  Post ReplyReply Direct Link To This Post Topic: DH Query By Form
    Posted: 23 Jun 2008 at 10:43pm
***NEW FEATURE***
An all Access mail merge feature was added Mar 6, 2004. This allows users to create simple mailmerge output without using a word processing program such as MS Word.
*****************
The DH QBF is a complete query by form applet that can be easily integrated into any existing Access application. Typically, the functionality provided by DH QBF can replace many "canned" reports. The developer imports several forms, tables, a query, and a report from the DH_QBF.mdb, creates some master queries, and deploys.

The developer creates one or more master queries that join tables, alias field names, create calculated columns, etc. The users can then select a master query (datasource) from a drop-down and then select up to 30 fields from the master query. Users can define sorting and criteria as well as grouping and totaling. All of this "design" information is stored in two tables for re-use.

The results of the queries are displayed in a datasheet subform contained in a main form. The main form has options to send/export the records to print, Word table, Word merge, Excel, HTML, CSV, Merge to Report, or a graph. Most formats allow he user to automatically open the target application. The Word merge process will open a new Word document and link to the merge fields.
 
Download Access 2000:uploads/4/DH_QBF.zip
--
Duane Hookom
Microsoft Access MVP
Eau Claire, WI
Back to Top
Sponsored Links


Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down