Comparing records via VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to be able to make sure all my users are using the same front end
copy. What I did is create a table in the back end and one in the front end
that stores a version number. I want to compare both version numbers and if
they are not equal then perform some action. The below code seems to work but
I dont know enough if I am doing it right or wrong. Please steer me in the
right direction if I am off track.

Function VersionTest()
Dim Test1 As String
Dim Test2 As String
Test1 = DLookup("version", "TblVersionClient", "version <> null")
Test2 = DLookup("VersionNumber", "TblVersionServer", "VersionNumber <> null")

If Test1 = Test2 Then
MsgBox "Matches"
Else
MsgBox "No Match"
End If

End Function
 
You cannot use equality or inequality operators in conjunction with Null.

Test1 = DLookup("version", "TblVersionClient", "version Is Not Null")
Test2 = DLookup("VersionNumber", "TblVersionServer", "VersionNumber Is Not
Null")
 
Back
Top