Hi Andy, I tried your approach on my PC and it worked perfectly. I transferred it to another PC that also has MS Access 2007 and I get an error message on the line above - saying "object doesn't support this property or method" when I run it and when I open the file it says ""There is no object...