Wot! No Function Name????

[TooChoosy]

PLease Help. I am create a Db for a local taxi company. Everything was going ok until I downloaded the 1st version onto the companys own pc.
A function that creates a booking number would not 'function' and caused an error:-

"The expression you entered has a function name that cannat be found".

The function is :-
Left([customername],3)+trim((str([id])

E.G. Smith, 416 would become "Smi416" as the booking number.

This is run in a macro and it doesn't even get past the 'Left' function.

I know the function exits on the companys pc as i have tried a seperate calculation to find this out. So what is happening?

any help would get a biiiig thanx coz right now I look like a !*?

 

[IMO]

Check that no references are missing

IMO

 

[boblarson]

It's definitely a MISSING REFERENCE and it would most likely be the one referencing Comctl32.ocx

 

[IgorB]

Open your .mdb file on every user machine, get VBA code window and uncheck MISSING in Tool-->References.