How can I search a database?
Printable View
How can I search a database?
Search the database for what ? What database format ? If record set could use SQL.
Im not used to databases. But i need to search for a certain record.
Ok sorry support call came up
So if you are using access/sqlv6 or 7
In Declarations something like
Private db as database
Private rs as recordset
Private sSQL as string
Say a search command button
Private Command1_Click()
if a single record, searching for name smith
rs.findfirst("Name = 'Smith'")
if multple records
sSQL = "SELECT * FROM Customer WHERE Name = 'Smith'"
set rs = db.openrecordset(sSQL)
This will set the rs object to only Customer records where field Name = Smith
Hope it helps. :)
Sorry l keep having to any answer service calls :( if it wasn't for users this job would be so much easier. Anyway where was l, ok if you want an example project of searching a database email me at [email protected] and l will send you one. :)