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.
Work with Controls
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.
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.
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.
Use VBScript code to calculate the difference between two date pickers in InfoPath.
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.
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.
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.
Understand how Microsoft Office InfoPath uses dates to be able to do your own date manipulations and calculations within InfoPath.
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.
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
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.
Use rules to implement logic for calculating leave balances.
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.
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.
Use rules and the avg() function in formulas to calculate the average for a column of numbers in a repeating table.
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
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.
Query and update records within a Microsoft Access database using master/detail functionality across two views in InfoPath 2003.
Use VBScript to programmatically add records to a database table that has been bound to an InfoPath form.
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.
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
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.
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
Convert InfoPath forms
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.
Learn how to solve the InfoPath error: Reference to undeclared namespace prefix: 'my'.