HOW CAN I CREATE A MULTIPLE FIELD SEARCH BOX?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pointer - 07 Jul 2007 14:13 GMT

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

Reply to this Message

Allen Browne - 07 Jul 2007 14:40 GMT

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.

Signature

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.

> HI,
> I NEED ASSISTANCE IN CREATING A MULTIPLE FIELD SEARCH BOX, I HAVE A
[quoted text clipped - 19 lines]
> ME.
> THANK YOU

Reply to this Message

pointer - 07 Jul 2007 14:59 GMT

> Firstly, it was a little difficult reading your message while you were
> shouting (i.e. using all-upper-case means shouting in Usenet.)
[quoted text clipped - 42 lines]
>
> - 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.

Reply to this Message

raskew - 08 Jul 2007 16:18 GMT

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.)
[quoted text clipped - 17 lines]
>> ME.
>> THANK YOU

Reply to this Message