InfoPath Tutorials, Articles, and Solutions

Full list of InfoPath 2003, InfoPath 2007, and InfoPath browser forms tutorials, articles, and solutions.

Integrate InfoPath with SharePoint

• Accessing configuration settings from InfoPath 2007 browser-enabled form templates
• Auto-fill a repeating table with data from a SharePoint list when a row is inserted
• Auto-numbering InfoPath forms when they are submitted to a SharePoint form library
• Automatically add a new item to a SharePoint list using InfoPath 2007 and a custom workflow
• Copy a SharePoint list to an InfoPath repeating table using XSLT
• Counting the amount of documents submitted today to a SharePoint library
• Determine whether Forms Server is installed on a server
• Displaying images in InfoPath 2007 browser forms served through Forms Services in SharePoint
• Downloading InfoPath 2007 Forms in a Specific File Format from a SharePoint Form Library
• Filter a SharePoint list in a repeating table in InfoPath on a date range
• Force InfoPath browser-enabled form to open in the browser
• How to add a data connection to a SharePoint list or library in InfoPath
• How to create a SharePoint Designer workflow that sends an email containing a link to an InfoPath browser form
• How to create an InfoPath initiation or association form for a SharePoint workflow created in Visual Studio
• How to delete SharePoint list items via an InfoPath browser form using the SharePoint Object Model
• How to execute JScript code from an InfoPath 2007 browser-enabled form template
• How to publish an InfoPath 2007 browser form to SharePoint
• How to publish an InfoPath form template as a new SharePoint site content type
• How to send email from an InfoPath browser form in SharePoint
• How to set the value of an InfoPath form field through a SharePoint workflow
• How to simulate Excel's VLOOKUP function in InfoPath to look up data in a secondary data source using rules and filters
• How to submit the rows of a repeating table in InfoPath to a SharePoint list
• How to update a SharePoint list via an InfoPath browser form using the SharePoint Object Model
• How to use a SharePoint ItemAdded event handler and the object model to submit data from an InfoPath form to a SharePoint list
• How to use a Visual Studio workflow to submit data from an InfoPath form to a SharePoint list
• How to use the SharePoint object model to submit data from an InfoPath browser form to a SharePoint list
• InfoPath Warning: The form template could not be browser-enabled, but it was successfully published for use with Microsoft Office InfoPath
• Programmatically add an item/event to a SharePoint 2003 calendar using InfoPath 2003 and script code
• Programmatically add an item/event to a SharePoint 2007 calendar using InfoPath 2007 and .NET code
• Programmatically check whether a value exists in a drop-down list box bound to a SharePoint list using an XPath filter
• Programmatically copy rows from a SharePoint list to a repeating node in the Main data source in InfoPath
• Programmatically create a custom SharePoint list from a repeating table in an InfoPath web-based form
• Programmatically retrieve an InfoPath form from a SharePoint library
• Programmatically submit an InfoPath form to a SharePoint library, send an email, and then close the form
• Use a custom SharePoint workflow to extract a file attachment from an InfoPath form and upload it to a SharePoint document library

Convert or Print InfoPath Forms

• Convert an InfoPath form into a Word 2003 document and send this as an attachment in an e-mail
• Convert an InfoPath 2007 form into a Word 2007 document using XSLT and C#
• Printing InfoPath 2007 Web-based Forms to PDF
• Programmatically convert Rich Text data from InfoPath to Word DOCX
• Save / Print / Convert / Export an InfoPath form to PDF
• Transform data from a secondary data source using XSLT
• Use Word 2007 to programmatically convert an InfoPath 2007 form to PDF
• Using the Open XML Format SDK 2.0 to convert an InfoPath form into a DOCX file

Integrate InfoPath with SQL Server

• Saving InfoPath Forms to SQL Server 2005 as XML
• Retrieve an InfoPath form from SQL Server and display it in a new instance of InfoPath
• Retrieve an InfoPath form from SQL Server and display it in an InfoPath FormControl
• Using a Receive data connection in InfoPath to execute an SQL Server stored procedure

Integrate InfoPath with Microsoft Access

• Database record selection in InfoPath through a dropdown list box
• InfoPath does not support the specified database. The database must be a Microsoft SQL Server
• Master/detail across views
• Programmatically add records to a database table using VBScript
• Query an Access database table in InfoPath by a list of numbers
• Sequential database table record navigation
• Use an Access table as a secondary data source in a browser-compatible InfoPath form

Use Repeating Tables and Repeating Sections

• 4 Ways to programmatically add a row to a repeating table in InfoPath
• Auto-populate a repeating table in InfoPath with sequential dates
• Autonumbering fields in a repeating table in InfoPath 2007 using VB.NET code
• Count the total amount of sections in a Repeating Section in InfoPath on insert or delete
• Filter a repeating table on a date range using rules and filters
• How to check whether the values of all fields in a Repeating Table in InfoPath have been set
• How to create a hidden column in an InfoPath repeating table
• How to get the current row number of a repeating table in InfoPath using VB.NET code
• How to loop through items in a repeating table in InfoPath 2007
• How to pre-fill a repeating table in InfoPath with rows of data
• How to submit rows of a repeating table in InfoPath to a web service
• InfoPath Basics: Repeating control basics in InfoPath
• Programmatically add a row to a repeating table using an XmlWriter object
• Programmatically delete all of the rows of a repeating table in InfoPath
• Programmatically delete the first row of a repeating table in InfoPath
• Programmatically execute code when a repeating table row is inserted or deleted
• Programmatically hide the first row of a repeating table in InfoPath
• Programmatically prevent users from adding more rows to a repeating table in InfoPath
• Programmatically retrieve the value of another field in the same row of a repeating table
• Programmatically retrieve the value of another field in the same row of a repeating table in InfoPath 2007
• Selecting the minimum date in an InfoPath repeating table using formulas (no code)

Use Drop-down List Boxes and List Boxes

• Auto-fill fields in InfoPath from a drop-down list box selection and secondary data source
• Automatically type in and add a new item to a drop-down list box on an InfoPath form
• Create a shrinking list in a repeating table in InfoPath
• Dynamically fill a drop-down list box in a browser form using another InfoPath form as a data source
• How to automatically display the first item in a drop-down list box in InfoPath 2003
• InfoPath Basics: List control basics in InfoPath
• Programmatically add items to a drop-down list box in InfoPath 2007
• Programmatically move items between two lists in InfoPath using C# code
• Programmatically select all items in a multiple-selection (multi-select) list box

Use Rich Text Boxes

• How to display images in a repeating table in an InfoPath browser form using a Rich Text Box control
• How to get HTML tags to appear as HTML and not as plain text in a Rich Text Box
• How to programmatically get or set the XHTML code of a Rich Text field in InfoPath 2007
• Programmatically add an item with a Rich Text field to a SharePoint list using InfoPath 2007
• Programmatically add lines of text to a Rich Text Box field on an InfoPath form using C# code

Use Date Picker Controls

• Auto-formatting a time field in InfoPath when it loses the focus
• Calculate the difference between two date picker controls in InfoPath using rules and formulas - no code!
• Calculating a person's age given a date of birth using rules and formulas in InfoPath
• Calculating date differences in InfoPath using VBScript code
• Calculating date differences in InfoPath 2007 browser forms using C# code
• Calculating date differences in InfoPath using SharePoint Excel Services
• Calculating time differences in InfoPath using custom JScript code
• Calculating date and time differences in InfoPath using VBScript
• Calculating time differences in InfoPath without custom code
• Calculating work days between two date pickers in InfoPath using VBScript
• Date and time basics in Microsoft Office InfoPath
• Filtering a list in InfoPath on the current month and day period
• Forcing users to select a particular day of the week from a date picker in InfoPath using rules and formulas
• How to check whether a start date falls before an end date in InfoPath
• How to extract the month name from a date picker in InfoPath
• Switching between day sections in InfoPath using xdExtensions and JScript

Use Functions, Formulas, Rules, and Conditions

• Automatically change the first letter of a word/sentence to upper case
• Create a day of the week InfoPath form using rules and formulas
• Create an absence report form using rules
• Display a message box if an item does not exist in the list of entries for a combo box
• How to create a toggle button in InfoPath using rules and conditions
• Using the AVG function in InfoPath

Miscellaneous Solutions

• Building an RSS Feed Reader with Microsoft Office InfoPath
• Generate a concatenated string of email addresses from a list using VBScript
• How to create a class for an InfoPath form
• How to deserialize an InfoPath form into a C# or Visual Basic object
• How to get data from a MySQL database into InfoPath using a Web Service
• How to programmatically disable/enable a control on an InfoPath form
• How to submit data from an InfoPath form to a MySQL database using a Web Service
• InfoPath 2007 Frequently Asked Questions (FAQ)
• InfoPath Basics: 3 Ways to validate data in InfoPath
• InfoPath Basics: How to populate an InfoPath form when it is opened/loaded
• InfoPath Basics: Main vs. secondary data sources
• InfoPath Basics: Understanding Rules in InfoPath
• Launch WSS forms library InfoPath form from a web page
• Password-protecting sensitive InfoPath form fields
• Programmatically create an InfoPath form from scratch using a Console application and C# code
• Programmatically retrieve the value of an InfoPath form field using .NET code
• Reference to undeclared namespace prefix: 'my' error in InfoPath
• "This form template is browser-compatible, but it cannot be browser-enabled on the selected site" message
• Understanding the 'Form Language' setting in InfoPath browser-compatible form templates
• Updating a Secondary Data Source in InfoPath Using AJAX