Again, Keyword Search (Using Macros)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created an Access database that houses information for 2000
properties. In this database, the user can search properties by taxlot
number or street address. I would like them to be able to search the
form (called 'Mainpage') by keyword. For example, the property
located at 170 SOUTH OREGON STREET is also known as the Brunner
Building and the Old Library. Ideally, I would like them to be able to
search "Brunner," "Old," "Library," etc. and the form for
the 170 SOUTH OREGON STREET would appear. So, I have created a field
(called 'Search' that is located on Mainpage) that has a string of
all the words that each individual property could be called.

Others have told me to create a query with criteria and then link it to
the form. Something went awry there... As a self-taught novice, I
cannot seem to understand what is going wrong and what I have to do to
get this to work.

One told me to utilize the 'After Update' Command, but, again,
things did not work out.

Does anyoneknow how might be the easiest way to create this keyword
search?
 
ajwittman said:
I have created an Access database that houses information for 2000
properties. In this database, the user can search properties by taxlot
number or street address. I would like them to be able to search the
form (called 'Mainpage') by keyword. For example, the property
located at 170 SOUTH OREGON STREET is also known as the Brunner
Building and the Old Library. Ideally, I would like them to be able to
search "Brunner," "Old," "Library," etc. and the form for
the 170 SOUTH OREGON STREET would appear. So, I have created a field
(called 'Search' that is located on Mainpage) that has a string of
all the words that each individual property could be called.

Others have told me to create a query with criteria and then link it to
the form. Something went awry there... As a self-taught novice, I
cannot seem to understand what is going wrong and what I have to do to
get this to work.

One told me to utilize the 'After Update' Command, but, again,
things did not work out.

Does anyoneknow how might be the easiest way to create this keyword
search?
Click to expand...

How is your data organized? Based on what you say, I expect you need a
table for Properties and a separate table for property Aliases, with a
1-to-many relationship. The aliases table needs to include a foreign key
to properties.

The search can then attack the specifics somewhere along these lines:

SELECT PROPERTIES.*
FROM PROPERTIES LEFT JOIN ALIASES
ON PROPERTIES.PROPERTYID = ALIASES.PROPERTYID
WHERE ALIASES.DESCRIPTION LIKE '*' & <search stuff> * '*';

Now this only works when searching for alias information, not the actual
street address or taxlot.

Does this help at all?
 
Back
Top