Recent content by rsimons

Thanks guys for the follow ups. Firstly, the new error was associated with the same line of code. I had the Dim outside but moved to within the loop. If I move to outside the loop the error is the same. I moved to within the look because I tried recreating a couple of incremental variables...

Thank you sadly I receive another error.

Hi I get a compile error: Method or data member not found cheers Roland

Sorry - I thought it was a common error..... Error 462: The remote server machine does not exist or is unavailable It comes about often on a rerun (first run of report is good and second report hits the error) due to In this scenario, Access is the client and Word acts as the server...

Hi all I am a new user here but have been using VBA for a while. I am a bit stumped by the 462 error I keep getting. I was wondering if there would be a genius who could see through my code (posted below). Before I get to the code it is rerunning 10 reports by extracting data from Excel to...