Solved

Old Query wizard dating young office manager

Posted on 1998-12-19
4
187 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
ID: 1971598
Try using subforms...
0
 
LVL 1

Author Comment

by:billinb
ID: 1971599
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
ID: 1971600
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
ID: 1971601
Thanks again TC
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

809 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