|
|
Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
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
"D" wrote:
[Quoted Text] > 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
|
|
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
"S.Y.M. Wong-A-Ton" wrote:
[Quoted Text] > 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
>
>
> "D" wrote:
>
> > 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
|
|
where and how do you add this partial search code?
"S.Y.M. Wong-A-Ton" wrote:
[Quoted Text] > 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
>
>
> "D" wrote:
>
> > 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
|
|
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
"AP" wrote:
[Quoted Text] > where and how do you add this partial search code?
>
> "S.Y.M. Wong-A-Ton" wrote:
>
> > 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
> >
> >
> > "D" wrote:
> >
> > > 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
|
|
i was wondering how to get the code into the infopage, and where i could get
some examples of this code
Thanks
AP
"D" wrote:
[Quoted Text] > 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
>
> "AP" wrote:
>
> > where and how do you add this partial search code?
> >
> > "S.Y.M. Wong-A-Ton" wrote:
> >
> > > 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
> > >
> > >
> > > "D" wrote:
> > >
> > > > 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
|
|
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!
"AP" wrote:
[Quoted Text] > i was wondering how to get the code into the infopage, and where i could get
> some examples of this code
>
> Thanks
>
> AP
>
> "D" wrote:
>
> > 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
> >
> > "AP" wrote:
> >
> > > where and how do you add this partial search code?
> > >
> > > "S.Y.M. Wong-A-Ton" wrote:
> > >
> > > > 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
> > > >
> > > >
> > > > "D" wrote:
> > > >
> > > > > 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
|
|
Try this link:
http://groups.google.com/group/microsoft.public.infopath/browse_thread/thread/3eac3d1470eb5127/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
"AP" wrote:
[Quoted Text] > where and how do you add this partial search code?
>
> "S.Y.M. Wong-A-Ton" wrote:
>
> > 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
> >
> >
> > "D" wrote:
> >
> > > 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
|
|
|