Database Help!

[Smie]

How can I search a database?

[jritchie]

Search the database for what ? What database format ? If record set could use SQL.

[Smie]

Im not used to databases. But i need to search for a certain record.

[jritchie]

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.

[jritchie]

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.