I have a Genealogy database created in Microsoft Access (it's huge). My question is, is it possible to search this table by creating a search engine on the web that will search the database by surname. The matching names must then be displayed in a table. Also if this is possible what steps do I take to create this?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Searching a Microsoft Access Database
- Thread starter Amber2
- Start date
You could try a LIKE clause in a SELECT query:
set rec = conn.execute("SELECT * FROM table WHERE columnName LIKE '"&surname&"'"
That's a really simple way. There was a component I saw recently for doing really fancy seaches but I can't remember where I saw it.
set rec = conn.execute("SELECT * FROM table WHERE columnName LIKE '"&surname&"'"
That's a really simple way. There was a component I saw recently for doing really fancy seaches but I can't remember where I saw it.
- Status
Similar threads
- Locked
- Question
- Locked
- Question