HOW CAN I CREATE A MULTIPLE FIELD SEARCH BOX?

[pointer]

HI,
I NEED ASSISTANCE IN CREATING A MULTIPLE FIELD SEARCH BOX, I HAVE A
SCREEN SHOT BUT I COULDN'T FIND A WAY TO INCLUDE IT IN THIS MESSAGE.
I HAVE BEEN BATTLING WITH THIS PROBLEM FOR WEEKS.
THE SEARCH BOX WAS CREATED IN FOXPRO, I'M TRYING TO CREATE A SIMILAR
SEARCH BOX IN MS ACCESS 2003. IT SEARCHES ONLY ONE TABLE SO EACH
TABLE HAS A SEARCH BOX FOR IT. HERE IS A DESCRIPTION FOR THE SEARCH
BOX FOR THE COMMUNITY TABLE WHICH IS ONE OF THE TABLES IN THE
DATABASE.
IT HAS A DROP DOWN LIST THAT SELECTS ALL THE FIELDS IN THE TABLE SUCH
AS AREA CODE FOR THE COMMUNITY, COMMUNITY CODE, AND COMMUNITY
DESCRIPTION. BESIDE IT IS ANOTHER DROPDOWN LIST BOX FOR OPERATOR
WHICH YOU CAN USE TO SELECT OPERATORS SUCH AS PLUS, EQUALS TO (=),
GREATER THAN, LESS THAN, IS NULL, BETWEEN, IN.
BESIDE THIS IS A BOX THAT DISPLAY VALUE.
BELOW ALL OF THESE FORM FILEDS IS AN OPTION BOX WITH OPTIONS FOR AND,
OR.
AND BENEATH THIS IS ANOTHER ROW JUST LIKE THE ONE BEFORE THE OPTIONS
BOX.
BELOW THIS ARE THREE BUTTONS FOR SEARCH, ALL, CANCEL.
I'D BE GLAD TO SEND A SCREEN SHOT TO ANYONE WHO REQUIRES IT TO ASSIST
ME.
THANK YOU

 

[Allen Browne]

Firstly, it was a little difficult reading your message while you were
shouting (i.e. using all-upper-case means shouting in Usenet.)

In Access, you use forms as the interface for your tables. You can show the
form in Continuous View if you want to see several records at once. If
that's acceptable, try this link:
Find as you type - Filter forms with each keystroke
at:
http://allenbrowne.com/AppFindAsUType.html
It's a little different: you choose the field from the drop-down list, and
then as you type into the box beside it, the form filters to show only those
records that have a match in the selected field.

To use it, you download the example, import the module, copy the combo and
text box to your form, and set one property.

 

[pointer]

Firstly, it was a little difficult reading your message while you were
shouting (i.e. using all-upper-case means shouting in Usenet.)

In Access, you use forms as the interface for your tables. You can show the
form in Continuous View if you want to see several records at once. If
that's acceptable, try this link:
Find as you type - Filter forms with each keystroke
at:
http://allenbrowne.com/AppFindAsUType.html
It's a little different: you choose the field from the drop-down list, and
then as you type into the box beside it, the form filters to show only those
records that have a match in the selected field.

To use it, you download the example, import the module, copy the combo and
text box to your form, and set one property.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.






- Show quoted text -

My profound apologies to everyone for using uppercase. I'm new to
usent please pardon me, I wanted to make it easy to read but i remain
corrected. Thank you very much Mr. Brown i've downloaded it and will
try it out.

 

[raskew via AccessMonster.com]

Allen -

Great little application! Thanks for providing it.

Bob

Firstly, it was a little difficult reading your message while you were
shouting (i.e. using all-upper-case means shouting in Usenet.)

In Access, you use forms as the interface for your tables. You can show the
form in Continuous View if you want to see several records at once. If
that's acceptable, try this link:
Find as you type - Filter forms with each keystroke
at:
http://allenbrowne.com/AppFindAsUType.html
It's a little different: you choose the field from the drop-down list, and
then as you type into the box beside it, the form filters to show only those
records that have a match in the selected field.

To use it, you download the example, import the module, copy the combo and
text box to your form, and set one property.

HI,
I NEED ASSISTANCE IN CREATING A MULTIPLE FIELD SEARCH BOX, I HAVE A

[quoted text clipped - 19 lines]

ME.
THANK YOU