Search a field in my database using infopath form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

regdent - 01 Feb 2008 19:42 GMT

I have created a database and an infopath form which links fine but what i am
trying to do is search in one of my boxes but not for the full name just one
of the words inside a field.

The retrive works fine if i fully type the whole of the field but looking to
just type in one word to find the info.

Is that possible?

Any help would be greatly appreciated.

(Using infopath and access 2007)

Roy

Reply to this Message

Clay Fox - 02 Feb 2008 07:58 GMT

We do it all the time with code. Text based search. If you have the data in
a database you could search within the field in the form or the table.

You could use a contains rule in InfoPath but I think using code will
perform better and be more reliable.

Signature

Clay Fox / Microsoft InfoPath MVP
www.InfoPathDev.com / The InfoPath Authority / Downloads, Samples, How-To,
Experts, Forum

> I have created a database and an infopath form which links fine but what i am
> trying to do is search in one of my boxes but not for the full name just one
[quoted text clipped - 10 lines]
>
> Roy

Reply to this Message

regdent - 04 Feb 2008 18:35 GMT

Can you help me with the code i have no idea when it comes to writing code.
The datbase name is IT Issues DB, the table name is issues and the field is
Title. I would really appreciate any help.

> We do it all the time with code. Text based search. If you have the data in
> a database you could search within the field in the form or the table.
[quoted text clipped - 16 lines]
> >
> > Roy

Reply to this Message