Hello All -
I have a quick question that I need help with. I am a VB.NET programmer and don't know much about VBA....
I have two tables - first table has a column with file names, a column with file names after being renamed and a status column...
Second table has a column with new file names.
(I have a directory that I renamed each file with a unique name 0000001.tif, 0000002.tif, etc....)
All I need to do is create a button on a form that will look at table 2 and if the file name is there it will update the status column on table 1 (I have all 0's in it and if the file name on table 2 is there then the status field will change from 0 to 1).
Hope this makes sense.
Can anyone help?
Thanks in advanced