InfoPath Dev

Hello; I have a form that users typically fill out manually to request exceptions to our processes. However, because of the results of a SOX audit, we need to fill out a copy form for each and every employee to document document grandfathered exceptions. I'm getting all of the information to fill out the form from our HR Database and ...

Thanks Hilary - That's twice now that you've saved my bacon - MUCH appreciated. Cheers. Ron...

Hello; I have an InfoPath 2007 form which uses a Web Service to submit data to a SQL Server Database. As we all know, submissions aren’t always successful and so my submit code lives in a Try-Catch. In the Catch, I capture the error message to a string that I would like to pass back to the form. My problem is ...

Thanks for the rsponse Ernesto. Our SharePoint server isn't set toaccept Full Trust forms (I'm getting that changed of course) but there is a local machine setting that requires you to check to accept Full Trust forms. I set it and now it all works just fine. Problem is I can't remember what that setting was or where I found it, so I ...

Hello; I’ve been trying to access some of the Active Directory information in code. When I tried to preview the form I got a permissions error message with a suggestion to use full trust. So I did. Doing so resulted in the above-mentioned error message being generated. So I Googled like every good little boy and girl would do and the ...

Hi Jimmy; What I've noticed after replying to Patrick was that all the fields that are coming up as mandatory are all reference fields in my database main table. They all have a Allow NULL setting in the Main table but all have a Don't Allow NULL in the Reference Tables. As for DataTypes, they are all Ints as they are references like I ...

Thanks for getting back to me Patrick - Much appreciated. Your answer is confusing my InfoPath newbie mind even more though. Prior to creating a WebService to talk to my form, I created a form based on the Database template. When my data sources were setup directly to the database, none of my fields were "Cannot be blank" because the ...

I have a bunch of fields (About 40%) in my main data source that have red asterisks next to them. When I open the properties, the Cannot be Blank attribute is checked but is grayed out. Is there a way to change this? The fields in the database do allow NULL values to be passed. I'm communicating with the SQL Server database via WebService, ...

I have an InfoPath form that is used to populate an MS SQL Server 2008 database. I have a Main Query which is used to submit data to the Database and there are also several Secondary Queries which are used to provide dropdown selections to the users on the form and I just populate the main table with the index values into the related tables like ...

Thanks fo rthe help Patrick - I will most definitely heed your disclamer as a valid resource. I did however figure it out - I was making it a little too complicated and found out that InfoPath has a lot more smarts built into it that I had anticipated. I guess I'm too much of a SQL-weenie :) - If I just use the reference to the secondary ...