Recent content by IainIDI

wow - so surprising how sometimes the most simple fix works :) SOLUTION: Update Full office install and runtime install Many thanks for your help, problem solved!

Also, I've been trying to probe the underlying reasons that this is happening. For whatever reason, there is a subtle difference between the full version of Access and the runtime with the handling of the recordset.open command. Does anyone know of any differences between full Access and...

Still works in full access, still blows up in runtime :( Thanks for all the help guys, really hoping we can get to the bottom of this

I'll give it a go now

I didn't write the code so I dont know why its there - the variables check out. I'm just reluctant to remove variables when I dont know why they were put there in the first place. If I cant come up with another fix I'll certainly try it though. Thanks for the responses :)

I have, this self-same code works with the full install of access 2007 and previous versions of Access.

Hey, I'm having this same problem porting my companies software to Access 2007 runtime. The code works fine on the full install of Access 2007 but errors on runtime. Is there anyone that can make any suggestions of what to try do? Either work arounds or fixes! I've narrowed it down to this line...