2009 Archive

2009 blog posts on the InfoPath Solutions Blog

InfoPath Video Tutorial: Copy SharePoint tasks to InfoPath form fields

In this InfoPath video tutorial you'll learn how to use rules to copy data from a secondary data source of a SharePoint list to fields on an InfoPath form and then to the columns of a row in a repeating table on the InfoPath form.

Display SharePoint Tasks assigned to the current user in InfoPath

Learn how you can use the userName() function and Conditional Formatting in InfoPath to display only those tasks from a SharePoint Tasks list that have been assigned to the user who has opened the InfoPath form.

InfoPath Video Tutorial: Filter SharePoint list data in an InfoPath repeating table on dates

In this InfoPath video tutorial you'll learn how to use two date picker controls to select a date range that can be used together with conditional formatting to filter data from a SharePoint list contained in a repeating table on dates.

InfoPath Video Tutorial: Auto-populate InfoPath repeating table row on insert

In this InfoPath video tutorial you'll learn how to use rules to copy data from a secondary data source of a SharePoint list to the columns of a row in a repeating table whenever a new row is inserted in the repeating table.

Displaying InfoPath forms on an ASP.NET web page

Learn how you can retrieve InfoPath forms that are stored as XML from a SQL Server database, convert them to HTML, and then display them on an ASP.NET web page.

10 most popular InfoPath / SharePoint articles on BizSupportOnline

Learn which SharePoint and InfoPath articles and videos on BizSupportOnline received the most views and were found to be the most helpful in the past few months.

Delete, remove, or clear an attachment from an InfoPath form

Learn how you can delete or clear an attachment field on an InfoPath form manually or through code.

Use a custom SharePoint Designer workflow activity to upload images from InfoPath to a SharePoint Picture Library

Learn how you can use an InfoPath browser form, file attachment controls in a repeating table, and a custom SharePoint Designer workflow activity to upload and store images in a SharePoint Picture Library.

Using InfoPath to create tasks and appointments in Outlook

Learn how you can use the Outlook Object Model in InfoPath to create Outlook appointments and tasks.

InfoPath Video Tutorial: Upload images from InfoPath to SharePoint using a custom SPD activty – Part 2

In this InfoPath video tutorial you'll learn how to create a custom SharePoint Designer activity that loops through and uploads images stored within an InfoPath browser form to a SharePoint Picture Library. This is part 2 of a 2-part video tutorial.

InfoPath Video Tutorial: Upload images from InfoPath to SharePoint using a custom SPD activty – Part 1

In this InfoPath video tutorial you'll learn how to create a custom SharePoint Designer activity that loops through and uploads images stored within an InfoPath browser form to a SharePoint Picture Library. This is part 1 of a 2-part video tutorial.

Programmatically restrict the size of an attachment in InfoPath

Learn how you can write code in the Validating event of an InfoPath File Attachment control to restrict users to only uploading files of a particular size.

InfoPath Video Tutorial: Programmatically restrict file types in InfoPath browser forms

In this InfoPath video tutorial you'll learn how to write code in the Validating event of a File Attachment control to limit its allowable file types to one or more extensions.

Writing to the Windows Event Log from an InfoPath browser form

If you're writing code in VSTA for an InfoPath browser form, want to debug it, but do not have Visual Studio, you can use the workaround described in this post.

Beginners programming for InfoPath browser forms in SharePoint

You only need to know how to do 3 things to be able to start writing code for InfoPath browser form templates that you deploy to SharePoint. Learn what these 3 things are.

InfoPath Video Tutorial: Debug code of an InfoPath browser form in SharePoint

In this InfoPath video tutorial you'll learn how to attach the debugger in Visual Studio to a SharePoint process ID to be able to debug an InfoPath browser form that has been deployed to SharePoint.

InfoPath Video Tutorial: Deploy and enable a managed code InfoPath form template on a SharePoint library

In this InfoPath video tutorial you'll learn how to deploy an InfoPath browser-compatible form template that contains managed code to SharePoint and then enable it to be used on a SharePoint library.

Trick: Clear or reset fields in InfoPath using only 3 lines of code

Learn how you can use just 3 lines of code and a 'special setup' in an InfoPath form to be able to create a reset button that can clear or reset fields or a subset of fields on an InfoPath form, whether it is browser-enabled or not.

Top 10 bestsellers among InfoPath and SharePoint books in 2009

Learn which InfoPath, SharePoint, and SharePoint Designer books were bought in 2009 and read by visitors to BizSupportOnline.NET.

2 Ways to store InfoPath VSTA projects in a source control repository

Learn which 2 methods you can use when you create an InfoPath form template that is bound to a VSTA project and want to store the files in and then later fetch the files from a source control repository such as e.g. Visual SourceSafe.

InfoPath Training Video: Adding and Using Data Connections in InfoPath

In this InfoPath training video, you'll learn how to add a data connection to a SharePoint list to an InfoPath form template and then bind the secondary data source to a drop-down list box and a repeating table.

InfoPath Training Video: Using Rules and Conditions in InfoPath

In this InfoPath training video, you'll learn how to add a Rule to a Button control on an InfoPath form template, and a Condition to specify when the Rule should run. You'll also see how you can use Rules to move text between two text boxes on an InfoPath form.

InfoPath Training Video: Working with Views in InfoPath

In this InfoPath training video, you'll learn how to add a View to an InfoPath form template, use rules to switch between Views in an InfoPath form, and make a View read-only.

InfoPath Training Video: Creating a simple InfoPath form template

In this InfoPath training video, you'll learn how to create a basic InfoPath form template and see what an InfoPath form and InfoPath form template are made up of.

Pre-filtering large SharePoint lists in InfoPath using WSS’s owssvr.dll

Learn how you can take advantage of Windows SharePoint Services' owssvr.dll to filter a long or large list of data in a SharePoint list before the data is returned to an InfoPath form and used to populate InfoPath controls.

InfoPath Training Video: Exploring the InfoPath 2007 environment

In this InfoPath training video, you'll learn what the most frequently used parts of the InfoPath Designer are, and get a quick tour around the InfoPath 2007 environment in Design mode.

Understanding the Multiple-Selection List Box in InfoPath

Learn how multiple-selection list boxes differ from other list boxes in InfoPath, how they store data, and how you can use this information to apply rules and conditional formatting, or to write code in InfoPath.

InfoPath Video Tutorial: Using a SharePoint list populated multi-select list box and conditional formatting to show/hide sections

In this InfoPath video tutorial you'll learn how to use conditional formatting on a repeating section to show/hide sections based on the items that were selected in a multi-select list box that is populated via a SharePoint list.

InfoPath Training Video: Installing InfoPath 2007

In this InfoPath training video, you'll learn how to install InfoPath 2007 and select the component required to be able to create electronic forms and write code for these electronic forms using VSTA.

Add a logo from a SharePoint library to an InfoPath browser form

Learn how you can use a Rich Text Box control and code to display an image for a logo that is stored in a SharePoint Picture Library on an InfoPath browser form.

InfoPath Training Video: Installing Forms Server 2007 on WSS 3.0

In this InfoPath training video, you'll learn how to install Forms Server 2007 and then configure InfoPath Forms Services in SharePoint to enable the use of browser-enabled forms in SharePoint.

InfoPath Training Video: What is InfoPath?

This InfoPath video is a slide presentation that explains what InfoPath is, what you can use it for, and what the advantages and disadvantages are.

Quick Tip: Select the latest date from a repeating table in InfoPath

Learn how you can use the max() function in a formula and conditional formatting in InfoPath to select and/or highlight the latest (newest) date in a repeating table.

Trick: Create InfoPath forms using a SharePoint Designer workflow

Learn how you can change the settings and default template on a SharePoint Form Library in such a way that it enables you to use a SharePoint Designer workflow to automatically create InfoPath forms in that SharePoint Form Library.

InfoPath Video Tutorial: Automatically create InfoPath forms in a SharePoint Form Library using a SharePoint Designer workflow

In this InfoPath video tutorial you'll learn how to configure an InfoPath form as the default template on a SharePoint Form Library, so that you can use the Create List Item action in a SharePoint Designer workflow to create and add an automatically filled out InfoPath form to the SharePoint Form Library.

InfoPath Q&A: Can you put a repeating table in a repeating table?

Step-by-step instructions for adding a repeating table in a repeating table on an InfoPath form.

Root element is missing in InfoPath when loading a MemoryStream in an XPathDocument

Learn how you can solve the 'Root element is missing' error if you're trying to load a MemoryStream into an XPathDocument in InfoPath.

InfoPath Video Tutorial: How to change a SharePoint Form Library template

This InfoPath video tutorial shows you how you can add, change, and rename a template that is accessible via the New button menu of a SharePoint Form Library.

Use a custom SPD action to extract an attachment from an InfoPath form and add it to a SharePoint document library

Learn how you can create a custom SharePoint Designer activity that can be used as an action in a workflow that runs on InfoPath forms to extract an attachment from an InfoPath form and upload it as a file to a SharePoint document library.

InfoPath Demo: Extract InfoPath attachments using a SharePoint Designer custom action

This InfoPath demo shows how you can use a custom SharePoint Designer action to extract a file attached to an InfoPath form and upload it to a SharePoint document library.

Archive or move InfoPath forms in SharePoint

Learn how you can use a SharePoint content type and a SharePoint Designer workflow to move InfoPath forms in SharePoint from one library to the other as a way of archiving InfoPath forms in SharePoint.

InfoPath Video Tutorial: Move InfoPath forms between SharePoint form libraries using a workflow

Learn how you can use a SharePoint content type and a SharePoint Designer workflow to move InfoPath forms from one SharePoint form library to another for the purpose of archiving them.

How to set the programming language in InfoPath 2007

Learn how you can set the programming language in InfoPath for both the current and all future InfoPath form templates you create.

3 Ways to deploy InfoPath form templates to SharePoint

Learn which methods are available for deploying InfoPath 2007 form templates to SharePoint 2007.

InfoPath Video Tutorial: How to create and deploy an InfoPath browser form template to SharePoint

Learn how you can use InfoPath 2007, Windows SharePoint Services (WSS) 3.0, and Forms Server 2007, to create and publish an InfoPath browser-compatible form template to a SharePoint Form Library.

InfoPath Video Tutorial: How to convert an InfoPath 2007 form template from VSTA to Visual Studio 2005

Learn how you can convert InfoPath 2007 form templates that contain Visual Studio Tools for Applications (VSTA) code into InfoPath projects for programming in Visual Studio 2005.

Send email from SharePoint based on values in an InfoPath form

Learn how you can access InfoPath form fields from a SharePoint Designer workflow and use a condition in the workflow to take action based on the value of a field in the InfoPath form.

InfoPath Video Tutorial: Send an email notification from SharePoint based on the values in an InfoPath form

Learn how you can use a SharePoint Designer workflow that reads data from an InfoPath form and sends emails or can take any other kind of action based on the values of InfoPath form fields.

Which programming language to use for writing code in InfoPath?

Learn which programming languages are available in InfoPath when you want to write code for InfoPath form templates, which language to choose, and which tool to use to write code in InfoPath.

InfoPath Video Tutorial: Write code in Visual Studio Tools for Applications to set the value of a field in InfoPath 2007

Learn how you can use C# code behind a button on an InfoPath form in Visual Studio Tools for Applications (VSTA) to set the value of a field on the form.

InfoPath Video Tutorial: Write code in Visual Studio 2005 to set the value of a field in InfoPath 2007

Learn how you can use C# code behind a button on an InfoPath form in Visual Studio 2005 to set the value of a field on the form.

Pre-selecting the year for an InfoPath Date Picker control

Learn how you can save time and increase efficiency by pre-selecting and setting the year at which an InfoPath date picker control should start displaying dates in its calendar.

InfoPath Q&A: Can InfoPath be used with Oracle databases for data gathering and reporting?

Programmatically set properties on InfoPath controls

Learn why you can only use conditional formatting on controls to programmatically set properties to hide, disable, or change the color for InfoPath controls.

Quick Tip: Finding "hidden errors" in an InfoPath form template

Learn how you can prevent errors from suddenly popping up in your InfoPath form by using the Logic Inspector to find unused business logic.

Switch to read-only view on submit in InfoPath

Learn how you can use either rules or code to switch to a read-only view immediately after a form has been submitted.

Quick Tip: Making InfoPath form fields read-only

Learn how to make an InfoPath form read only by using an InfoPath read only field, an InfoPath read only view, or use conditional formatting for read only purposes.

2 Ways to loop through InfoPath forms in a SharePoint Form Library

Learn how you can write C# code that uses the SPList, SPListItem, SPFolder, and SPFile classes of the SharePoint Object Model to loop through and retrieve all of the InfoPath forms that are stored in a SharePoint Form Library.

How to programmatically rename an InfoPath file attachment

Learn how you can write C# code to programmatically rename a file that has been attached to an InfoPath form.

How to programmatically retrieve selected items in a Multiple-Selection list box in InfoPath

Learn how you can write C# code to get the values or display names of the items that were selected in a Multiple-Selection List Box on an InfoPath form.

InfoPath Q&A: Where is InfoPath form data stored?

Learn how and where you can store InfoPath forms and what the difference is between InfoPath forms and ASP.NET forms.

Retrieve an InfoPath field in a SharePoint workflow

Learn how you can retrieve a field's value from InfoPath in a SharePoint workflow (SharePoint Designer workflow or Visual Studio workflow) that runs on that InfoPath form in a SharePoint form library.

How to submit a file attached to an InfoPath form as an attachment to a SharePoint list item

Learn how you can programmatically save a file attachment from an InfoPath form as an attachment to a SharePoint list item when the InfoPath form is submitted to the SharePoint list.

Understanding the Update Form button action in InfoPath

Learn what the Update Form action on a button in InfoPath does and how you can use it to your advantage to improve the performance of InfoPath browser forms.

How to close an InfoPath form programmatically

Learn how to in InfoPath close a web-based form programmatically by working around a few limitations of InfoPath where rules and code are concerned.

Specifying namespaces to use XPath queries in InfoPath

Learn how to define XML namespaces in InfoPath to be able to retrieve data using XPath expressions.

Create a Word 2007 document from an InfoPath form using the OpenXML SDK 2.0

Learn how you can use the OpenXML SDK 2.0 to programmatically create a Word 2007 document from an InfoPath form and deal with complex data conversions such as those for rich text boxes and repeating tables.

How to add, update, and delete SharePoint list items via InfoPath

Learn how to write code in InfoPath that makes calls into the SharePoint object model to insert, edit, and delete items in a SharePoint list.

2 Ways to place a Date Picker in a Repeating Table in InfoPath

Learn how you can add or convert a text box control that is located within a repeating table on an InfoPath form template into a date picker control.

How to submit an InfoPath form to a SharePoint list and attach the form to the list item

Learn how to use the Attachments collection of a SharePoint list item to save the XML of an entire InfoPath form as an attachment to a SharePoint list item.

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