custom viewfavourites within dat
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Custom view/favourites within a database

Custom view/favourites within a database

resolvedResolved · Low Priority · Version 2007

replyReply 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

For upcoming training course dates see: Pricing & availability

replyReply 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.

 

Please browse our web site to find out more about
microsoft database training and other Microsoft training courses.

Access tip:

Copy a Previous Record's Values to a New Record

If you often enter the same value in one field of a table, there are two methods to save re-typing the data.

1. Use Ctrl+' (apostrophe) to repeat the value input in the previous record.

2. Change the field's DefaultValue property in Design View to the most commonly used value.

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard