VBA script works fine in Access excep on one pc...

[BuzzerTom]

Hi all,

I wrote some VB script in access and the scripts and my database works fine on my pc and on my laptop. both on my other pc I get some error message, altough it's also running windows xp and microsoft office 2000, just like the other two computers.

I recieve the following message:
Parameter value Trim
Parameter value Chr
#Error

Does anysthing special has to be installed on a pc to run the VB code inside an access database ? Or can it be another problem? I guess it's computer related and not to do with the VB script I wrote ?

Thanks,
Buzzer

 

[vanillapod]

could it be a references problem??? Maybe check they're the same on all PCs... the one with the error might be missing one...

 

[BuzzerTom]

Hi vanillapod,

what do you mean exactly with a references problem ?

Thanx for the reply
Buzzer

 

[vanillapod]

fi you go into a module design, click on the tools menu you'll see references, they basically tell access where to find stuff so it recognises things like trim etc...

make sure the references on your working PC are the same as on the non-working pc.

 

[BuzzerTom]

ok, thankx, I check that out !