making a find button for client name

D

Dawn

I am using a database designed with all client info and I need to be able to
push a command button and it run a macro that will find part of a name (like
last name). Has anyone done this before and can they tell me how to do it?
 
D

Dennis

That's built in to Access already, via their drop-down menu (FIND). Why do
you want to reinvent the light bulb?
 
D

Dawn

The way our database was built for us it comes up with very detialed
spreadsheets and tabs and I want to deign a button that the employees who
don't know access can push to pll only address info and edit and change it.
And I would like the button to be pushed and a pop-up asks for last name and
they input and pulls only the ones with that name. We have had problems, so
i am trying to make it really simple for them to use.
 
D

Dennis

- Create a "query by Form" on the fields you want to search by, that opens
via a button click
- Create a form (opened by the QBF results) that allows editing of those
fields you desire.

All done.
 
Top