-
Hi Shreeprabu,
This is probably not a good idea since it allows redirection to other sites which may not be trusted. I would recommend reverting the setting in IE and adding the domain on which you have your Access DB to your local intranet sites (for .NET code) or trusted sites (for jscript). Then it should work fine and not be a security hole. ...
-
Sounds like a product bug.
Patrick Halstead [InfoPath MVP]
InfoPathDev
-
Oops looks like we didn't follow-up. Sorry about that. People pull the unique number from the SharePoint form libraries all the time. We have written code to do this. I need to go find it... just a minute.
Patrick Halstead [InfoPath MVP]
InfoPathDev
-
Hi again,
Hmmm. This seems pretty simple. If you are setting up your form to submit from the main data source (#1) then the xpath in your code to populate from System.Environment.Username (#2) isn't correct. It will have to change to reflect the schema that was created for the main data source when you created your form to point to your Web ...
-
Hi Mark,
Well, that's a good point. We developed the Database Accelerator because this was one area where there was a gap in Microsoft's intuitive design ... :) Anyway, it should be easy to setup the evaluation version. Just run the install and follow the setup instructions.
Patrick Halstead [InfoPath MVP]
InfoPathDev
-
Ok I think I have the first bit worked out:
'get username
dim objWscript
set objWscript = CreateObject(''WScript.Network'')
usr = objWscript.UserName
'create query
dim objDataAdapter
set objDataAdapter = XDocument.DataObjects(''ad_details'').QueryAdapter
objDataAdapter.Command = objDataAdapter.Command + '' where Windows_Logon = ''' + usr + ...
-
I didnt create it from an existing SQL table because one didnt exist (infact the functionality of it wasnt really decided at that point)
I understand that it can be done programmically by specifying what data connection you want to use, then adding to its default query (as a string) where i can use a variable in the WHERE condition, then execute ...
-
What is the error message that you are getting?
Where did you add the User roles in sharepoint or in your InfoPath form?
Agni
InfoPath Dev India
-
Hey Patrick,
Sine code and I don't work well together most of the time, I found another figuratively simple way to acheive my request. In my Access Project, I created a query that uses the formula ''DATEADD(D,3,GETDATE())''. I then created a secondary data connection to this field and now use it to compare to the start date. Works great, less ...
-
A very simple and defensive approach would be to use try/catch in your script to catch the connection error. So, in the onload of the form you could try to make a connection (using the Query() method) to webservice or sharepoint list and if there is an error catch it.
Question, for the Data Connections are you connecting to, do you have the ...