Search For database object

[vicky666]

If I enter a memberid into a text box I need to be able to see if it exists in an access database. Basically a comparison string cheers

 

[Vec]

Try something like this to get you started, this method will move the recordset to the entered memberid, if it doesn't exist then it will tell you:

This assumes that you named your data connection Data1 and the fld name being searched is named memberid


With Data1.Recordset
varBookmark = .Bookmark
.Index = "memberid"
.Seek "=", Text1.Text
If .NoMatch Then
.Bookmark = varBookmark
End If
End With
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning."
-- Rich Cook.

http://www.webfusiondesign.com

 

[vbkris]

if thats confusing then use this:
sql="select from table where memberid='"+text1.text+"'"
recordset.open sql,connection
if recordset.eof and recordset.bof then
msgbox "Id not found."
else
'do code here for the id.
end if Known is handfull, Unknown is worldfull