VB Libary components

[Eckerslike]

Hi,

I have made a database for use by some of our sales and marketing team whom all have laptops. The database works fine on my PC, but when I try on their Laptops they do not appear to have the correct VB library's installed. The follwing does not appear to work:

Transferspreadsheet
Date
Left([Field], 2)
Right([Field],2)

There may be others also, but these are the ones that have not worked so far.

I can probably get our IT Helpdesk people to reinstall it on their Laptops(in about 6 months time) with the correct options selected, but as a quicker measure, does anyone know which .dll or .ocx are used by access, so that I could just send them a copy of mine, to see if that resolves the problem.

Any help would be much appreciated,

Cheers

 

[ghudson]

You have a typical "reference" problem. Search around for it is a common problem with an easier yet manual fix that you have to do to each PC. Is everybody using the same version of Office? Did you have to convert the mdb file to another version for the users? Are you using any Office components or ActiveX objects [calander, find file, etc]? First off you should check which references the users PCs are missing and just reselct them but the user will have the same problem the next time you give them an updated version of your db.