Access Query from Infopath2003

[Shameem Dubai]

I have a Microsoft Access database table that has a Text feild (PartNo filed
) connected to InfoPath 2003. If I type a list of Part nos like e.g. D6789
, A00034-001 , it should display recods related to that part No.s . I can see
something similar in

http://www.bizsupportonline.net/infopath2003/query-access-database-list-numbers.htm

But it is for Number field only. Any Idea how I can make it for a Text feild ?

Thx

 

[Shiva (GGK Tech)]

Hello,

If your database that field data type is number then we have to send the
number value from InfoPath form also. Before sending the value we have to
convert text to integer then it will work.

If you want to change the field data type from integer to text then this we
have to do in database. Then we can send the text from InfoPath and it will
work without error.