Solved

Old Query wizard dating young office manager

Posted on 1998-12-19
4
183 Views
Last Modified: 2011-09-20
Anyone have an app that has tons of fields (160 flds, 3 tables, 30 fields in related table). I'm having difficulty finishing my application. Users are wanting to span several tables to query at run time.  I'm currently running/testing 20 query-by-forms each paired with a form that builds the filters. Start-up performance is bogging (I don't care about speed performance).  One Query wizard (qrywiz20) is user friendly but overworked (which the OM likes). Any thoughts, suggestions, recommendations?  Using Access 97.
0
Comment
Question by:billinb
  • 2
  • 2
4 Comments
 
LVL 3

Expert Comment

by:tcurtin
Comment Utility
Try using subforms...
0
 
LVL 1

Author Comment

by:billinb
Comment Utility
It would be difficult to query a subform.  I need to be able to filter on and print each of the 160 fields.  Consider an application that has 160 variables for each of 28 football teams. I need 16 forms with 10 fields each, as there is no correlation between quarterback efficiency and sacks per victory.
Quarterback efficiency is computed somewhere else - in another database. In order to peruse the various correlations, I need to be able to move thru all 160 fields in an efficient manor.
0
 
LVL 3

Accepted Solution

by:
tcurtin earned 160 total points
Comment Utility
I don' t know what the users want for data, but if you can drill down the 'typical' searches and store the querys you can build a form for each respective query. Use a table with a list of commonly selected items. Give the user a form with a listbox that reflects the list and a commandbutton that will bring up the appropriate form based on the selected value in the listbox. You could also create a form with a matching name for all of the listbox items.
I't just an idea...
0
 
LVL 1

Author Comment

by:billinb
Comment Utility
Thanks again TC
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now