search in a table

[Guest]

i hope someone can help me. I need to search thru a table to find a certain value, if it exist or not. can anyone help me???

 

[DDM]

Easiest way: Use the Find command. Open your table and select Find from the
Edit menu. Enter the value to look for. Tell Access to search the entire
table. Set other options as required. Click Find Next and continue to do so
until Access has searched the entire table.

DDM
"DDM's Microsoft Office Tips and Tricks"
http://ddmara.tripod.com

i hope someone can help me. I need to search thru a table to find a

certain value, if it exist or not. can anyone help me???

 

[John Vinson]

i hope someone can help me. I need to search thru a table to find a certain value, if it exist or not. can anyone help me???

Searching for data is exactly what Access is designed to do.

To get started, open the table (in what's called "datasheet" view);
select the field that you want to search and click the binoculars icon
in the toolbar. Type in what you want to search for.

As you get more involved with Access you'll be creating "Queries"; you
can base a Query on a table (or on several joined tables), and put
"criteria" to select all of the records which match.

Good luck with Access; if you have specific questions please post
again.

 

[Guest]

----- John Vinson wrote: ----

On Fri, 26 Mar 2004 19:56:08 -0800, "luisp

i hope someone can help me. I need to search thru a table to find a certain value, if it exist or not. can anyone help me??

Searching for data is exactly what Access is designed to do.

To get started, open the table (in what's called "datasheet" view)
select the field that you want to search and click the binoculars ico
in the toolbar. Type in what you want to search for

As you get more involved with Access you'll be creating "Queries"; yo
can base a Query on a table (or on several joined tables), and pu
"criteria" to select all of the records which match

Good luck with Access; if you have specific questions please pos
again

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=publi


Thanks John, i believe you're pointing me to the right direction. But i negleted to mention that i am looking for code on how to do a Querie on a table (as you mentioned). This is what I'm trying to do. I have a table of users who can use a program I'm writing, but i need to Querie the table to see if they have priveledges to use the program. Can you help me with this?

 

[John Vinson]

Thanks John, i believe you're pointing me to the right direction. But i negleted to mention that i am looking for code on how to do a Querie on a table (as you mentioned). This is what I'm trying to do. I have a table of users who can use a program I'm writing, but i need to Querie the table to see if they have priveledges to use the program. Can you help me with this?

Well, not without knowing how your table is constructed or what in the
table indicates the user's privileges! YOU can see your database; I
cannot.

If it's just a matter of searching the table for a user's name, you
can create a Query based on the table, and on the Criteria line under
UserName type

[Enter user name:]

This will prompt you for a name, and return all records containing
exactly what you type in (misspellings will miss users). There are
fancier ways that may be easier for the user, but this should get you
started.