ADP report does not recognized RIGHT( X,Y) OR SPACE(X) function

[Indra]

Hi There,

I am using sql database(backend) with access ADP as a front end. I
have a strange problem in one of the report in one database whereas
same report is working in another database.

I am using RIGHT (X,Y) AND SPACE(X) FUNCTION IN THE REPOT AND THIS
REPORT IS WORKING IN ONE DATABASE BUT COUND NOT UNDERSTAND IN ANOTHER
DATABASE. USED TABLE, QUERY IS SAME WITH BOTH THE DATABASE. Could any
one experiencing this type of problem. Please let me know if you have
any information.

when i run the report is say 'RIGHT' Column not found, it does not
take as a function.

Thanks for help.

Indra.

 

[MGFoster]

Common problem. Check your VBA module menu: Tools > References to see
if any library is MISSING; or, make sure a VBA library is checked in the
References.