Computer Learning Zone CLZ Access Excel Word Windows

When I first looked back at the Earth, standing on the Moon, I cried.

-Alan Shepard
 
Home   Courses   TechHelp   Help   Contact   Merch   Join   Order   Logon   Forums   
 
Back to TechHelp    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Difficult Reports
William Kennedy 
    
4 years ago
I have a problem where many accounts with the exact same structure using common Combo Boxes used in their forms with unique Queries to generate unique reports are getting out of hand.  Just too many.   Is there a way to use combo boxes to select the various reports being generated in the report by Payee and or Category, and or Class.  It would significantly reduce the Queries and Reports.
William Kennedy OP  @Reply  
    
4 years ago

William Kennedy OP  @Reply  
    
4 years ago

William Kennedy OP  @Reply  
    
4 years ago

William Kennedy OP  @Reply  
    
4 years ago

William Kennedy OP  @Reply  
    
4 years ago

Juan C Rivera  @Reply  
            
4 years ago
Is there a way to use combo boxes to select the various reports being generated in the report by Payee and or Category, and or Class. --- YES

WOW cant tell how much you are into VBA, but look at select case with SQL.  Access Developer 2.
Richard has several tech help with select case.  One I recall was a report sorted by fields and parameters.  This might point you in the right direction to reduce some of the buttons that do the same function. Just off the top a few combo boxes to reduce the selections or radio buttons.  
Other  recomend the SQL seminar to get you into the VBA you will need to sort through this.  Or you can goto the developer section and pay someone to do it for you.  

last but most inportant BACK UP YOUR FILES.....  :)

William Kennedy OP  @Reply  
    
4 years ago
Still working in the expert 21 lessons range. Not yet into real VBA.  But will look your suggestion.  Thank you.
William Kennedy OP  @Reply  
    
4 years ago
Juan can you be a little more specific on the Video training module and Tech Help video to watch.
Richard Rost  @Reply  
          
4 years ago
William, I would suggest looking at any of the following:

The extended cut for Search Form 2.0
Access Developer 26
Access Search Seminar
Access SQL Seminar Part 1

I show you how to build a form to search records by altering the SQL statement using VBA. This way you can cut down on the number of different queries you have and code it all into statements. Much easier. You just have to learn a little SQL and a little VBA.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in TechHelp.
 

Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 8/7/2026 8:55:31 PM. PLT: 1s