Finding a range in an Infopath form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Vangie - 06 Oct 2006 00:14 GMT

I have an inforpath form that is connected to an Access database. Is there a
way to list the query fields so I can put in a range, for example, if I am
searching for only the records in a particular year or years? Or is there a
way to enter something in a field that could be part of a field and then use
a wild card, like *?

Reply to this Message

S.Y.M. Wong-A-Ton - 06 Oct 2006 06:19 GMT

If you want to use a wild card character, you'll have to write code. Search
this newsgroup to find samples on how to do this. This article
http://enterprise-solutions.swits.net/infopath2003/article.php?t=query-access-da
tabase-list-numbers&c=infopath2003
also contains part of the solution to writing the code for this.

Or you can do something similar to what I did in this article:
http://enterprise-solutions.swits.net/infopath2003/article.php?t=filter-repeatin
g-table-date-range-rules&c=infopath2003
. You needn't change your database, though, since you'll only be using the
year. Just alter the expression for the filter to only use the year.
---
S.Y.M. Wong-A-Ton

> I have an inforpath form that is connected to an Access database. Is there a
> way to list the query fields so I can put in a range, for example, if I am
> searching for only the records in a particular year or years? Or is there a
> way to enter something in a field that could be part of a field and then use
> a wild card, like *?

Reply to this Message