When I am in design view and select "More Controls" the floating tool bar has ten boxes between the two controls with arrows at the top and the one at the bottom, none of those ten are called "Text Box". Thanks for that information, I'm going to try to find this guide that get referred to and read up a bit, but I was unable to add a field that way. On the Data tab select a field from the Data field list. Right click on the newly added column and select Column to open the Properties dialog. Select the appropriate type for the data you want to display. To add a column to a table control right click on the column names area along the top of the table and select Insert Column to see a list of all the column types. If the data for the form you opened is supplied by the table you edited, your newly added field should appear on the list.Ĭlick on Design Mode On/Off to enter the live mode to verify that the data in your new field is displayed. The list should display all the fields available. On the Data tab click on the down arrow to the right of the Data field property. Right click on the new control box and select Control to open the Properties:Text box dialog.
Use click and drag on an empty area of your form to add a new control box to your form. The mouse pointer changes to cross-hairs. For instance if your new field contains text select Text Box.
You must select a control type for your new field. Click on that to display a floating toolbar with additional controls. Further down the list is an icon for More Controls. There are a number control types including Text Box and Formatted Field. If the Form Controls aren't visible along the left margin enable them by going to View->Toolbars and selecting Form Controls.
The process is explained in Chapter 8 – Getting Started with Base You can of course use the Wizard to create a new form but to edit and existing form you must add fields one by one. Look towards the bottom of the dialog and change Auto Value to Yes.ĭouble click on the new table and you can enter data directly into the table, or better yet design a Form to allow a more user friendly environment. (Right click on a field name to toggle the Primary Key selection) Notice that it has a small yellow key icon in front of the field name, indicating that it is a Primary Key. The table will be created with a new ID field in the first position. If you are creating a new table you should get a dialog allowing you to enter a name for the new table.Īlso if you are creating a new table,it should next ask Should a primary key be created? Answer Yes When you have finished entering all the fields you want press S or click the Save icon. You can type in any notes that might help you, but it isn't used any place else. The third column (Description) is entirely optional. There are over 20 choices but the most commonly used ones are TEXT(Varchar), INTEGER, DECIMAL, DATE. In the second column (Field Type) select what type of data you want to store in that field. It can be anything meaningful to you (i.e. In the first blank row type a name in the Field Name column. If you already have a table right click on the table name and select Edit to open the table design GUI. If you are using the default Embedded database model (look in the lower left corner of the Base main page) then you can use Create Table in Design View to open the table design GUI. Look for Chapter 8 – Getting Started with Base Have you read the documentation for Base?
0 kommentar(er)
