How Does It

How Does It All Work Out...

The ADA-program is delivered as an AddIn called "ADA.xla", the program file "ADA-ENGLISH.xls", the definition file called "QryTxt.INI" and the database example file called "CALIFORNIA.txt"

Please start your program ADA-ENGLISH.xls

  • Now you will be asked in your local language to create a backup of your program
  • Please click "Yes" and a backup file will be created on your hard drive "C:\ADA" with the program's name plus a date/time stamp which will make it easy for you to locate your latest backup

Pfeil32     Screenshot 1:   Reminder To Perform A Backup Of Your Program...

Then the worksheet "RESULTS" is shown with your Addin-ADA... being displayed on the Toolbar. Please click "ADA..." and the following menu is displayed which will be explained in detail now.

Pfeil32     Screenshot 2:   The ADA Menus...

The Main menu consist of the functions

  • Source File
  • Build Query...
  • Get Data and
  • About Browser

If you click on Source File, an additional Submenu will open which consists of the functions:

  • Set Source File...
  • Set File Layout Type
  • Show Current Source File Name... and
  • Show Current Layout Type...

Please click "Source File" and then "Set Source File...". You will get the Windows Explorer Menu, please select your folder, which contains your "ADA"-files, and click "CALIFORNIA"... Please click "Open" to finish your file selection...

Pfeil32     Screenshot 3:   The Source File And Set Source File Menus...

Please click "Source File" and then "Set File Layout Type"... You will get the File Layout Menu, which contains all pre-defined records... Please click the "Accept"-Button...

Pfeil32     Screenshot 4:   The Source File And Set File Layout Type Menu...

Here is the menu, which you will be working mostly with, the Parameter Lookup Menu...
Pfeil32     Screenshot 5:   Layout Of Your Main Lookup Definition Menu

Detailed Explanation Of Each Drop-Down Menu:

Pfeil32     Screenshot 6:   The Column Drop-Down Menu

The drop-down menu next to "Column" represents exactly your record definitions in the file "QryTxt.INI", you will find all of the defined titles starting with "DISTRICT" and ending with "TOTAL-NET"... You may choose any title from this list and include them into your file lookups...

The Operator Drop-Down Menu...

Pfeil32     Screenshot 7:   The OPERATOR Drop-Down Menu

Here you will find some of the functions of Microsoft Office Excel's Custom AutoFilter... They may be applied independently for each title selected from the "Column"; Drop-Down Menu....

The input box next to "Value" accepts your lookup criteria as alphanumerical values; please click "Add" to enter your criteria into the "Query" table...

The drop-down menu next to "Logical" shows to logical functions: "AND" - "OR" and allows you to combine logical AND/OR lookup definitions...

The "Add" Button next to it stores your selection and adds it to the already defined criteria in the "Query" table...

Now you may enter as many lookup criteria as you may wish, starting at the "Column" Drop-Down Menu where you may choose another title....

If you are ready to start the filter process, just click the "Accept" Button, please...
Now there will be a plausibility check performed by the program and if there is/are, any logical inconsistency found an Error Message would tell you so..
In such a case, please revise your queries...

The last steps will be to click "ADA..." and "Get Data" on the Toolbar and the filtering process starts...

If you may wish to delete all of your queries, just click the "Clear" Button, please...

If you like to abort the menu, just click the "Cancel" Button, please...