Run-time Error

[esskaykay]

I’m not sure if there’s a fix for this but here’s my problem.

We have an Access DB that was originally written for Access97 by a consultant no longer in business. It has since been converted to Access2K. However, we are running it under Access 2003 (I know – confusing).

Many things are taking place here, but one of them is an import routine. However, when we run this on some newer machines we are getting a

“Run-time error 2683. There is no object in this control”.

The newer machines are running XP, the older ones still on Win2K (none on Vista). Win2K works fine, some XP boxes work. I’m not sure what’s causing this but periodically I see some reference to ActiveX. There is one line of code (Progress.Value = 0) that if remarked out appears to help. I believe this is a progress bar that appears on the screen. I don’t care if this goes away but I don’t want it to affect any other portion of the code.

Without getting too involved, it would be greatly appreciated if someone could possible point me in a direction for something to look for? I don’t even know where to begin.

Thanks,
SKK

 

[boblarson]

First, have you tried running a compile on it to see if any errors are generated?

 

[pbaldy]

When something works on one machine and not another, my first thought is a reference problem:

http://www.accessmvp.com/djsteele/AccessReferenceErrors.html

 

[esskaykay]

How do I run a compile?

SKK

 

[boblarson]

In the VBA window you go to DEBUG > COMPILE on the menu

 

[esskaykay]

I ran Compile and didn't see any errors. Does it sound possible that would only happen on XP machines? Not bing a programmer, this may be more than I can handle. I was hoping this was a simple fix but may be wishfull thinking.

SKK