"list.var support program code" is necessary to call the contents of secondary table fields in the list template. The following list.var template code takes reading the newstext field in the news table as an example: $ fr = $ empire-fetch1(select newstext from {$ dbtbpre} ecms _ news _ data _ {$ r [STB]}, where id=$listtemp=. $fr[newstext].； How to set the wizard of control combo box for specific usage.
1. Open the database to be operated, right-click the form to which you want to add the control, and select Design View, or click the "Blank Form" button in the form group of the "Create" tab to create a new blank form and enter its design view.
2. Make sure that the Use Control Wizard button is selected, and then click the combo box button, and then click in Design view.
3. The combo box wizard will pop up automatically, keep the system default settings, and then click Next.
4. Select the source table to be used in the table or query list box in the opened interface, and click Next.
5. In the opened interface, all fields in the book classification table are listed. Here, select the "Category Number" item in the "Available Fields" list box, click the "Right Angle Bracket" button to select the selected field, and then click the "Next" button to continue.
6. Click "Next" for three consecutive times to open the combo box wizard completion interface, keeping the system default, and click "Finish" to complete the combo box setting.
7. At this point, the combo box design is completed. Click the View button in the View group of the Home tab to switch to form view, where you can view the records in the bound fields and enter new records.
Combo box controls display a column of data on the screen like a drop-down menu. Move the cursor to the desired option, and then click the mouse to complete the selection. A list box is similar to a combo box, except that you can enter values in the combo box, but you cannot enter values in the list box.
How to set a summary field?
1. Method 1: Open Excel, and take its materials as an example to add various classification and summary methods to a field. Table 1 is the original data, and Table 4 is the pivot table.
2. Open the worksheet where the PivotTable exists, and click any cell of the PivotTable. At this point, the PivotTable tool will appear at the top, and click Options.
3. Find the active field, click the field settings, and in the pop-up dialog box, select the custom box under the category summary and filter box, hold down the Shift key, click the field to be added, and finally click OK.
4. Method 2: Find the storage in the PivotTable field list on the right, left-click and click the selected field setting in the drop-down menu.
5. In the pop-up dialog box, check the custom box under the category summary and filter box, hold down the Shift key, click the field to be added, and finally click OK.
Why can't the inserted field be displayed in the PivotTable field list?
Select any cell in the pivot table and click "Field List" in the top menu to display it again.
Multi-field selection of drop-down list in Access2003 form?
Open the design view of the sub-form, select the Item Number combo box, and add the Update event procedure to Events in the property sheet on the right. Enter the code: Me in the VBA editor of the process. Name = me. Material number. Column (1) me. Specification = me. Material number. Column (2) I. Unit = me. Material number. Column (3) I. Quantity = me. Material number. Column (4)' (if any). I finished testing the above code in version 07 ~ ~