InfoPath 2003 Tutorials and Articles

Learn how to use InfoPath 2003 to create electronic forms by following step-by-step instructions from InfoPath tutorials and articles.

ADVERTISEMENTS

Work with Controls

Date Pickers

Auto-formatting a time field in InfoPath when it loses the focus

Use rules, conditions, the concat() function, and the substring() function in InfoPath to convert the way a time field is displayed from hhmm to hh:mm when the field loses the focus.

Calculating a person's age given a date of birth using rules and formulas in InfoPath

Use rules, conditions, the today() function, the number() function, and the substring() function in InfoPath to calculate a person's age from his/her date of birth.

Calculating date and time differences in InfoPath using VBScript

Use VBScript in InfoPath to calculate the difference between start and end dates and times, and sum the time differences to get a grand total amount of hours.

Calculating date differences in InfoPath using VBScript code

Use VBScript code to calculate the difference between two date pickers in InfoPath.

Calculating time differences in InfoPath using custom JScript code

Use JScript code in InfoPath to calculate the difference between start and end times, and sum the time differences to get a grand total amount of hours.

Calculating time differences in InfoPath without custom code

Use rules in InfoPath to calculate the difference between start and end times, and sum the time differences to get a grand total amount of hours.

Calculating work days between two date pickers in InfoPath using VBScript

Use the DateDiff and Weekday functions in VBScript to perform date difference calculations in InfoPath that produce the amount of work days between two dates.

Date and time basics in Microsoft Office InfoPath

Understand how Microsoft Office InfoPath uses dates to be able to do your own date manipulations and calculations within InfoPath.

Filtering a list in InfoPath on the current month and day period

Use rules and filter conditions in InfoPath to filter a list containing dates first on the current month and then on a specific period between a minimum and maximum day number.

Switching between day sections in InfoPath using xdExtensions and JScript

Use JScript to determine the day of the week (Monday through Sunday) based on a specified date chosen from a Date Picker, and use the result to conditionally show/hide sections on an InfoPath form.

Drop-Down List Boxes

Auto-fill fields in InfoPath from a drop-down list box selection and secondary data source

Auto-fill fields in InfoPath from a drop-down list box selection and secondary data source

Repeating Tables

Create a shrinking list in a repeating table in InfoPath

Learn how to use rules and conditions in InfoPath to create a drop-down list box that shrinks in items as rows are inserted into the repeating table that contains the drop-down list box.

Create an absence report form using rules

Use rules to implement logic for calculating leave balances.

Filter a repeating table on a date range using rules and filters

Use rules and filters to filter Microsoft Access database table records being shown in a repeating table on a date range using two date pickers.

Programmatically retrieve the value of another field in the same row of a repeating table

Use the Source property of the DataDOMEvent object in the OnAfterChange event of a field in a repeating table to retrieve the value of another field in the same row of the repeating table using JScript.

Using the AVG function in InfoPath

Use rules and the avg() function in formulas to calculate the average for a column of numbers in a repeating table.

Text Boxes

Automatically change the first letter of a word/sentence to upper case

Use the concat(), substring(), translate(), and string-length() function within a formula to convert the first letter in a word or sentence.

Access Databases with InfoPath 2003

Access databases

Database record selection in InfoPath through a dropdown list box

Learn how to select an item from a dropdown list box, retrieve the database record corresponding to the item, and display the data in fields in InfoPath 2003.

Master/detail across views

Query and update records within a Microsoft Access database using master/detail functionality across two views in InfoPath 2003.

Programmatically add records to a database table using VBScript

Use VBScript to programmatically add records to a database table that has been bound to an InfoPath form.

Query an Access database table in InfoPath by a list of numbers

Use JScript to perform a search to find only those records in a Microsoft Access table that correspond to a given comma-separated list of numbers.

Sequential database table record navigation

Move sequentially through the records of a Microsoft Access database table by clicking on [First], [Previous], [Next], and [Last] buttons.

Integrate InfoPath 2003 with SharePoint

Retrieve and use data from SharePoint

Generate a concatenated string of email addresses from a list using VBScript

Use VBScript to extract email addresses from a SharePoint list of contacts and generate a concatenated string of email addresses separated by a semi-colon.

Transform data from a secondary data source using XSLT

Use XSLT to transform the data stored within a secondary data source.

Submit data to SharePoint

Programmatically add an item/event to a SharePoint 2003 calendar using InfoPath 2003 and script code

Use the UpdateListItems method of the Lists web service that comes with Windows SharePoint Services (WSS) to add an item to a SharePoint calendar from within an InfoPath 2003 form.

Use of InfoPath forms in SharePoint

Launch WSS forms library InfoPath form from a web page

Use javascript within a web page to mimic the behaviour of Fill Out This Form in a WSS Forms Library and be able to launch an InfoPath form from a web page.

Miscellaneous Solutions

Convert InfoPath forms

Convert an InfoPath form into a Word 2003 document and send this as an attachment in an e-mail

Use an XSLT stylesheet to convert the XML produced by an InfoPath form into WordprocessingML and send this generated WordML document as an attachment in an email using Outlook automation.

Error messages

Reference to undeclared namespace prefix: 'my' error in InfoPath

Learn how to solve the InfoPath error: Reference to undeclared namespace prefix: 'my'.

 
InfoPath 2013 Cookbook: 121 Codeless Recipes for Beginners

InfoPath 2013 Cookbook 2: 121 Codeless Recipes for SharePoint 2013

InfoPath 2010 Cookbook: 101 Codeless Recipes for Beginners

InfoPath 2010 Cookbook 2: 101 Codeless Recipes for SharePoint 2010

InfoPath 2010 Cookbook 3: 101 Code Recipes for C# Developers

InfoPath 2010 Cookbook 4: 101 Code Recipes for VB Developers

InfoPath 2010 Cookbook 5: Integrating InfoPath with Excel and Excel Services