[Return to contents]
Last updated: 2 Dec 2000
The following was submitted by CRAVD01@aol.com and describes a method of getting around the maximum of 20 charts per .apr
Create a subdirectory called MENU. Under MENU create a database called
MENU_1. The database consists of only one field named JOB. Close MENU_1.
Create a database called CHARTS_1. The database consists of only one field
named JOB. Close CHARTS_1.
Open a third database called CHARTS_2. It also contains only one field named
JOB. Close CHARTS_2.
Now, open MENU_1 and join to CHARTS_1 and to CHARTS_2 on JOB. Then join to
your main database file and then to your other database files. Save the
Approach file and close.
Now, re-open CHARTS_1 and create a worksheet, etc. which will generate the
first set of 20 charts from the data in your main database.
Now, re-open CHARTS_2 and create a worksheet which will generate 20 more
charts from the data in your main database.
Now, re-open MENU_1 and create macros to open CHARTS_1 and its associated
charts and CHARTS_2 and its associated charts. If you design the MENU_1 menu
correctly, the user will not realize that you are jumping from CHARTS_1 to
CHARTS_2 to go to various charts.
You can continue to add CHARTS_3, CHARTS_4, etc. for an endless number of
The following was submitted by CRAVD01@aol.com, and describes a method for getting around the
The trick is to be sure that when you go from MENU_1 to CHARTS_1 that you
create a form with menu choices that will guide the user to the correct
chart. Make the button macros choose which file to go to.
If MENU_1, CHARTS_1, CHARTS_2 are in the same subdirectory, when you create
macro buttons, select the OPEN command and edit the location of the
CHARTS_1.apr as follows: change C:\MENU\CHARTS_1.apr to CHARTS_1.apr. This
allows Approach to operate correctly even if you change drives where the
programs are saved. If you leave the C:\MENU\.... in place, if you save to
D:\ drive and then try to use the macro buttons, the system will tell you
that it cannot find the C:\MENU\.... file.