Record match in Access_97

[Linus_99]

Can someone pls assist with VB code that will work in Access 97 as well.

I need to get a name in an input box, and then check whether that name appears in a specific field in a specific table (i.e. FamilyName within Emptable). I need to be able to find out how many exact matches there are (or if there is no match at all) for the name.

I'm working in Access 2002, but this needs to work in 97 as well.

Thanks.

 

[Russell Hauf]

You can use the DCount function.

How about this:<pre>
Public Function GetNameCount() As Integer
Dim strName As String

strName = InputBox("Enter Name", "MyDB")
intEmp = DCount("[FamilyName]", "Emptable", "[FamilyName] like '*" & strName & "*'")

End Function</pre>

Then you can call this function something like this:<pre>
If GetNameCount > 0 Then
' It was found
End If</pre>
HTH,

Russell
This message was edited by Russell Hauf on 2002-12-08 18:21

 

[Linus_99]

Thanks Russell,

Works fine for me !!