-
Hi haket,
In general, SQL Server is always a better choice. Access can be easier to work with, but SQL Server is several orders of magnitude more powerful. The easiest way to upgrade to SQL is to use the Upsizing Wizard in Access. I have done this a few times, but not enough to give expert advice. I'll leave you with a ...
-
Hi schung,
I'm not sure exactly what you want, but on the summary page you could use expression boxes to display sums of the rows, or maybe concatenate some of the text together into one big long string.
It's really hard to give you advice until we know exactly what you are trying to do - can you give an example of what you have ...
-
Hi Helena,
You can use the Users and Groups web service provided by SharePoint to accomplish this. Establish a secondary data connection to one of the web service methods, and you should be able to enumerate whatever you need!
Here's an online version of the SharePoint SDK, but I would suggest you download the entire thing: ...
-
Awesome! Great to hear you could figure it out, and thanks for posting your results!
-
Hi Anubis,
I have never done this before, but I would download the SharePoint SDK and research all of the web services they expose - it's really quite extensive. A quick search on Google with "sharepoing getuserinfo", found the following page:
http://usingsharepoint.com/SharePointSDK/soapcUserGroup_SV01034392.htm
I hope this ...
-
Hi Soham,
I can't debug forms from the forum for free (say that 10 times fast, haha), but if you would like to purchase some support credits we could solve the problem.
http://www.qdabra.com/products_all.asp?cat=12
For the preceding-sibling problem, you should use it to get to the previous sibling, and then go down to the ...
-
Hi Raoul,
You might want to take a look at this blog post, it should help you out: http://www.infopathdev.com/blogs/matt/archive/2006/01/09/Create-a-Multi_2D00_View-Master_2F00_Detail-using-a-Query-Filter.aspx
If you don't want to use code you can convert the sample give to Rules quite easily.
-
Hi Soham,
Default value formulas do recognize preceding-sibling, maybe you had an XPath incorrect. I have made a simple sample that demonstrates this in the attached file. I think it should be pretty self explanatory, but let me know if there are any more problems.
-
Hi Soham,
I'm not sure what the problem is. I was able to get this to work with my sample form. Have you tried using default value formulas instead of Rules?
-
Hi Spudy,
From what you're telling me, it seems like your XML does not have a namespace at all. Try the XPath "/Util/Details" (without namespace prefixes). I think that should work. If that still doesn't work, could you paste an example of the XML that your form is trying to query against?