Use an InfoPath form to perform CRUD actions on an Access table with Memo field
In this InfoPath demo video you will see how you can use an InfoPath form to add, edit, and delete records in a Microsoft Access database table that has a Memo field.
Recipe 88 contains 3 solutions that show you how to write C# code in InfoPath 2010 to add, update, and delete records in an Access database table that contains a Memo field.
Get more solutions from InfoPath 2010 Cookbook 3 which is available on Amazon.com
Watch next video: Submit an InfoPath form to a web service and then retrieve return values
InfoPath demo video transcript:
Here I'm in Access 2010, where I've got this OfficeApplications database table for which I want to create a User Interface in InfoPath 2010. This OfficeApplications database table is used to store the names, colors, and icons for Office applications. It has this App Icon column, which is a Memo field in which images of Office applications will be stored.
This is the InfoPath 2010 Filler Form, which I will be using to add, update, and delete records in the OfficeApplications database table. As you can see, currently all of the records are being displayed here at the top of the form.
First I'll add a new record... And when I hit Save Record, you'll see that the record is added here to the repeating table, and if I switch to Access and refresh, you'll see that OneNote has been added here as a new record to the database table.
Now I'll update an existing record... Let's take Excel, and I'll change the color to "Dark Green". Once I hit Update, you'll see that the Excel record is updated here in the repeating table, and if I switch to Access, you'll see that it has been updated here also in Access.
I can also delete a record... Let's say I want to delete the Word record, so I'll hit Delete. As you can see, the record disappears from the repeating table. And if I hit Refresh here, you'll see that the Word record is gone.
Related InfoPath Demo Videos:
- Submit/retrieve an entire InfoPath form to/from SQL Server
- Auto-number InfoPath forms in a SharePoint form library
- Use an InfoPath form and SharePoint Designer workflow to send an email with attachments
- Convert an InfoPath form to Word and PDF in SharePoint 2010
- Use an InfoPath form to add a recurring all day event to a SharePoint calendar
- Submit an InfoPath form to a web service and then retrieve return values
- Select and add files from a document library as attachments to a form
Copyright: This article may not be used on web sites (whether personal or otherwise), copied, disseminated, altered, printed, published, broadcasted, or reproduced in any way without an expressed written consent of S.Y.M. Wong-A-Ton. The techniques demonstrated in this article may be used within any Microsoft InfoPath project. This article is provided without any warranties. Copyright for this article is non-transferrable and remains with the author, S.Y.M. Wong-A-Ton.