Macro Problem

[Lyndseyd]

Hi all,

I usually search for the answers to my problems, but as im not sure what the problem is i havnt been able to do so here.

Basically i have a pretty simple database, it works fine in the UK. The company i have designed it for are moving to Budapest, i have just had an email this morning saying an error message pops up when the try using a form, i have attached the message. The macro just runs a query based on a table in the database asking the users to choose a record number edit. Im assuming it must be something to do with is being used in Budapest as it works fine here, but they are accessing it the same as they would do here, just from a different location.

Any help would be appreciated, thanks

 

[namliam]

I have found that I get freaky errors like this if the references are not correct.

Make sure you are running the same version as they are of the same installation.
I.E. If you need DAO 3.6 referenced but for some reason they dont have it or are running DAO 3.5. You have a problem.

Tho I dont use Macro's myself, I have had errors in VBA saying "cannot find the function Right" which is downright dumb.
It turned out to be a problem with references... So I would check up on that.

 

[Lyndseyd]

How can i check the refererences? In Budapest they just access the database from the server we have here, the same server which the current employees access the database from here. Everything is used exactly the same except it is just being used in a different country, im not really great with access, so as much help would be appreaciated. Thanks

 

[namliam]

The simplest way to make sure this is not the issue, is to call them up and talk them thru it....

 

[Lyndseyd]

Talk them through what though? I don't want to sound stupid, but ive never heard of the references before, so im not sure what i should be talking them through.

Ive been searching for references so may find something there...thanks

 

[namliam]

In the module window (ALT+F11)
Then Tools => References....

The popup window should then have one saying "Missing:"

But I am guessing a little here, nothing sure about it... that this is your problem... But might be...