98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Custom view/favourites within a database
Custom view/favourites within a database
Resolved · Low Priority · Version 2007
Thu 18 Aug 2011, 14:50Delegate angie said...
angie has attended:
Excel Introduction course
Excel Intermediate course
Access Introduction course
Access Intermediate course
Access Advanced course
Custom view/favourites within a database
If we have a very large Database of Tables (40+) and Queries (hundreds) and I want to keep seperate the 5 or 6 tables and queries that I use most often so that they display at at the top of the list, is this possible? All I can see is the Custom view and it lists all unassigned objects, can I do something here to assign my favourites or something?
Thank you
Mon 22 Aug 2011, 08:48Trainer Anthony said...
RE: Custom view/favourites within a database
Hi Angie, thanks for your query. This isn't available out of the box in Access but you can hide and unhide objects in the navigation pane:
http://www.techonthenet.com/access/database/hide_tables2007.php
If you record two macros hiding and unhiding the objects you want, you'll effectively create your own custom view option in Access!
Hope this helps,
Anthony
Sun 28 Aug 2011: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Related tablesWhen you have related tables such as Customers and their Orders, the Customer table is the Primary table. |
