Problem with common VBA functions when installing a new system

[Grant]

I would be grateful for some help with the following problem.

I have recently written a small system in Access 2007 which works fine on my
laptop.

Having installed it on the user's PC, his system does not recognise common
functions such as LEFT, TRIM and MID which I have used in some VBA
procedures. It also apparently fails to recognise the DATE() function in a
query to select outstanding invoices.

I have compared the References on the 2 machines and the only difference
seems to be that the customer's PC is missing the reference to AolCalSvr 1.0
Type Library. I cannot find the corresponding file - MyCalendar.dll - on the
customer's PC.

Oddly enough, the Activex calendar (to which this file relates ?) works as
it should.

Can anyone please explain why the user's PC fails to recognise perfectly
standard functions such as LEFT and how to solve this problem.

Thanks

 

[fredg]

I would be grateful for some help with the following problem.

I have recently written a small system in Access 2007 which works fine on my
laptop.

Having installed it on the user's PC, his system does not recognise common
functions such as LEFT, TRIM and MID which I have used in some VBA
procedures. It also apparently fails to recognise the DATE() function in a
query to select outstanding invoices.

I have compared the References on the 2 machines and the only difference
seems to be that the customer's PC is missing the reference to AolCalSvr 1.0
Type Library. I cannot find the corresponding file - MyCalendar.dll - on the
customer's PC.

Oddly enough, the Activex calendar (to which this file relates ?) works as
it should.

Can anyone please explain why the user's PC fails to recognise perfectly
standard functions such as LEFT and how to solve this problem.

Thanks

It most probably is a missing reference. While you may show the same
references as the other machine, the one that isn't working may have
lost it's file location.
Open any module in Design view (or click Ctrl + G).
On the Tools menu, click References.
Click to clear the check box for the type library or object library
marked as "Missing:."

If none are marked Missing, I would suggest you follow the complete
instructions here:

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

 

[Grant]

Fred

Thank you for the prompt reply.

I am travelling on business for some days and it will be Monday (11
September) at the earliest before I will be able to get at the user's PC, but
I appreciate your advice and the link to a detailed explanation of how to fix
reference problems.