Let's Talk about .. InfoPath 2007-Display the Current User in the form

Last week, I found the way to display the username of the user who logged in and open this InfoPath form. I found the way in this article..

Itay Shakury's article, InfoPath - Get the current user without writing code : http://blogs.microsoft.co.il/blogs/itaysk/archive/2007/04/05/InfoPath-_2D00_-Get-the-current-user-without-writing-code.aspx

This article suggests to get the current username via the web service UserProfileService at

http://ServerName/_vti_bin/UserProfileService.asmx

Let's Talk about .. InfoPath 2007-Error Request for the permission of type 'System.Data.SqlClient.SqlClientPermission failed

Today I connected my InfoPath form to the SQL database, but when I ran it, I got the error "Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed." I read some articles in the internet, and I tried to solve this problem by setting the full trust, and it works.

The instruction about how to set Full Trust.

1. In the desing mode, click menu Tools.
2. Click Form Options...
3. Select Category Security and Trust.
4. Check out the Automatically determine security level.
5. Check Full Trust.
6. Create the Certificate.
7. Select that Certificate.
8. Click OK.
   

Then, when you open the form, you have to trust this certificate for the first time of using the form.

Let's Talk about .. InfoPath 2007-Hide the Control

I found this article, Hide a control based on values on the form :: http://office.microsoft.com/en-us/infopath/HP100340241033.aspx, related to my requirement. My requirement is data validation for the summary value of 4 text boxes must not greater than 100, thus I think I should create one text box to be the summary of them, then set the data validation at this text box but I don't want it to be shown so I have to hide it.

The instruction about how to hide a control

1. Double click at the control.
2. ClickDisplay Tab.
3. Click Conditional Formatting Button.
4. Click Add Button.
5. Set the condition and check Hide this Control.

Note: some control can't be set as hide this control, but it can be set as Read-only.

Let's Talk about .. InfoPath2007-Customize Insert Item

My new requirement is to remove the link "Insert Item" under the repeating table. I found one article helping me, the article Insert a repeating table : http://office.microsoft.com/en-us/infopath/HP100809161033.aspx

The instruction about customizing the Insert Item

1. Double click at Repeating Table tab, below the repeating table.
2. The Repeating Table Properties appears on screen. You can remove the check box of Show insert button and hint text to hide the Insert button. And you can click at Customize command to modify the Table command.
3. In the Table command, you can add, remove, and change the command for that repeating table.

Let's Talk about .. InfoPath 2007-Let's Start

Last week I learned the InfoPath 2007 from P'Tum at my office after I read books and practice some exercises. InfoPath is the essential tool to create the form since there are many useful tool and nice template layout.

P'Tum suggested us to learn more about InfoPath at the MSDN InfoPath Training : http://msdn2.microsoft.com/en-us/library/bb267336.aspx