 |
 | 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 / October 2006Infopath and Access Database
I am trying to create a form based on an Access Database of computer equipment. How can I set he form so that when you do a query, you can put in partial information in a field and the query will return every item that has that information. Or for example if you leave out a dash or space the query will still come back with data. Thank you for your help, D InfoPath's out-of-the-box querying mechanism looks for exact matches, so you'll have to write code to do the querying if you want to search on partial information. There are several samples posted in this newsgroup that show you how to do the latter. --- S.Y.M. Wong-A-Ton > I am trying to create a form based on an Access Database of computer > equipment. How can I set he form so that when you do a query, you can put in [quoted text clipped - 4 lines] > Thank you for your help, > D Thank you. I had a feeling that was going to be the answer. I am just starting to use InfoPath and I'm not really sure how to play with the code. I was hoping there was a tool in InfoPath itself. Thank you again, D > InfoPath's out-of-the-box querying mechanism looks for exact matches, so > you'll have to write code to do the querying if you want to search on partial [quoted text clipped - 11 lines] > > Thank you for your help, > > D where and how do you add this partial search code? > InfoPath's out-of-the-box querying mechanism looks for exact matches, so > you'll have to write code to do the querying if you want to search on partial [quoted text clipped - 11 lines] > > Thank you for your help, > > D The user would type in the words or numbers to search in a particular field in the query section of the form. Is that what you are asking? -D > where and how do you add this partial search code? > [quoted text clipped - 13 lines] > > > Thank you for your help, > > > D i was wondering how to get the code into the infopage, and where i could get some examples of this code Thanks AP > The user would type in the words or numbers to search in a particular field > in the query section of the form. Is that what you are asking? [quoted text clipped - 18 lines] > > > > Thank you for your help, > > > > D I'm sorry, I don't know, other than S.Y.M. Wong-A-Ton response in this string, to look further in this newsgroup for sample code. At this point, it is more than I really know how to do. Good luck! > i was wondering how to get the code into the infopage, and where i could get > some examples of this code [quoted text clipped - 25 lines] > > > > > Thank you for your help, > > > > > D Try this link: http://groups.google.com/group/microsoft.public.infopath/browse_thread/thread/3e ac3d1470eb5127/d97c311577ac170a?lnk=gst&q=where-clause&rnum=3#d97c311577ac170a What you basicly need to do is add a field for entering your partial text. Then in the OnClick event handler of a button, add code to retrieve the value of this field, retrieve the Command string for the data connection of the form, append a WHERE-clause to the Command string including the value of the field plus an asterisk(*), and issue a Query() on the data connection. Restore the Command string to its original value when done. --- S.Y.M. Wong-A-Ton > where and how do you add this partial search code? > [quoted text clipped - 13 lines] > > > Thank you for your help, > > > D Thanks, i will play around with this and see what i come up with. AP > Try this link: > http://groups.google.com/group/microsoft.public.infopath/browse_thread/thread/3e ac3d1470eb5127/d97c311577ac170a?lnk=gst&q=where-clause&rnum=3#d97c311577ac170a [quoted text clipped - 25 lines] > > > > Thank you for your help, > > > > D |
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.