-
Hi
Add the below condition to set max(@ID) to 0 when year is 2010.
Case when (year('04/12/2010') = '2010') then 0
else @ID end
-
hi,
Thank you for your response.i am using this type of code. how can i filter the records on form_load.and also how can i assign the records in repeated table.DataSource dsEmployee = this.DataSources["LeaveInfo"];
XPathNavigator xnEmp = dsEmployee.CreateNavigator();XPathNodeIterator ...
-
Hi,
I think you are setting the values for secondary data source. For that first get the secondary dom and from that get the nodes and set the values. IF you check out you will get ‘XDocument.DOM.selectSingleNode("dfs:myFields/dfs:dataFields/d:tbl_GC100/@Lockbox")' value as null.
-
Hi and welcome to forums,
You have two ways.
a. Store the string variable in to a hidden field in the form. And add a rule to the button to set the value. Follow the below steps to do that.
1. Go to button properties.
2. Click on Rules.
3. Click Add then click Add ...
-
Hi, I am having the same issue.
I am using Visual Studio Tools for Applications to edit code of an Infopath 2007 form.
I use the following line to add the contents of a field to another and then add a line break to the end.
field1 = field1 & field2 & System.Environment.NewLine
The two fields are added together ...
-
Hello again,
Thanks in advance for any help on this one.
I have a form in which I create the project ID based on the last two digits of the year, then the month, and then a three digit incremental counter, all concatenated. So a form entered on April 24th would be 0904017 if 16 other ...
-
Hello,
I have a repeating table with several fields. I would like to have a "Copy Item" button that pulls the values from the table the button is in and adds them to a new item table that it inserts after the first item table.
Would I use the XpathNavigator.Clone and then add the ...
-
Hi there,
I have an Infopath form, which uses VB code to perform several advanced functions.
I can get most of what I want, but am stuck on changing the default value of 3 rich text boxes.
The default value should change when I click a button on the form.
The value to enter comes from a string variable which I have already set up.
Any ideas ...
-
In VB, to work with the DOM, you'll need to enter the following code:
Dim DOM as XPathNavigator = MainDatasource.CreateNavigator()
To reference a node, you'll need to copy the XPath from the node's data source and paste it into code:
Dim field1 as XPathNavigator = DOM.SelectSingleNode("xpath", NamespaceManager)
Look ...
-
I went ahead and started from scratch again and have it working on a basic level. I am not sure if or why this would matter, but I built all of my tables and sections first this time and then added my attachment control first (after of course opening and saving a blank form and injecting it). I have kept the attachment as first in my data ...