@ 9.769,3.167 GET qp PICTURE "@&N" FROM query SIZE 6.923,69.800 DEFAULT 1 FONT "MS Sans Serif", 8 VALID _qc90i8s10() DISABLE
MS Sans Serif
MS Sans Serif
MS Sans Serif
@*HN \!Browse
Browse the results of the criteria list
MS Sans Serif
@*VN Reset
Clear the criteria list
MS Sans Serif
@*VN \?Close
Close the locate window
MS Sans Serif
@*HN Delete
Remove the current item from the list
MS Sans Serif
@*BHN F
bmps\uparrow.bmp
BMP|ICO
Where is uparrow?
Move selected item up one row
MS Sans Serif
@*BHN F
bmps\dnarrow.bmp
BMP|ICO
Where is dnarrow?
Move selected item down one row
MS Sans Serif
@*HN OR
Add an OR condition to the list
MS Sans Serif
3333336@
Criteria
MS Sans Serif
locate
CURRAREA
TALKSTAT
COMPSTAT
LOCATE
SOUGHT
SEEKTYPE
QUERY
FIELDNAME
SETTAGS
_QC90I8R81AD
_QC90I8RCF_QC90I8S4X_QC90I8S9M_QC90I8SDSRS
_QC90I8SQ8QT
_QC90I8SUYD1
_QC90I8SYID2
_QC90I8T4CD3
_QC90I8TAHD4
_QC90I8TFY_QC90I8U1F
KSTAT
QUERY
SOUGHT
SETACTION
typ = TYPE("&x")
QUERY
FIELDNAME
SOUGHT
NOTAG
QUERY
SOUGHT
FIELDNAME
ONTAG
NOBRACK
Record#
ONTAG
FIELDNAME
LDNAME
DNAME
LDNAME
Can't have single quote in value
SOUGHT
query list is full
typ = TYPE("&x")
Missing value
Numeric field; Quotes are not allowed
typ2 = TYPE("&y")
Numeric field; A number is expected
NOTAG
FIELDNAME
SOUGHT
BRACKETS
QUERY
SETACTION
ELDNAME
SETACTION
Record#
TACTION
ACTION
SETTAGS
QRESET
9,999,999c
Records
) OR (
AND
OR ()
Expression too long
COUNT FOR &x TO cnt
9,999,999c
Records,
999.99c
Secs.
BROWSE NOMODIFY NOAPPEND FOR &x
ACTION
TTAGS
STIME
ETIME
ELDNAME
EMPTY
QUERY
EDITQUERY
QUERY
SOUGHT
SETACTION
QUERY
SETACTION
QUERY
SETACTION
QUERY
SETACTION
QUERY
SETACTION
Record#
CURRWIND
RWIND
SETACTION
QRESET
NOBRACK
SETTAGS
ONTAG
NOTAG
EDITQUERY
_QC90I8R81
_QC90I8RCF
BRACKETS
_QC90I8S10
_QC90I8S4X
_QC90I8S9M
_QC90I8SDS
_QC90I8SQ8
_QC90I8SUY
_QC90I8SYI
_QC90I8T4C
_QC90I8TAH
_QC90I8TFY
_QC90I8U1F
TALKz
COMPATIBLEz
credcard
dbfs\credcard.dbf
Where is credcard?
carduser
dbfs\carduser.dbf
Where is carduser?
personal
dbfs\personal.dbf
Where is personal?
family
FAMILY
FAMILY.PJX
FAMILY
FAMILY.SCX
FAMILY
FAMILY.MNX
FAMILY
FAMILY.PRG
FAMILY
FAMILY.QPR
MS Sans Serif
Family / Friends
controls
CONTROLS
CONTROLS.PJX
CONTROLS
CONTROLS.SCX
CONTROLS
CONTROLS.MNX
CONTROLS
CONTROLS.PRG
CONTROLS
CONTROLS.QPR
MS Sans Serif
Family and Friends Organizer
family
MS Sans Serif
Address:
MS Sans Serif
Phone Number:
MS Sans Serif
Notes:
MS Sans Serif
Birth Date:
MS Sans Serif
Last Name:
MS Sans Serif
First Name:
MS Sans Serif
MS Sans Serif
MS Sans Serif
Initial:
MS Sans Serif
Spouse:
MS Sans Serif
MS Sans Serif
Enter Last Name
MS Sans Serif
Enter First Name
MS Sans Serif
Enter Middle Initial
MS Sans Serif
@KBZ 999
Enter Area Code
MS Sans Serif
@KBZ 999-9999
Enter Phone Number
MS Sans Serif
Enter Street Address
MS Sans Serif
Enter City
MS Sans Serif
ffffff
Enter State
MS Sans Serif
Enter Zip Code
MS Sans Serif
Enter Spouse's Name
MS Sans Serif
Enter Date of Birth
MS Sans Serif
Ctrl-TAB exits Notes
MS Sans Serif
@*CB F
bmps\sendcard.bmp
BMP|ICO
Where is sendcard?
Send Holiday Cards to this Individual
MS Sans Serif
@*CB F
bmps\dietary.bmp
BMP|ICO
Where is dietary?
Individual has Special Dietary Needs
MS Sans Serif
@*CB F
bmps\exchange.bmp
BMP|ICO
Where is exchange?
Exchange Gifts with this Individual
MS Sans Serif
@*VN \<Help
MS Sans Serif
@*HN Ne\<w
MS Sans Serif
@*VN \<Save
MS Sans Serif
@*HN \<Cancel
DELETED
MS Sans Serif
ffffff&@
Special
MS Sans Serif
Diet
MS Sans Serif
MS Sans Serif
Cards
MS Sans Serif
Exchange
MS Sans Serif
Gifts
MS Sans Serif
ffffff
controls
MS Sans Serif
@*BVN F
bmps\top.bmp
BMP|ICO
Where is top?
bmps\prior.bmp
BMP|ICO
Where is prior?
bmps\next.bmp
BMP|ICO
Where is next?
bmps\bottom.bmp
BMP|ICO
Where is bottom?
MS Sans Serif
@*BHN F
bmps\locate.bmp
BMP|ICO
Where is locate?
MS Sans Serif
@*HN Exit
controls
family
CURRAREA
TALKSTAT
COMPSTAT
CREDCARD
CARDUSER
PERSONAL
FAMILY
CONTROLS
ADDING
EDITING
SDSAY1
SDSAY2
CHOICE
TOPREC
BOTTOMREC
SAVERECNO
QUITTING
LASTNAME
_QC90I90SZFIRSTNAME
_QC90I90X0MIDINITIAL_QC90I9116AREACODE
_QC90I9150PHONE
_QC90I9191ADDRESS
_QC90I91D0CITY
_QC90I91H3STATE
_QC90I91KWZIP
_QC90I91VVSPOUSENAME_QC90I91ZJBIRTHDATE
_QC90I923LNOTES
_QC90I927JHOLIDAYS
_QC90I92CHDIET
_QC90I92GZGIFTS
_QC90I92LJGETHELP
_QC90I92PRNEWRECORD
_QC90I92THSAVERECORD_QC90I9300_QC90I933ECANCEL
_QC90I939U_QC90I93RLLCHOICE
_QC90I9420ECHOICE
_QC90I945M_QC90I93MH_QC90I93MM_QC90I949N
Please confirm changes
EDITING
NEWRECORD
SAVERECORDCANCEL
CONTROLS
REPORTS
LASTNAME
PERSONAL
SHOWSAVE
FIRSTNAME
PERSONAL
SHOWSAVE
MIDINITIALPERSONAL
SHOWSAVE
AREACODE
LPERSONAL
SHOWSAVE
PHONE
LPERSONAL
SHOWSAVE
ADDRESS
LPERSONAL
SHOWSAVE
LPERSONAL
SHOWSAVE
states
@ 0,0 GET m.choice FROM staflds PICTURE '@&T' RANGE 2 SIZE 6,20 DEFAULT 1 VALID statvalid() COLOR SCHEME 1
STAFLDS
LCHOICE
SAVEAREA
LCOUNT
LASTKEY
LOCATEDB
LIST
STATE
PERSONAL
SHOWSAVE
CITY
STATE
LSTAFLDS
CHOICE
LPERSONAL
SHOWSAVE
SPOUSENAMEPERSONAL
SHOWSAVE
BIRTHDATE
PERSONAL
SHOWSAVE
NOTES
PERSONAL
SHOWSAVE
HOLIDAYS
PERSONAL
SHOWSAVE
PERSONAL
SHOWSAVE
GIFTS
PERSONAL
SHOWSAVE
Family / Friends
ADDING
NEWRECORD
SAVERECORDCANCEL
LASTNAME
CONTROLS
REPORTS
Enter last name
LASTNAME
Record has been saved
ADDING
EDITING
NEWRECORD
SAVERECORDCANCEL
CHOICE
LCHOICE
ECHOICE
REPORTS
EDITING
ADDING
NEWRECORD
SAVERECORDCANCEL
CHOICE
LCHOICE
ECHOICE
REPORTS
CHOICE
TOPREC
BOTTOMREC
browser.spr
BROWSER
IDLEQUIT
QUITTING
REPORTS
Please confirm changes
EDITING
FAMILY
DELETED
MS Sans Serif
ffffff&@
Special
MS Sans Serif
Diet
MS Sans Serif
MS Sans Serif
Cards
MS Sans Serif
Exchange
MS Sans Serif
Gifts
MS Sans Serif
ffffff
CURRWIND
ADDING
EDITING
FAMILY
HOLIDAYS
GIFTS
SAVERECNO
TOPREC
BOTTOMREC
CHOICE
SHOWSAVE
_QC90I90SZ
_QC90I90X0
_QC90I9116
_QC90I9150
_QC90I9191
_QC90I91D0
_QC90I91H3
_QC90I91KW
STATVALID
_QC90I91VV
_QC90I91ZJ
_QC90I923L
_QC90I927J
_QC90I92CH
_QC90I92GZ
_QC90I92LJ
_QC90I92PR
_QC90I92TH
_QC90I9300
_QC90I933E
_QC90I939U
_QC90I93RL
_QC90I9420
_QC90I945M
_QC90I93MH
_QC90I93MM
_QC90I949N
d T 4 D t D A
TALKz
COMPATIBLEz
labels
LABELS
LABELS.PJX
LABELS
LABELS.SCX
LABELS
LABELS.MNX
LABELS
LABELS.PRG
LABELS
LABELS.QPR
MS Sans Serif
Preview
labels
No Labels for this Module
labels
Label
MS Sans Serif
@ 2.615,3.167 GET m.label PICTURE "@&N" FROM labs RANGE 2 SIZE 6.923,41.400 DEFAULT 1 FONT "MS Sans Serif", 8 VALID _qbm0s22t4()
MS Sans Serif
@*RVN Pre\<view;\<To File;To \<Print
MS Sans Serif
ffffff7@
MS Sans Serif
@*VN \!\<OK;\<Modify;\?\<Cancel
MS Sans Serif
@*VN \<Help
MS Sans Serif
@*C \<For...
MS Sans Serif
@*C \<While...
Description
MS Sans Serif
labels
CURRAREA
TALKSTAT
COMPSTAT
LABELS
OUTPUT
FILENAME
CHOICE
SAVEREC
LABEL
SAVEAREA
COUNT
ANYLABELS
FOREXPR
WHILEEXPR
WHILE
LOCATEDB
MODTYPE
MODULE
REPORTNAMECONTENTS
_QBM0S22XQ_QBM0S234OGETHELP
_QBM0S23H8_QBM0S23LO_QBM0S23Q6_QBM0S23VSl
Label not found
MODIFY LABEL &labe
LABEL
Please select a label
To File
Output file:
LABENAME
LABEL
OUTPUT
FILENAME
Cancel
Please select a label
Label not found
WHILE
WHILE
To File
Processing labels...
LABEL FORM &labe &forexpr &whileexpr TO FILE &to ENVIRONMENT NOCONSOLE
Preview
LABEL FORM &labe &forexpr &whileexpr PREVIEW ENVIRONMENT
To Print
Printing labels...
LABEL FORM &labe &forexpr &whileexpr TO PRINTER ENVIRONMENT NOCONSOLE
alert.spr
Printer not ready
Modify
Label not found
MODIFY LABEL &labe
Cancel
WHILE
WHILE
CHOICE
LABEL
FOREXPR
WHILEEXPR
OUTPUT
FILENAME
ALERT
Label Dialog
Enter FOR expression:
Enter FOR expression:
FOREXPR
Enter WHILE expression:
Enter WHILE expression:
WHILEEXPR
WHILE
clients
MODULE
MEMSIZE
CHOICE
_QBM0S22T4
_QBM0S22XQ
_QBM0S234O
_QBM0S23H8
_QBM0S23LO
_QBM0S23Q6
_QBM0S23VS
TALKz
COMPATIBLEz
letters
LETTERS
LETTERS.PJX
LETTERS
LETTERS.SCX
LETTERS
LETTERS.MNX
LETTERS
LETTERS.PRG
LETTERS
LETTERS.QPR
MS Sans Serif
letters
letters
Letter
MS Sans Serif
@ 1.615,3.000 GET m.lett PICTURE "@&N" POPUP _qbm0s25zr SIZE 6.923,40.000 DEFAULT " " FONT "MS Sans Serif", 8 STYLE "" WHEN _qbm0s267d() VALID _qbm0s26aj()
MS Sans Serif
@*VN \!\<See Letter;\<Print;\?\<Cancel
MS Sans Serif
@*RVN Cu\<rrent Record;\<All Records
MS Sans Serif
@*C \<For...
MS Sans Serif
@*C \<While...
MS Sans Serif
@*VN \<Help
letters
letters
CURRAREA
ITALKSTAT
COMPSTAT
LETTERS
ECHOICE
utFOREXPR
n WHILEEXPR
SAVEAREA
LOCATEDB
CONTENTS
_QBM0S25ZR_QBM0S26EEPRNSCOPE
_QBM0S26K4FOR
_QBM0S26OKWHILE
_QBM0S26UKGETHELP
_QBM0S270FG
<<letters.Letter>>
WHILE
SCAN &forexpr &whileexpr
<<letters.Letter>>
RECNO
IPRNSCOPE
FOREXPR
WHILEEXPR
SAVEAREA
LETTERS
WIDTH
IHIGHT
DISPLAY
LETTER
LETTERS
IMODULE
CHOICE
SHOWLETTER
See Letter
Print
Printing...
alert.spr
Printer not ready
Cancel
CHOICE
TERSHOWLETTERPRINTLETTEALERT
PRNSCOPE
LETTERWHILE
Enter FOR expression:
Enter FOR expression:
RSAVEAREA
RFOREXPR
Enter WHILE expression:
Enter WHILE expression:
RSAVEAREA
RWHILEEXPR
WHILE
Letters Dialog
PRINTLETTE
SHOWLETTER
_QBM0S267D
_QBM0S26AJ
_QBM0S26EE
_QBM0S26K4
_QBM0S26OK
_QBM0S26UK
_QBM0S270F
TOPIC
DETAILS
Account Manager 1
Add/Modify Card Users 32
Balance 59
Calculator 86
Calendar/Diary 96
Client Manager 111
Controls 151
Conversions 165
Credit Card Manager 186
Family / Friends 230
Find 258
Goto 281
Label Dialog 299
Letters Dialog 319
Locate 337
Menu System 411
Money Transactions 468
Organizer: General Help 498
Puzzle 520
Report Dialog 527
Restaurant Manager 553
Account Manager
The Account Manager module allows you to display and edit information about your accounts.
Information about a specific account is displayed in the Account Manager window. A control panel allows you to move through the database or bring forward a dialog to locate records that meet specified criteria.
In addition, a Browse window is displayed. The Details Browse window displays information about specific transactions.
Moving Through the Database
In the control panel, choose Next, Prior, Top or Bottom to move through the database. Choose the Locate push button to locate records that meet specified criteria.
Editing Data
To edit a record in the Account Manager window, position the cursor on the a field and enter the desired changes.
Adding a New Record
Choose the New push button to add a new record. An empty Account Manager window is displayed.
Choose the account type from the Type popup, then enter the desired information in the Account Manager window.
Saving/Cancelling Changes
When you make changes or add a new record, you can choose the Save push button to save the information. Choose the Cancel push button to abandon all changes to the record.
Balance
The Balance push button displays the Balance dialog so you can update the current balance. For more information, see the Balance topic.
Menu System
The Account Manager uses the standard menu system used for most ORGANIZER modules. For more information, see the Menu System topic in online Help.
See Also: Organizer: General Help, Locate, Menu System, Report Dialog, Label Dialog, Balance
Add/Modify Card Users
This dialog allows you to edit the users for a specific credit card and add new users to the card users database. The names in the Authorized Users list in this dialog appear in the Authorized Users list in the Credit Card Manager window.
Adding an Authorized User
Double-click on the name you wish to add in the Selection list or select the name you wish to add and choose Move. The selected name appears in the Authorized users list. Duplicate entries are not permitted.
Removing an Authorized User
Double-click on the name you wish to remove in the Authorized Users list or select the name you wish to remove and choose Remove. The selected name is removed from the Authorized users list.
Choose Remove All to remove all names from the Authorized Users list.
Adding a New User
Choose New Name to add a new name to the Selection List.
Enter a last name in the Last text box and a first name in the First text box. Press Enter. The new name appears in the Authorized Users list. Repeat the process to add more new names.
When you choose OK, the new names appear in the Authorized Users list in the Credit Card Manager window. When you choose the Save push button, the new names are saved in the card users database. They will appear in the Selection list the next time the Add/Modify Card Users dialog is displayed.
See Also: Organizer: General Help, Credit Card Manager
Balance
This dialog allows you to update a balance on a single record or perform batch processing to update the balance of all records.
To update the balance for the current record:
Choose the Current Record Radio button.
Choose the desired month in the popup in this dialog, then choose OK.
The update operation is performed from the time of the last update to the month selected in the Balance dialog.
The balance is displayed in the upper right corner of the monitor. That balance is then added to the current balance for the record.
Choose the Save push button save this amount as the current balance. Choose the Cancel push button to cancel the operation and restore the previous balance.
To update the balance of all records:
Choose the All Records radio button.
Choose the desired month in the popup in this dialog, then choose OK.
The update operation is performed from the time of the last update to the month selected in the Balance dialog.
When you update all records, the new balance is automatically added to the current balance for every record in the database. This balance is then automatically saved.
There is no way to cancel the operation and restore the previous balance once this batch operation begins.
If you have previously updated the balance for the current month, a message is displayed stating that the account is balanced as of the last day of the month.
See Also: Organizer: General Help, Account Manager, Credit Card Manager, Client Manager
Calculator
When you choose Calculator from the System menu popup, the Calculator desk accessory appears. This calculator is used like a standard pocket calculator.
Calculations can be performed using the keyboard or the mouse.
With the keyboard, you can type the equation as it would be written. Most Calculator keys have the same keyboard equivalents, with the following exceptions:
Key Equivalent
R MR
N
A M+
Z MC
S M-
Calendar/Diary
The Calendar panel appears with the current month displayed and today's date selected.
Changing Current Date
Change selected day:
Use arrow keys or click on desired day.
Change Month
Press PgUp/PgDn or choose <-M or M-> push button.
Change Year
Press Shift+PgUp/Shift+PgDn or choose <-Y or Y-> push button.
You can select today's date by pressing T on the keyboard or by choosing the Today push button.
The Diary menu popup contains options that correspond to all of these actions.
You can have a diary entry for each day. Activate the Diary panel by pressing Tab or clicking on the panel with the mouse. The cursor flashes in the Diary panel, indicating that it is active.
Choose Delete... from the Diary menu popup to display the Delete Diary dialog.
Client Manager
The Client Manager allows you to display and edit information about clients. Information about a specific client is displayed in the Client Manager window. A control panel allows you to move through the database or bring forward a dialog to locate records that meet specified criteria.
In addition, two Browse windows are displayed. The Client List Browse window displays all clients in the database. The Account Details Browse window displays transaction information for the displayed client.
Moving Through the Database
In the control panel, choose Next, Prior, Top or Bottom to move through the database. Choose the Locate push button to locate records that meet specified criteria.
Alternately, you can scroll through the records in the Client List Browse window. When you position the record pointer on a record in the Client List Browse window, corresponding data is displayed in the Client Manager window and in the Account Details window.
Editing Data
You can edit data in the Client Manager window. The Client List and Account Details Browse windows are for display purposes only and cannot be edited.
To edit a record, position the cursor on the a field and enter the desired changes.
To change the Cuisine preference, choose the desired option from the Cuisine Preference popup.
To change the Client Type, choose the desired radio button.
Adding a New Record
Choose the New push button to add a new record. An empty Client Manager window is displayed. Enter the desired information in the Client Manager window.
Saving/Cancelling Changes
When you make changes or add a new record, you can choose the Save push button to save the information. Choose the Cancel push button to abandon all changes to the record.
Balance
The Balance push button displays the Balance dialog so you can update the current balance. For more information, see the Balance topic.
Menu System
The Client Manager uses the standard menu system used for most ORGANIZER modules. For information, see the Menu System topic.
See Also: Organizer: General Help, Report Dialog, Label Dialog, Letters Dialog, Locate, Controls, Menu System, Balance
Control Panel
The control panel is a utility screen that is used throughout the ORGANIZER application. The push buttons in this window perform the following actions:
Next Positions the pointer on the next record.
Prior Positions the pointer on the previous record.
Top Positions the pointer on the first record.
Bottom Positions the pointer on the last record.
Locate Brings forward the Locate dialog allowing you to locate records that meet specific criteria.
Push buttons in the control panel are enabled and disabled depending on the position of the record pointer in the database.
See Also: Organizer: General Help, Locate, Menu System
Conversions
The Conversions module acts like a FoxPro desk accessory and allows you to convert from one unit of measurement to another.
To perform conversions:
Choose the desired Measurement Type radio button. Options on the From and To popups reflect units of the selected type.
Choose the unit of measurement from the From popup and Enter the number you would like to convert from in the From text box.
Press Tab or click in the To text box. The number is converted to the unit of measurement displayed in the To popup.
To convert to a different unit of measurement, choose the desired option from the To popup.
This process also works in reverse. You can enter a number in the To text box and choose a unit of measurement on the From popup to perform a conversion.
The Menu System
The Conversions module adds a Conversions menu pad to the FoxPro system menu. The Conversions menu popup contains options with control key shortcuts for the radio buttons in the Conversions window.
See Also: Organizer: General Help, Menu System
Credit Card Manager
The Credit Card Manager allows you to display and edit information about your credit cards. Information about a specific credit card is displayed in the Credit Card Manager window. A control panel allows you to move through the database or bring forward a dialog to locate records that meet specified criteria.
Moving Through the Database
In the control panel, choose Next, Prior, Top or Bottom to move through the database. Choose the Locate push button to locate records that meet specified criteria.
Editing Data
You can edit data in the Credit Card Manager window.
To edit a record, position the cursor on the a field and enter the desired changes.
To change names in the Authorized Users list, choose the Edit users push button. The Add/Modify Users dialog appears.
Adding a New Record
Choose the New push button to add a new record. An empty Credit Card Manager window is displayed.
You must enter a card number in the Card ID text box before you are permitted to enter data in any other field.
Enter the desired information in the remaining fields in the Credit Card Manager window.
Saving/Cancelling Changes
When you make changes or add a new record, you can choose the Save push button to save the information. Choose the Cancel push button to abandon all changes to the record.
View Charges
Choose the View charges push button to view all charges for the displayed credit card.
A Browse window appears. Charges are displayed in descending date order. This Browse window is for display purposes only. Records cannot be edited. To edit charges, choose the Transactions option on the Money Manager submenu.
Balance
The Balance push button displays the Balance dialog so you can update the current balance. For more information, see the Balance topic.
The Menu System
The menu system displayed with the Credit Card module is the standard ORGANIZER menu system. A Card Info menu pad is appended to this menu system.
The Card Info menu popup contains the following options:
View Charges Displays Browse window with all charges for the current credit card.
View Payments Displays Browse window with all payments for the current credit card.
View Users Displays Browse window with names of users for all credit cards.
See Also: Organizer: General Help, Controls, Add/Modify Card Users, Locate, Balance, Menu System, Report Dialog, Label Dialog
Family / Friends
The Family/Friends module allows you to display and edit information about your family and friends. Information about a specific person is displayed in the Family/Friends Manager window. A control panel allows you to move through the database or bring forward a dialog to locate records that meet specified criteria.
Moving Through the Database
In the control panel, choose Next, Prior, Top or Bottom to move through the database. Choose the Locate push button to locate records that meet specified criteria.
Editing Data
You can edit data in the Family/Friends Manager window.
To edit a record, position the cursor on the a field and enter the desired changes.
Three check box options -- Send Holiday Cards, Special Diet Needs and Exchange Gifts -- allow you to specify attributes for a record.
Adding a New Record
Choose the New push button to add a new record. An empty Family/Friends window is displayed. Enter the desired information in the Family/Friends window.
Saving/Cancelling Changes
When you make changes or add a new record, you can choose the Save push button to save the information. Choose the Cancel push button to abandon all changes to the record.
Menu System
The Family and Friends Manager uses the standard menu system used for most ORGANIZER modules. For information, see the Menu System topic.
See Also: Organizer: General Help, Report Dialog, Label Dialog, Letters Dialog, Locate, Controls, Menu System
Find
Before you choose Find... to display the Find dialog so you can specify a word or phrase to Look For, position the cursor in the Browse window or text edit region where you want the search to begin.
Type the text you wish to locate in the Look For text box and type the text (if any) that will replace the located text in the Replace With text box.
In the Find dialog you can use the check boxes to ignore upper and lower case, to match whole words only (and not just characters), and/or to continue (wrap) to search from the beginning of the file when the end is reached.
To search for Enter, Tab, Backslash and new line (line feed) characters, use the c-language convention to represent them when you type them in the text boxes in the Find dialog:
\r - to search for an Enter.
\t - to search for a Tab.
\\ - to search for a backslash.
\n - to search for a new line (line feed).
When FoxPro finds a match, it highlights the matching text for you to see. You can edit the text using FoxPro editing techniques or Edit menu options.
When Find... is used to search for text in a Browse window, no Replace With text box appears in the Find dialog.
See Also: Organizer: General Help, Client Manager, Credit Card Manager,
Family / Friends
Goto
This dialog allows you to display a record that meets certain criteria. You can search for a record by specifying a value or an expression.
To specify a value:
Choose the Value radio button.
Choose database field from the Field popup.
Enter a value in the Field Value text box. This is a case-sensitive search, so be sure the value you enters matches the value for which you are searching.
If you are searching a for a value in a logical field (usually a check box option), you must enter .T. or .F. in the Field Value text box.
To specify an expression:
Choose the Expression radio button.
Enter the expression in the Expression text box, or choose the Expression push button to bring forward the Expression Builder.
When you have defined a value or expression, choose the Goto push button. The first record that meets the specified criteria is displayed.
See Also: Organizer: General Help, Money Transactions
Label
This dialog allows you to run labels.
To run a label, select the desired label in the Label list.
For and While
The For and While check boxes in the lower right corner of this dialog bring forward the Expression Builder. You may set a For and/or While condition for the label.
Output
These radio buttons allow you to specify where to output the label and perform the following actions:
Preview Displays the label in a page preview window on the monitor.
To File Brings forward a dialog in which you can specify the name and location of a text file.
To Print Directs output to the current printer.
When the desired options are selected, choose OK to run the label.
Modifying a Label
To modify a Label, select the desired label in the Label list and choose the Modify push button, or double-click on the label name in the list. The label definition is displayed in a Label Design window so you can make adjustments.
See Also: Organizer: General Help
Letters
This option allows you to perform mail merge operations and is not available in runtime applications.
To view a mail merge letter, select the desired letter from the Letters list and choose the See Letter push button, or double-click on the letter name in the list. The letter is displayed but cannot be edited.
To print a letter, select the desired letter in the Letters list.
The radio buttons at the bottom of this dialog perform the following actions:
Current
Record Prints a letter for the current record.
Records Prints letters for all records.
When this option is selected, the For and While check boxes are enabled. Choosing these check boxes bring forward the Expression Builder allowing you to specify a For and/or While condition.
When you have made the desired selections, choose the Print push button.
See Also: Organizer: General Help
Locate
This dialog allows you to locate and browse records that meet specified criteria.
To specify conditions:
1. Choose a database from the Database popup. All Open databases are displayed in this popup. The Field popup in the lower portion of this dialog reflects the fields in the database displayed in the Database popup.
2. Choose a field from the Field popup. Fields marked with a
are indexed and, therefore, the expressions created with these fields are optimizable. Fields that are not indexed can be used in expressions, but they will not be optimized.
If you choose a logical field, the operator popup and criteria text box are disabled. It is assumed that the logical field = true.
3. Choose an operator from the operator popup. The operators and the actions they perform are:
= Checks if one field matches the criteria.
Example: Lastname = Smith
All records with a lastname that begins with Smith are located (e.g., Smith, Smithson, Smithburg).
<> Checks if field is not equal to the specified criteria.
Example: Rating <> II
All records except those with a rating of II are located.
< Checks if the value of a field is less than the specified criteria.
Example: Rating < III
All records with ratings of I and II are located.
> Checks if the value of a field is more than the specified criteria.
Example: Rating > II
All records with ratings of III or greater are located.
<= Checks if the value of a field is less than or equal to the specified criteria.
>= Checks if the value of a field is more than or equal to the specified criteria.
== Checks if the field exactly matches the specified criteria.
Example: Lastname == Smith
All records with a lastname field that contains only Smith are located.
IN Checks if a field is in a given set of values.
Example: State = CA,MI,OH
All records with CA, MI or OH in the state field are located.
4. Enter the desired criteria in the text box to the right of the operator popup. This is a case-sensitive search, so the text must match the case for which it is searching (e.g., smith will not locate Smith).
5. Choose the Add push button. The expression is displayed in the list above.
Repeat the process to add another expression. If you add expressions without grouping (grouping is discussed later), the expressions are "ANDed" together.
Example 1: Cuisine = American
State = California
Records with American cuisine in California are located.
Example 2: State = CA
State = OH
No records are located because no restaurants exist with a state of CA AND OH.
Grouping Expressions
When expressions are displayed in the Expression list, the push buttons below the expression list are enabled. To group expressions, choose the Group push button. A double line appears in the Expression list.
When you group expressions, the expression are ORed together.
Example:
State = CA
State = OH
Records with a state of OH or a state of CA are located.
When more than one expression is displayed in the Expression list, the up arrow and down arrow are enabled. You can move expressions and grouping bars up and down in the list with these push buttons. Select the expression or grouping bar in the expression list and choose the desired push button.
Deleting Expressions
To delete an expression from the Expression list, select the expression and choose Delete.
To clear the Expression list, choose Reset at the bottom of the dialog.
Order
To specify the order you would like the records displayed in the Browse window, choose the order from the Order popup. All indexed fields are displayed on this popup.
Browsing
When you have created the desired expressions and chosen the desired order, choose the Browse push button.
A Browse window is displayed with the located records. Choosing the Browse push button without defining any expression will display a Browse window will all records in the database.
Creating New Search Criteria
Press Escape or click on the close box in the Browse window to return to the Locate dialog. You can modify the search criteria or clear the expression list and start anew.
Choose Quit to exit the Locate dialog.
See Also: Organizer: General Help, Client Manager, Family / Friends, Credit Card Manager, Money Transactions, Account Manager
Menu System
A common menu system is displayed with most modules of the ORGANIZER. Occasionally, pads that correspond to a particular module are appended to this menu system. Many options in this menu system have control key shortcuts.
The common menu system contains the following pads and options:
System Menu
This menu contains options allowing you to access help, activate desk accessories, customize your display and exit the current ORGANIZER module.
Help Brings forward the Organizer Help window.
Calculator Brings forward the calculator.
Calendar/
Diary Brings forward the Calendar/Diary.
Puzzle Brings forward the puzzle.
Conversions Brings forward the Conversions window. This option is not available in the Client Manager module.
Environment Activates a submenu with the following options:
Clock Toggles the display of the clock.
Extended
Video Toggles your display between VGA25 and VGA50 (if available).
Sticky
Menus Toggle option that allows you to have menus remain displayed when you release the mouse button.
Status
Bar Toggles the display of the status bar.
OK Exits the current module and returns to FoxPro
Edit Menu
This menu contains options allowing you to perform a variety of text editing operations.
Undo Undoes previous text editing actions in fields and edit regions.
Redo Reverses undone text editing actions in fields and edit regions.
Cut,
Copy,
Paste Allows you to cut, copy and paste text between fields and records.
Clear Removes all selected text from field or edit region.
Select
All Selects all text in field or edit region.
Find This option is enabled when the cursor is position in a Browse window or edit region and allows you to locate specific text in the database.
Find
Again Repeats a previous Find operation.
Record Menu
This menu popup contains options and control key shortcuts corresponding to push buttons in the control panel. It also contains options to delete records and pack the database.
Next Positions the pointer on the next record.
Prior Positions the pointer on the previous record.
Top Positions the pointer on the first record.
Bottom Positions the pointer on the last record.
Locate Brings forward the Locate dialog allowing to to locate records that meet specific criteria.
Pack Permanently removes all records marked for deletion.
Toggle
Delete Mark/Unmark records for deletion.
Window Menu
This menu contains options and control key shortcuts allowing keyboard users to reposition windows on the monitor and to activate other windows in a screen set.
Move The current window blinks to show that it is selected for moving. Use the arrow keys to reposition the window. Press Enter when the window is in the desired location.
Cycle Activates windows in a screen set one at a time.
Reports Menu
This menu contains options allowing you to perform run reports and labels, and perform mail merge operations.
Reports Brings forward the Report dialog.
Label Brings forward the Label dialog.
Mail
Merge Brings forward the Letters dialog.
See Also: Organizer: General Help, Calculator, Calendar/Diary, Puzzle, Find, Report Dialog, Label Dialog, Letters Dialog, Locate, Controls
Money Transactions
The Money Transactions module allows you to display and edit information about specific transactions.
Information about a specific transaction is displayed in the Money Transactions window. A control panel allows you to move through the database or bring forward a dialog to locate records that meets specified criteria.
Moving Through the Database
In the control panel, choose Next, Prior, Top or Bottom to move through the database. Choose the Locate push button to locate records that meet specified criteria.
Editing Data
You can edit data in the Money Transactions window.
To edit a record, position the cursor on the a field and enter the desired changes.
Adding a New Record
Choose the New push button to add a new record. An empty Money Transactions window is displayed.
Use the controls and fields to enter the desired information in the Money Transactions window.
Saving/Cancelling Changes
When you make changes or add a new record, you can choose the Save push button to save the information. Choose the Cancel push button to abandon all changes to the record.
The Goto push button brings forward the Goto dialog allowing you to locate a record based on a value or expression. For more information, see the Goto topic.
The Menu System
The menu system for the Money Transactions module contains two menu pads -- System and Edit.
The System and Edit menu popups are identical to the System and Edit pads in the menu system for most other modules in the ORGANIZER.
See Also: Organizer: General Help, Locate, Menu System, Goto
Organizer: General Help
The ORGANIZER application is designed to provide examples of how to best make use of FoxPro 2.0's power tools. In addition, this application includes programming examples of nearly every new command and function in FoxPro 2.0.
When you run the ORGANIZER, two menu options, Conversions and Organize..., are added to the System menu popup.
Conversions
This module acts like a FoxPro desk accessory and allows you to convert from one unit of measurement to another.
Organize...
Choosing this option displays a popup with the following options:
Restaurants Organizes information about restaurants.
Client
Manager Organizes information about clients.
Money
Manager... Displays a submenu with the following options:
Credit
Cards Organizes credit card information.
Accounts Organizes bank account information.
Transactions Organizes your business transaction information.
Family &
Friends Organizes information about family members and friends.
See Also: Client Manager, Family / Friends, Credit Card Manager, Conversions, Account Manager, Money Transactions, Menu System, Locate, Goto, Balance
Puzzle
When you choose Puzzle from the System menu popup, the Puzzle appears. Choose the Shuffle push button to scramble the numbers, then click on one number at a time to move it to the adjacent empty square. You're a winner when the numbers are in order.
Clicking on the close box or pressing Escape removes the Puzzle.
Report Dialog
This dialog allows you to run reports.
To run a report, select the desired report in the Report list.
The check boxes to the right of this list perform the following actions:
Plain Prints the report without page headers on each page. A page header appears only on the first page of the report.
Summary Prints only data in the Summary band of the report.
No Eject Suppresses the initial form feed to the printer prior to printing the report.
For and While
The For and While check boxes in the lower right corner of this dialog bring forward the Expression Builder. You may set a For and/or While condition for the report.
Output
The radio buttons allow you to specify where to output the report and perform the following actions:
Preview Displays the report in a page preview window on the monitor.
To File Brings forward a dialog in which you can specify the name and location of a text file.
To Print Directs output to the current printer.
When the desired options are selected, choose OK to run the report.
Modifying a Report
To modify a report, select the desired report in the Report list and choose the Modify push button or double-click on the report name in the list. The report definition is displayed in a Report Layout window so you can make adjustments.
See Also: Organizer: General Help
Restaurant Manager
The Restaurant Manager is a multi-user application that allows you to display and edit information about restaurants. Information about a specific restaurant is displayed in the Restaurant Manager window. A control panel allows you to move through the database or bring forward a dialog to locate records that meet specified criteria.
Moving Through the Database
In the control panel, choose Next, Prior, Top or Bottom to move through the database. Choose the Locate push button to locate records that meet specified criteria.
Editing Data
Because this is a multi-user application, records displayed in the Restaurant Manager window are read-only.
To edit a record, choose the Edit push button. An attempt is made to lock the record and prevent two users from editing the record simultaneously.
If the record has be locked by another user, a message is displayed. You can wait until the record is available or you can press Escape to abort the attempted lock.
When you have successfully locked the record, the Edit push button changes to Save.
Position the cursor on the a field and enter the desired changes.
You can specify features of a restaurant by choosing the appropriate check box.
To change the Cuisine, Rating or Cost, choose the desired options from the corresponding popup. To add a new cuisine, rating or cost category, choose Other... from the appropriate popup and enter the new option in the text box that appears below the popup.
Adding a New Record
Choose the New push button to add a new record. An empty Restaurant Manager window is displayed. Enter the desired information in the Restaurant Manager Screen.
Saving/Cancelling Changes
When you make changes or add a new record, you can choose the Save push button to save the information. When you choose Save the record is unlocked. Choose the Cancel push button to abandon all changes to the record.
Order
The Order popup in the lower right corner of the Restaurant Manager window allows you to specify the order in which the records are displayed.
Menu System
The Restaurant Manager uses the standard menu system used for most ORGANIZER modules. For information, see the Menu System topic.
See Also: Organizer: General Help, Report Dialog, Locate, Controls, Menu System
TALKz
COMPATIBLEz
_qbj0lxh40
MS Sans Serif
_qbj0lxh40
MS Sans Serif
@*HN \!\<Yes;\? \<No
Pack F&
MS Sans Serif
_qbj0lxh40
CURRAREA
TALKSTAT
COMPSTAT
_QBJ0LXH40PACKIT
H40_QBJ0LXHGR
RECORD
GOTOP
PACKIT
_QBJ0LXHGR
TALKz
COMPATIBLEz
reports
REPORTS
REPORTS.PJX
REPORTS
REPORTS.SCX
REPORTS
REPORTS.MNX
REPORTS
REPORTS.PRG
REPORTS
REPORTS.QPR
MS Sans Serif
Preview
reports
No reports in this Module
reports
Description
MS Sans Serif
Report
MS Sans Serif
@ 1.692,2.000 GET m.report PICTURE "@&N" FROM reps RANGE 2 SIZE 5.769,42.200 DEFAULT 1 FONT "MS Sans Serif", 8 VALID _qbm0s2a14()
(.txt)