#How to auto fill text form fields in word 2010 code#

#How to auto fill text form fields in word 2010 code#

With the form still in Design view, click the Code button to launch the formвЂ™s module. Figure C: The Print Customer Slip command button executes the VBA code that will pass Access data to the Word form. When you have a form bound to the Customers table, add a command button to the form and name it cmdPrint, as shown in Figure C. If youвЂ™d rather not alter the actual object, use a copy or use the AutoForm wizard to generate a quick form based on the Customers table. To simply the example, use the existing Customers form in Northwind. The most common method youвЂ™ll probably use to identify a specific record is an Access form. Then, save the form as CustomerSlip.doc and close it. Doing so disables a number of features, which will keep casual users from altering your form. It isnвЂ™t necessary to name the Word fields similarly to their corresponding Access fields, but doing so is self-documenting and simplifies your work.ДЄfter adding all the fields, click the Protect Form button. However, notice that the Word field names match the Access field names, with an additional fld prefix. The field heading doesnвЂ™t have to match the field names. Repeat steps 2 through 5 to add a text field for each heading, using the following list to name each field: Word field heading

Rename the field fldCustomerID and click OK.

Double-click the field to display the Text Form Field Options dialog box.

Click the Text Form Field button on the Forms toolbar.

In the document, click the table cell beneath the Customer Number heading.

Display the Forms toolbar by choosing Toolbars from the View menu and selecting Forms.

To add the first field, complete the following steps in the Word form: However, you must associate a Word field with each underlying Access field that you want to copy to the Word form. You donвЂ™t have to accommodate each field transfer just the data you need. The example Word document contains a matching field for each column in the NorthwindвЂ™s Customers table. Alter the width of each cell column, using Figure A as a guide, if you like. You can skip the formatting if you like it isnвЂ™t critical to the technique. The example form also uses shading and text in the first row to distinguish between the heading and actual information. To create this form, youвЂ™ll need five tables as follows: ColumnsДЇigure B: Identify the number of rows and columns in each table. In the resulting Insert Table dialog box, enter the appropriate number of columns and rows (see Figure B). To insert a table, choose Insert from the Table menu and then choose Table. You donвЂ™t need the tables, but they help organize and manage the data. The form in Figure A uses five two-row tables to simulate a form.

A field is a predefined cell for entering and storing information. In this context, a form is a document that contains fill-in blanks or form fields, in which you enter information.

The example form consists of five simple tables that contain form fields. The Word form isnвЂ™t as difficult to create as it might look. Figure A: The highlighted areas are text fields. Specifically, the example will transfer data from the Customers table, via a form, to the Word document shown in Figure A. WeвЂ™ll work with existing data in the Northwind database (the sample database that comes with Access).

A Word document that represents the form you need to fill.

A bit of VBA code to automate the process.

A method of identifying the Access data you want to transfer.The automated solution requires three pieces: Note:This information is also available as a download, which includes text files containing the VBA code from Listing A and Listing B. The good news is that Word and Access play well together. When this is the case, you may find it necessary to transfer Access data to Word forms. Now, you might not care what the report (paper form) looks like, but perhaps management does. For instance, you may find that you canвЂ™t exactly reproduce an existing paper form in Access, whereas you can in Word. Access reports provide a flexible and easy-to-use tool for sharing data, but sometimes, itвЂ™s the wrong tool. Susan Harkins walks through an example to demonstrate the process. When you need to bring your Access data into a Word form, a little VBA can expedite the task. How do IвЂ¦ Fill Word form fields with Access data?