VersionChecking

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

I want my front end mde's to check the version of the
database that the users are opening.

I have a linked table called VersionCheck. It has 3
feilds. ID, DBName, Version.

for example:

ID = 1
DBName = attendance
Version = 2.01

So I want to put vba code into the MDE so that when it
opens...it checks to see if it is the latest version. If
it's not, it will throw up a msg box telling the user that
there is an updated version of the MDE.

I just don't know how to reference table data in VBA. I
thought it would be quite simple..But I still can't figure
it out.

Any help would be appreciated.
 
You can use a DLookup() function for example:

debug.print DLookup("Version", "VersionCheck","ID=1")
will return
2.01
 
Back
Top