Calendar (6.2)

The Calendar tool is a floating scrollable calendar opened by selecting from the Main Menu Tools | Calendar from any place in the program.  A single date or a range of dates can be selected.  See GetCalendarDate for details on retrieving the date or range of dates selected in the floating calendar.

Store  This will cause the selected date to be stored in the clipboard, and if a view is active, the date will also be inserted into the date field of the view.  If the view is in Add mode, Record mode, or Browse mode, the starting date of the selection will be inserted into the field.  If the view is in Find mode and a range of dates is selected, the range of dates will be added to the query.  If a single date is selected and the user selected a relationship (<, >, <>, >=, etc.) prior to clicking the store button, the selected relationship and date will be added to the query.  If no relationship is selected, = will be used.

Options  Opens the Options section to allow the selection of the following calendar styles:

                 Day State -                 Selected days can be displayed in bold digits.  This style must be controlled through a macro using the CalendarFloating function.  When enabled here, it always shows the first 4 days of each month displayed in bold digits, as a demonstration of this style.

                 Multi Select -                 Multiple days can be selected.  the MaxDays parameter specifies the maximum days that can be selected.

                 No Today Circle - Removes the display of a red circle around today's date.

                 Week Numbers - Week numbers will display on the left side of the calendar.

All of the styles controlled by the Options button can be controlled by the CalendarFloating function.

A related function, CalendarModal, brings up a modal version of the calendar tool.

Find in Macros (6.2)

The Find In Macros tool can be opened by choosing main menu option Tools | Find in Macros from any point in the program.

Find in Macros is used to find all macros that contain a specific search text value.  Line numbers that contain this text are listed and the first line of text is displayed for each macro in which a match was found.  If Show Once is not checked, every line of code that contains the search text is displayed.

Show once                   If several lines of code in a macro contain the search text, only one line will appear in the list. If not checked, each occurrence is listed separately.

Local Macro                 The search will look through the local macros for the search string.

Global Macro                The search will look through the global macros for the search string.

Whole word                Looks for symbols and spaces on each side of the word to indicate whether or not the search string stands alone.

Match case The search will require an exact case match.

Comments                Includes comments in the search.  If not checked, no comments are searched for the search text.

If multiple records and one or more columns are selected, pressing Ctrl+E will bring up the Browse Editor dialog, and pressing Ctrl+D will bring up the Browse Delete dialog. In the Browse Editor, up to 6 fields can be changed simultaneously. The new values for these fields are inserted into each of the selected records. The Browse Delete dialog will allow you to delete all of the selected records.

This feature is implemented using a macro named "BROWSE EDITOR" for the edit process, and "BROWSE DELETE" for the delete process, as the defaults for every view in the database. These macros can be customized. Each view can have it's own custom browse editor macro or browse delete macro to meet any special requirements a view may have. See the View Settings: Macro tab. If a view does not have one defined, then the macro named "BROWSE EDITOR" or "BROWSE DELETE" is used.

NOTE: The default "BROWSE EDITOR" and "BROWSE DELETE" macros must initially be imported into the database from the ADBMSAMP sample database.