Ok so after some work I have found that what I had submitted just won't work. I did some more research and found System.IO.file.Exists() placed it in the Load event and still wont go past the first record.
Here is what I have come up with...Any help is very much appreciated.
Private Sub...
I hope this makes sense.
I am writing come code in a DB to check a link in a DataSheet to verify the file is present. Then I want to have the code change another cell to say whether it is True or False. From there I have the Conditional Formatting set to change the color of a different cell.
I...
Using CurrentUser()will only get you the current user that is logged into the DB(User, Admin). This link will help you if you are not using the DB in user setting. It will grab the current user logged into the computer as well as the computer name...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.