 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General MS InfoPath Questions / February 2008Search for partial values
I have an InfoPath form linked to a SQL Server 2005 database. The form is to be used a search, then modify/add form. So, we will say there are 2 sections: 1. Top Section: User can input into any field from the database to run a search query. 2. Bottom Section: Results display and user can then edit results if desired. So, I want the user to be able to go into section 1, and let's say they want to find part number that contain XYZ, they will all display below. Right now I can't find any options to do that. It's easy to do if I make a VB or SRS form, but I would prefer to use InfoPath. My other question is how to add a search range. Say I want to search all products entered into the system between two dates, how do I create fields to do so? Everytime I try and make an object in the form, it REQUIRES me to link to a datasource. Any ideas how to get around this? Thanks for any help. Hi David. There are some hacks to get something that would simulate your requests but I would recommend you investigate using web services instead. As you have found the standard data connection do not support dynamic queries. With webservices you can plus much more. If you are working on enterprise Infopath solutions against SQL that is the way to go and the intent of InfoPath development.  SignatureClay Fox / Microsoft InfoPath MVP www.InfoPathDev.com / The InfoPath Authority / Downloads, Samples, How-To, Experts, Forum > I have an InfoPath form linked to a SQL Server 2005 database. The form is to > be used a search, then modify/add form. So, we will say there are 2 sections: [quoted text clipped - 13 lines] > > Thanks for any help. You can try a trick that someone in the group once proposed. See this post: http://groups.google.com/group/microsoft.public.infopath/browse_thread/thread/f9 2820d69841cf78/f17dc616bf44e10b?hl=en&lnk=gst&q=%22Like%22+Queries+#f17dc616bf44 e10b For the date range, you can do something similar to what I did in this article: http://enterprise-solutions.swits.net/infopath2003/filter-repeating-table-date-r ange-rules.htm You should be able to substitute the Access Query with a SQL Server View. --- S.Y.M. Wong-A-Ton > I have an InfoPath form linked to a SQL Server 2005 database. The form is to > be used a search, then modify/add form. So, we will say there are 2 sections: [quoted text clipped - 13 lines] > > Thanks for any help. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.