Lokpal

[lokpal]

Hell all members of access forums,

How can i search name in MS access database as like in MS word using *.*mdb

[HiTechCoach]

Not sure exactly what you want.

Maybe this: Universal Search on many text with details

[lokpal]

I am elaborating my question. Suppose I have 20 tables in my database. How can i search that in which table Lokpal exists?

Not sure exactly what you want.

Maybe this: Universal Search on many text with details

[NoellaG]

Hi,

first to find something one has to know the database structure: which tables contain what sort of information and how are they linked to each other.
then you can search in 2 ways:
1/ in the table itself: open the gtable that contains the information you look for (for instance if "lokpal" is a product, open the table with product information) and use the find/replace option. This works like the find in word. In stead of searching the document you can search only the current field (the column where the cursor ispositioned) or the document = all fields.
2/create a query: here you can combine different linked tables and then put "lokpal" as a criterium in the column that contains this name (for instance the column with product names)

grNG

[HiTechCoach]

I am elaborating my question. Suppose I have 20 tables in my database. How can i search that in which table Lokpal exists?

If you are searching for text within fields then the link I posted will do exactly what you want.