Recent content by JVanDyne

Thank you. I will try that. I am using the 2000 version. I have this database at work, have to try it on monday. Again thank you.

Thank you all for your help. However the string is a files location, so there are multiple "\"'s ex: C:\Drive\Folder\Subfolder\File I am trying to extract just the file name, after the last "\". The amounts of "\"'s could vary sometime to time. James

I am string to get read a string value from right to left up to a certain character. I can't seem to get it to work. Does anybody know what i may be doing incorrect? Here is some of the code: strTable = InputBox("What table do you want to import the file to?", "Professional File Load") If...