Does anyone know how to rank scores in a form by using VBA coding? I have seen examples of ranking tables using queries, but when I tried this it didn't seem to work as the data seemed to become read only all of a sudden and I couldn't work out why. I've seen a couple of VBA examples on this forum, like this one:
http://www.access-programmers.co.uk/forums/showthread.php?threadid=34924&referrerid=12934
but when I copied the code into my DB and changed (what I thought were) the necessary paths it didn't work.
http://www.access-programmers.co.uk/forums/showthread.php?threadid=34924&referrerid=12934
but when I copied the code into my DB and changed (what I thought were) the necessary paths it didn't work.
