![]() The Quick Search box lets you quickly find a contact on the Contact List form. In the Select Names to Add dialog box, select the names that you want to add to the database. On the Contact List form, click Add From Outlook. If you use Microsoft Outlook, you can add contacts from that program without having to re-type the information. To make sure all the database content is enabled, in the Message Bar, click Enable this content.įor more information about enabling database content, see the article Decide whether to trust a database. To prevent this form from displaying the next time you open the database, clear the Show Welcome when this database is opened check box.Ĭlose the Welcome form to begin using the database. When you first open the database, Access displays the Welcome form. In this article, we cover the basic steps of using the Contacts Database template. If the steps below don't match what you're seeing, you're probably using an older version of the template. These instructions refer to the latest version of the template available for download. If Auto Value was set to No, you will have to include it and have your users enter an unique value into that field whenever they make a new entry – not something you want.Note: The Contacts database template has been updated over the last few years. If you created a database in OOo Base and your Primary Key field had Auto Value set to Yes, that field does not need to be part of the form. Repeat for each control in turn until every control that should be has been assigned to a field. If you set up the form correctly, the Data Field option will contain a list of the different fields in the data source (for example, Name, Address and Telephone). In the Properties dialog box, click on the Data tab (Figure 385). Then either right-click and select Control or click on the Control button on the Form Controls toolbar. Click on the control to select it (so small green boxes appear around it). Set Content to be the name of the table you want to access.įor each form control in turn, launch the Properties dialog box. Set Data Source to be the data source you registered. In the Form Properties dialog box, click on the Data tab (Figure 384). As soon as you select a form element in your document, the Form button becomes clickable. The form button is grayed out unless you have one of the form elements selected. You can do this by clicking on the Form button in the Form Controls toolbar or by right-clicking on any of the fields you inserted and selecting Form. Now you link your form with the data source you registered. ![]() So far you have followed the same steps you used before when you created your first form. ![]() Additional fields, of any type, can be added in the same way (click and drag). Click in the document and, holding down the left mouse button, drag the mouse to create a text box for the first form field (for example, Name, if you are linking to the database created above).Ĭlick the Text Box button again and drag the mouse to draw another field. If the Design Mode button is also grayed out, click on the Select button to activate it.Ĭlick the Text Box button. With design mode off, most of the toolbar buttons are greyed out. Show the Form Controls toolbar ( View > Toolbars > Form Controls ).Ĭlick the Design Mode On/Off button to put the document into design mode, if necessary. Follow these steps to create a new form and link it to a registered data source.Ĭreate a new document in Writer ( File > New > Text Document ).ĭesign your form, without putting in the actual fields (you can always change it later). Once it is registered, linking your form to the data source is simple. Whether you created a new database, or already had a data source, it must be registered with (see above). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |