Ambiguous Name Detected

[Crampton]

Hi all

I am trying to run a code that picks up the username to show on an Audit Trail, however the following message has now started appearing and i can tfor the life of me work out why.
Im very new to Modules etc.

UserName = Left(lpBuff, InStr(lpBuff, Chr(0)) - 1)

it highlights "Left" as the guilty party !!

Can anyone out there explain to me please, what Left is and maybe why is it showing as an error.

Many thanks

 

[ColinEssex]

however the following message has now started appearing

Whats the message then?

From Access help about the Left function...

"Returns a Variant (String) containing a specified number of characters from the left side of a string."

Col

 

[Hayley Baxter]

Check that you don't have any naming conflicts, that's what usually causes this error.

Hay

 

[Crampton]

Hey

Thanks Hayley and Colin, I found it, it was a naming conflict.

Thanks for your help.