Modify access template

[glarior]

I downloaded a template for MS access "

http://office.microsoft.com/en-us/templates/TC012253431033.aspx?pid=CT101428241033

Is it possible to modify the search function in the template to search the notes for word matches? So far it will only find people's names. I would like to add additional information into the notes section when adding a new contact and then do a search for keywords in the notes section. Is this possible? Am I clear on what I am trying to explain? If not let me know.

I am not sure how access works but I feel it is worth a try.

Thanks in advance...

 

[PHV]

Have a look to the InStr function or the Like operator.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[glarior]

Ok, where can I find the information to edit? From playing around with the template I notice that the field 'notes' is not selected to search. If I am able to add notes to the search list it should work. However, I can't find where to edit the search criteria. Suggestions?

 

[PHV]

I'd use the F2 and F1 keys when in the VBE ....

 

[glarior]

I did... I was typing a reply right when you posted. I finally found it. It was not under the VBE like I though. I went to design view and edited one of the fields and it worked.

Thanks for the information I learned something new today. I did not know about F2 while in VBE

Thanks!!!