Solved

Old Query wizard dating young office manager

Posted on 1998-12-19
4
186 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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Access 2016 - Labels prompt to print 4 32
Trying to open FORM in specific record !! 6 46
Dlookup MSACCESS 5 25
Filter a form 8 15
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…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
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 …
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…

832 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