Acces Contact Management

  • Thread starter Thread starter Rag742
  • Start date Start date
R

Rag742

I downloaded the contract managemnt database for Access2003.I have two
question
1. The contact management has a field titled "Subject" I have changed
it from"Text" to "Memo" Data Type. I created a query to search for
Like "asbestos" in Subject Field to display all records with
"asbestos" in the Subject Field. For some raeson this is not working??
I tried changing the datatype to Text but no success.
2. How do I create a query with Query parameter to search for
say"asbestos" in the subject field at the run time. This way Ican
search the Records that contain different Item at Run time-say
"Asbetos"; "Lead","PVC" etc. Instead of creating a query for every
topic. Thanks.
Rag742
 
Try this in your query:
SELECT Yourtbl.ID, Yourtbl.Subject
FROM Yourtbl
WHERE (((Yourtbl.Subject) Like "*asbestos*"));

to create a form that allows input of search criteria is fairly simple.
Have a textbox where the user inputs the search criteria, or better still
(if you know all the possible search words) put them in a combo box. The
user then selects one and in the after update event of the combobox, create
your searchstring based on the combo selection.


Damon
 
Back
Top