How to use InfoFind's Database Data Entry Form

Opening Database Forms

You can access database forms from the menu [Database]->[Database Applications]. Any form that you have created will show up as a link on the Database Applications form. If no database forms are saved on your computer then you will be prompted to create sample applications that you can use.

Database Entry Form

This form allows you to view, edit, or delete database records. The sample forms that InfoFind creates are useful for home or small business computer users. Larger companies can have database forms created that employees can use to enter, search, and filter for information. To create a report for the record that you are viewing on screen click the [Word Report] button in the toolbar. To save or delete a record click the appropriate buttons and to create a new database record click the new button. To navigate from one control to the next press the [Tab] key on your keyboard and to navigate to the previous control press the keys [Shift]-[Tab].

InfoFind Database Data Entry Form

Editing the Form

To change the layout of the form click the [Design Form] button from the toolbar. You can then move, change, add, and delete controls on the form.

InfoFind Database Data Entry Form in Edit Mode

When you select a control or form the Form Designer Properties window will change to show what you can edit for the current form/control. As you type or select new values in the Form Designer Properties windows the values will change for the form.

InfoFind Entry Form Properties  InfoFind Entry Form Control Properties

Both Form and Control properties require some knowledge of how databases work and understanding of common database terminology.
Form Properties
ApplicationName of the Application so that Forms can be displayed grouped by Application from the Database Applications Form.
TitleTitle of the Specific Form. Each Form must have a unique Application and Title.
Connection TypeType of Database Connection.
ConnectionDatabase Connection String. Click the […] button to define the string.
Db TypeThe type of Database (Database Vendor) for the Form’s Database.
GradientIf checked then a Gradient will be displayed for the Form’s background.
TableTable, View, or Query in the Database where the data is displayed from.
Primary KeyUnique field in the table that identifies each record.
Control Properties
Field NameDatabase Field name in the Table, View, or Query.
Field TypeData type of the data.
Field LabelLabel that will appear for the field in message prompts.
CaptionSeveral controls such as a label or button will display the caption value.
DefaultValue that appears for the field for new records.
ActionThe action value applies to buttons and allows for a record to be saved, deleted, or for the form to be set up to add a new record.
Max LengthApplies to Entry fields and it defines the maximum length of characters (letters and numbers) that can be entered.
Read OnlyIf checked then the value cannot be changed.
RequiredIf checked then a value must be entered.
Statistic QueryThis field contains a SQL Query that display’s a single value – for example - SELECT Sum(Expenses.Cost) FROM Expenses WHERE Year([Date]) = Year(Date()); Using this field requires knowledge of SQL Statements. If the following text is included in the statement ({CURRENT_MONTH}, {CURRENT_YEAR}, {PREVIOUS_MONTH}, or {PREVIOUS_YEAR}) and the database type is SQLite then InfoFind will replace the text with appropriate date criteria values. Most relational databases have data types that are strictly defined however SQLite is designed to work in many environments and to allow any data type in any field so date functions are not as well defined in SQLite as in other widely used databases such as Oracle, Teradata, IBM AS/400, IBM DB2, Microsoft SQL Server, or Microsoft Access. Using these keywords provides a way to query SQLite databases using a specific date with InfoFind.
QueryThis is used in Combo Boxes and it needs to contain a Table, View, or Query from the Database.
Value FieldThis is used in Combo Boxes and it is not required in all situations. However if the look up data (in the Combo Box) that is being displayed contains numeric Unique ID’s for each record then this value should contain the appropriate field name.
Display FieldThis value is required if listing data in a combo box. It will display all unique values for the table or view that is being displayed. If a numeric value is being used as the primary key on the look up table then the field [Value Field] needs to be filled in; otherwise this field will allow for text entry of items that are not in the list.
TopNumeric values that specify the location of the control on the form. They change as you move the control with your mouse or they can be manually entered to adjust the control on the form.
Change ToWhen you select a value here the selected control will change to the type of control that you have selected in the list.