It's actually not mine, it was from my relative in the US. And it's not that simple as I throught.
Also, the Access database was written in Access 97. Last night when I opened it in Access 2000, it has some errors/problems. I believe that is because of the incompatibility between Access 97 and 2000. So some of the vba function will not work.
If someone can modify the code to make it work on Access 2000 that will be great. I don't have time to look into the code. Also, if someone makes the modification, could you send it back to me so I can post it on the same place? Thanks!
Also, the Access database was written in Access 97. Last night when I opened it in Access 2000, it has some errors/problems. I believe that is because of the incompatibility between Access 97 and 2000. So some of the vba function will not work.
If someone can modify the code to make it work on Access 2000 that will be great. I don't have time to look into the code. Also, if someone makes the modification, could you send it back to me so I can post it on the same place? Thanks!