Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Old Query wizard dating young office manager

Posted on 1998-12-19
4
Medium Priority
?
193 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 640 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
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 …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

578 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