adp report not accepting standard function.

[Indra]

Hi

I am trying to use space (x) and right(x,y) function in my adp report
but it seem adp does not recognizing the function. Displaying #Error
in the report or saying invalid columen name right and space.

Does any one have any idea why its not working.

Please let me know if you have any information.

Thanks.

Indra.

 

[John316]

From inside a code window, check the references.
you may need to add a DAO reference.
Try adding and moving it up in priority.....

hth,
bob mcclellan

 

[Norman Yuan]

They nothing to do with DAO. They are standard function in VBA Strings
module. ADP uses ADO, not DAO.
Sometimes Access (ADP or MDB) does not recognise standard functions due to
missing or bad reference(s). In VBA Editor, click "Tools->References..." to
see whether you have missing reference(s).

 

[Sylvain Lafontaine]

And how exactly are you trying to use these functions? In a SQL Statement or
inside a string as the record source of your controls or somewhere else?

The avalaible functions for SQL-Statement are not the same as those for VBA.

S. L.

 

[Indra]

Actually it is working in side the query but i need to use in report
also and it not working in report. say i have to count total no. of
employyee with leading zeros on left side.

RIGHT((100000000+COUNT(X)),8) Which should display 00000044, if the
total no of employee is 44. Its working with my another database but
not with 2nd one. Both database are same.

Thanks.