At Your Survey
Author: Duane Hookom
At Your Survey (AYS) is a full featured application that allows users to create their own surveys by designing the questions and providing a lookup of possible responses. ATS uses a fairly normalized table structure so the same tables, forms, code, queries, and reports can be used for any number of surveys. There is a brief manual to help you get started as well as a sample survey with data.
Find out more here: http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=3
Showing posts with label Hookom. Show all posts
Showing posts with label Hookom. Show all posts
Tuesday, August 5, 2014
Wednesday, December 30, 2009
Featured Sample: Listbox with Multiselection used in Query
Listbox with Multiselection used in Query
by Duane Hookom
This sample demonstrates how a multiselect listbox can be used as the criteria in a query. A generic function is used to return a True or False depending on if a field value is selected in a listbox on a form.
There are two list boxes in the demo: one is bound to a numeric field and the other a text field.
While this solution works great for smaller tables, it may not be the best solution for tables with 1000s of records.
You can find the sample here: http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=17
.
by Duane Hookom
This sample demonstrates how a multiselect listbox can be used as the criteria in a query. A generic function is used to return a True or False depending on if a field value is selected in a listbox on a form.
There are two list boxes in the demo: one is bound to a numeric field and the other a text field.
While this solution works great for smaller tables, it may not be the best solution for tables with 1000s of records.
You can find the sample here: http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=17
.
Thursday, December 11, 2008
DH Query By Form
DH Query By Form
Author: Duane Hookom
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.
***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.
You can find this sample here: http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=12
DH Query By Form
Author: Duane Hookom
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.
***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.
You can find this sample here: http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=12
DH Query By Form
Subscribe to:
Posts (Atom)