- Using Xbasic to Select a Record and Display a Form
/pages/Guides/Xbasic/Using Xbasic to Select a Record and Display a Form.xml
Button1 runs Xbasic code that loads the Invoice form to display the details of the invoice selected in the embedded browse.
- Running a Script with a Function Key
/pages/Guides/Desktop/Design/View/Form/Running a Script with a Function Key.xml
You can use the OnKey event to trap any keystroke and run a script. For example, the following code on the OnKey event will trap the F2 key and run a user defined function.
- Creating a New Table
/pages/Guides/Desktop/Design/Data/DBF/Creating a New Table.xml
Typically, you create new database tables by defining their data field structure in the Table Editor window. Other methods for creating tables include:
- Creating a Tabbed Control
/pages/Guides/Desktop/Design/View/Layout Control/Creating a Tabbed Control.xml
Tabbed controls provide a familiar, tabbed interface that you can use on a form to organize fields, controls, and other objects. For example, you have a form in which you enter invoice information. By creating a tabbed control, you can have one tabbed page on which you fill in customer information, one page on which you enter billing information, and a third page on which you enter individual line-items.
- Using Radio Buttons to Select a Record
/pages/Guides/Desktop/Xdialog/Controls/Using Radio Buttons to Select a Record.xml
This technique allows you to identify a record selected with a radio button and read the value of a field bound to the radio button. In this example, the field will be the customer_id field, which is the unique key field for the customer table. This demonstration is based on the AlphaSports sample database.
- Creating a Grid for Microsoft Access Using the SQL Builder
/pages/HowTo/Databases/Creating a Grid for Microsoft Access Using the SQL Builder.xml
Step by step instructions for creating and formatting a grid for Microsoft Access using the SQL builder.
- Emailing a Report
/pages/Guides/Report/Generating Reports/Emailing a Report.xml
Alpha Anywhere supports different techniques for emailing a report.
- Archiving a Report
/pages/Guides/Report/Managing Reports/Archiving a Report.xml
Alpha Anywhere lets you create archive copies of your reports. For example, if you generate end of the month statements using Alpha Anywhere and create archive copies of the statements, you can go back and look at the statements for a particular month at any time.
To archive a report, right-click on a Report, and select Archive.
- How to Filter a Grid on the Selected Rows in a List Control
/pages/HowTo/Grid/Filter Grid With Selected List Rows.xml
Argument arrays, combined with the SQL IN clause, are a powerful way to filter records shown in a Grid component.
- Creating a Table Lookup
/pages/Guides/Desktop/Design/Data/DBF/Creating a Table Lookup.xml
You can use a record in another table as the source of the lookup values. You can also define a lookup that fills in several fields with values from fields you select from the lookup table. For example, you might define a lookup for the Prod_ID field. The lookup finds the matching Prod_ID record in the Product table and fills in the Price field.