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 KennedyOP
@Reply 4 years ago
William KennedyOP
@Reply 4 years ago
William KennedyOP
@Reply 4 years ago
William KennedyOP
@Reply 4 years ago
William KennedyOP
@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 KennedyOP
@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 KennedyOP
@Reply 4 years ago
Juan can you be a little more specific on the Video training module and Tech Help video to watch.
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.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
TechHelp.