Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Too many views to keep track of - How can I simplify this.

Posted on 2005-03-27
Medium Priority
Last Modified: 2010-04-22
I have 40 different views (letters, worksheets, forms, reports). Paging to the right to find the one I need is slow. Can I organize the views into a menu and remove them from the view bar?
Question by:HenryWilfred

Assisted Solution

VolleyTom earned 400 total points
ID: 13646015
Yes. There are a number of ways of doing this. Probably the easiest to understand uses a combination of Macros and Forms.

Probably the easiest way to show you an example is to open the Artist & Music Collection Smartmaster and look at how the main menu is constructed. Each of the items has a "Switch to view" macro associated with it. Then each of the views has a "Main Menu (F10)" macro button on it to get you back to your main page.

Another way of doing this would include loading a drop down list with your views and having the selection activate the macro. Lots of ways to skin this cat.

Accepted Solution

suesloan earned 600 total points
ID: 13726986
In the "Status Bar" at the bottom of the Approach Window, the name of the current view is displayed on the right side. Click that name and a list of all the views that are not hidden is shown. Selecting a name from that list takes you to that view.

I do agree with VolleyTom that organizing your application using forms as menus is a good way to go. Buttons can have simple macros with a VIEW command to switch to the appropriate view instead of finding it by name.

Sue Sloan

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is an old article, please see an updated version of this article, located here: http://www.experts-exchange.com/articles/23619/Notes-8-5x-Windows-7-Notes-info-and-tips.html
  In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
Suggested Courses
Course of the Month13 days, 15 hours left to enroll

581 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question