A problem occurred while Vehicles was communication with the OLE S

[George]

Dear gurus, need your help for a crucial case…

I have developed a database about vehicles in a friends’ computer. After
completing the database I try it on my PC (I need to modify it – a lot of
modifications) and I get the following message (when I click on a command
button on the switchboard – which has some commands like docmd.openform
“frmRecordingâ€, which is a form with tabs):

“A problem occurred while Vehicles was communication with the OLE Server or
ActiveX Control. Close the OLE Server and restart it outside Vehicles. Then
try the original operation again in Vehiclesâ€

Please note that on that form I use just some simple commands onOpen,
OnActivate events, i.e. docmd.maximize.

Also I face some similar problems by using dropdown menus (lookup values)
in the several tabs of the form; ie “Microsoft Visual Basic Run-time error
2501â€

Please help…

 

[Klatuu]

This is probably a reference problem. You will need to go into the VBA
editor on the friends computer click on Tools, References and make a list of
all the references that have a check mark.

Then go home (drive carefully) and make sure the references on your computer
match his.

If you are running different versions of Windows, or you are referencing
libraries for applications where the two of you don't have the same version
or you don't have it at all, you will have some problems.

Please note: If you copy DLL's or any other files from your friend's
computer to make the application work on your computer, you will probably be
in violation of copyright laws.

 

[George]

Dear Klatuu - Thanks a million for your prompt reply,

I am having a registered version of MS-Office as far a I know - From the
help menu - Activate Product - This product has already been activated.

Dont know about my friends one yet. Try to contact him since is a lot of
kimlometers away from me (thousants). I will try to find what the references
of his PC are.

Regarding versions of Windows - we both use Windows XP.

PS: Is there any possibility my memery disk "got crazy" during all those
flights I had during the last days?

Ο χÏήστης "Klatuu" έγγÏαψε:

 

[Klatuu]

Your disk is probably okay, but I'll bet you got a little crazy.

Well, in the mean time, go ahead and go into VBA and look at the
references. If you see any marked Missing, you will need to find the correct
correct file and set the reference to it.

References are funny beasts. They are necessary for correctly communicating
with the OS and other applications. Some are even required within Access,
but those are usually already set.

If you can determine what object the code was working with when it blew up,
it should give a clue as to what the problem is.

Also, (should have mentioned this earlier) Since it is having problem with
an Active X control, it may mean you don't have it registerd.