Search results

Yes, unless I'm missing something else, the references look "ok" to me

Nope, issue has cropped up again. It's totally intermittent.

Thanks, I checked another database as well and was missing an Active X 6.1 reference. The database ran without issue for the first time. I'll continue testing it though Many Thanks :)

OK thanks, I'll take a look. How do I know what is missing/what is needed?

All that is fine, this used to work perfectly, the only thing that has changed is the version of Access I have to use. I haven't renamed anything. It is an intermittent problem, so it works some time, it doesn't work sometimes Thanks

Hi, tried the .activate instead of .select and this does not work either, I get the same Runtime Error 9 Subscript out of Range

Hi All Relatively new to MS Access. Was using 2010 without any issues until work decided to upgrade us to 2013. The main problem I have at the moment is that when the database is starting to output our reports to Excel it seems to get stuck on selecting a sheet in the Excel spreadsheet to paste...