Error Runnning Update

[ebizleads]

I'm recently moved my db to another machine running Access 2003. My old machine ran this fine on 2002:

StrConv([First Name],3)

On the new machine, I'm getting the error Undefined Function. Any clues?

Thanks,

Ebizleads

 

[dhookom]

How about providing your entire SQL view?

What happens when you try the StrConv() function in the debug window?

Have you compiled the code in your modules?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[PHV]

Check the references:
when in VBE (Alt+F11) menu Tools -> References ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886