Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
 
Home > TechHelp > Directory > Access > Report Listbox < On Dbl Click | Favorite Customers >
Back to Report Listbox    Comments List
MSysObjects Query Alternative Upload Images   Link   Email  
Alex Hedley 
Need to double check if the Description field is included but could you not use the MSysObjects Table as an alternative?

SELECT MSysObjects.Name AS Table_Name
FROM MSysObjects
WHERE MSysObjects.Type In -32764
ORDER BY MSysObjects.Name;
Richard Rost 
Yep. As with anything in Access there are always multiple ways to do things. That's another method. And no, I don't think you can get to the Description property that way, so you're still going to have to loop.
Richard Rost 
Honestly I still prefer Method 1 (with the table) that I show in the free video. I like being in control of the list with a table. You can add a custom sort order and everything.
Alex Hedley 
The sort order and having the descriptions in one place would make it easier, having to remember to set properties on each object could be easily forgotten, then having a way to only show the ones you want and not all is very handy.
Elaine Heltman 
I vote for Method 1 - easy to set up and maintain. That said, I learned a lot from working with Method 2.
Garry Smith 
I use the first method for reports among other things.
I have a parameter form with two text boxes for beginDate and endDate that I can use in the report if those boxes are checked in the table along with a textbox that will display a suggested title along with the dates the user supplied for the report and allows the user to change the wording in the title to their liking. This parameter form shows/hides the needed textboxes according to the items checked in the table by using a DLookup when the user selects a report. This method also allows multiple reports with the same dates needed to run without the user's need to reenter each time.
Along with the date textboxes number or currency fields have been used to filter the reports as long as the table has the corresponding boxes checked.
I also have checkboxes in the table which allows me

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

 
 
 

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 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 3/28/2024 7:33:43 AM. PLT: 0s