-
This is now ok as I opted to recreate the form
-
[quote user="LDavis"]I'm working on an InfoPath form that will have 3 sections, daily-weekly-monthly. I would like the rules to pull from the auto date to hide the section unless it's on a certain day or month. Does anyone have any ideas on how to make this work. I have done set up the date format to show the day and tried ...
-
Hi Hilary
Is there any other workaround for this? Because when user A and B edit at the same time, either one of their data only get saved. Please suggest..
-
Interesting. So you are getting the form data connection, and it appears setting the connection string, then commented out the connection.Execute() line (which would have run the query for the data connection you already accessed) and create an OleDbConnection instead? I confess, I don't understand why.... You should be able to uncomment ...
-
This is what I attempted... I thought I was doing that but apparently not. I believe I got the start of this from a post from you a few years ago too. I varied from it since I wanted to capture the data into a recordset and use that to loop through and send back to my form. It fails on the OleConnection.Open(); ...
-
If you use Internet Explorer, the forum will leave your post formatting alone. Can you just use a SQL data connection in the form and modify the command for the data connection in your code? I'd guess if you did that instead of using an OleDBConnection, you wouldn't have to go full trust.
-
I have finished (almost) Building my first ever InfoPath form and have discovered that I can't get it to run some of my C# Code without having it set to Full Trust. For instance it won't run my OleDBConnection.Open() command unless it is in Full Trust. Although it will run Connection.Execute(). Is there a way I can put this together ...
-
Thanks for the reply. Is there a way I can get my code to come out in non-paragraph ways? I found the answer in the meantime or at least a workaround.
This command gets rid of duplicates.
// Selecting the multi box that contains all of the reports I want.
XPathNodeIterator multirpt = ...
-
Here is where I grabbed the code and setup the rules.
http://www.bizsupportonline.net/infopath2007/calculate-date-difference-infopath-rules-formulas.htm
-
thank you for that keyboard shortcut...I should use them more often...I used the copy shortcut and was able to copy your code which worked well. However...I am doing something wrong in the "difference" block as it remains at "0" when I put in dates.