Left fonction doesn't want to work

[aleathiel2005]

Hi all,

I have a query that need a left function. The field is as follow:

SHIPPING3: Left([SHIPPING_INSTR],3)

It was working at my work, but when I tried to opened the query at my house with access 2003, it gave me the following error message:

Undefined fonction 'Left' in expression

Someone know why it does that and if there is a way to correct it? Every fonction that i tried like left, right or format wasn't working anymore, it was kind of pathetic

Thanks for your help!

Alea

 

[PHV]

Seems like a reference issue:
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

 

[SkipVought]

Hi,

Are you querying to a LINKED table? Maybe Oracle or DB2?

The use the Substr function
[tt]
SHIPPING3: Substr([SHIPPING_INSTR],1,3)
[/tt]
Alternatively, you may be missing a VB library -- reload Access

Skip,

_{[red]Be Advised![/red] For those this winter, caught in Arctic-like calamity, be consoled...
Many are cold, but few are frozen!}

 

[aleathiel2005]

Thanks for the fast response!

Seem like I'm missing some rence, where can i get them?

 

[aleathiel2005]

When you say relaod access you mean uninstall and reinstall everything?

 

[PHV]

where can i get them?
WHICH ?

 

[aleathiel2005]

MSCOMCT2.OCX

 

[PHV]

Have a look here:

http://support.microsoft.com/default.aspx?scid=kb;en-us;297381

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

 

[aleathiel2005]

thanks a lot for all this information, I'm ok now with your great answer, hope i can help you someday (when I will be even better in access)

Alea

 

[lespaul]

We all hope to be able to help PHV SOMEDAY, however, I don't expect to actually accomplish it in my lifetime.

Leslie