Create and use your own template. /Library/Application Support/Microsoft/Office/User Templates/My. Templates are files that help you design. Free Microsoft Word templates include layouts, photos & artwork. View 1000's of design examples - brochures, flyers, newsletters, postcards, menus, business cards. FREE download more than 3000 templates for Microsoft PowerPoint presentations with unique designs. Featured templates. 3D PowerPoint presentation (Hubble Telescope model) PowerPoint Classroom Timers (Clock) PowerPoint Weekly Meal Planner Excel PivotTable tutorial Excel. Applies To: InfoPath 2013 InfoPath 2010 You can design a Microsoft Office InfoPath form template that works with a Microsoft Office Access database to either query data, or to query and submit data. You can design this form template based on a Microsoft Office Access 2007 (.accdb format) database or an Access database saved in an earlier version (.mdb format). In this article Overview A form can have one primary data connection, called the main data connection, and that connection can optionally have one or more secondary data connections. You can use the main data connection to query or submit form data to an Access database. You can also use secondary data connections to query and submit data to external data sources, with some exceptions. For example, you can use a secondary data connection to an Access database so that it only queries the database. You cannot add a secondary data connection to a form that submits form data directory to an Access database. When you design a form template that is based on an Access database, InfoPath creates a main data source with groups that contain query fields and data fields, and also creates a query data connection as the main data connection for the form template. These fields and groups correspond to the way that data is stored in the tables in the database. Query fields contain the data that is entered into the form by a user to limit the query results to records that match the data in the query fields. When a form that is based on this form template uses the main data connection, InfoPath creates a query by using the data in the query fields. InfoPath then sends the query through the data connection. The database returns the results of the query back to the form through the data connection. The results of the query are put into data fields, which can be edited through controls on the form that are bound to those data fields. Because the data structure of the query and the data fields must match the way that data is stored in the database, you cannot modify these fields or groups in the main data source. You can only add fields or groups to the root group in the main data source. Find links to more information about data sources in the See Also section. A form can submit data to a database through the form's main data connection if the form template that the form is based on and the database meet the following requirements: • The form template is not a browser-compatible form template InfoPath will not create a submit data connection in the main data connection if you are designing a browser-compatible form template. To allow users to submit data in a form that is based on a browser-compatible form template, use a Web service that works with the database. • The left table in each pair of related tables in the main data source contains a primary key At least one of the relationships for every pair of related tables must include a primary key from the left table. • None of the data fields in the main data source of the form store a large binary data type InfoPath will disable the submit data connection if the query includes fields that can store a large binary data type, such as pictures, images, OLE objects, file attachments, the Office Access memo data type, or the SQL Text data type.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2018
Categories |