Can someone explain this?

[Rican]

Hello all, I have a DB that's giving me errors. The first line that shows with an error is: CallerID = Nz(DLookup("[useridunclass]", "[tblusers", "[useridunclass] = getuser() "))

Can someone please explain what this is? Thank you.
I can't find the 'useridunclass' anywhere in the modules or tables... help!!

 

[KenHigg]

CallerID = Nz(DLookup("[useridunclass]", "[tblusers", "[useridunclass] ='" & getuser() & "'"))

???
ken

 

[Newman]

Shouldn't it just be:
CallerID = getuser()

 

[KenHigg]

Hum... Good point...

Unless, maybe, the user isn't in the table?

 

[Newman]

Well, if I refer to this:

I can't find the 'useridunclass' anywhere in the modules or tables

NONE OF the users are in the table.

 

[KenHigg]

'I can't find the 'useridunclass' anywhere in the modules or tables'

Sorry - overlooked that..

What does than mean?

 

[Newman]

Rican, the english translation for

CallerID = Nz(DLookup("[useridunclass]", "[tblusers]", "[useridunclass] = getuser() "))

is

CallerID = All the names(useridunclass) from the table "Users"(tblUsers) where the name is the same as the one you get from the "getuser" function.

So, you should have a field named "useridunclass" in the table "tblusers".
Otherwise, that code is of no use at all.

"Nz" (Null --> Zero) means that if there is no name found, you want the number "0" to be written instead of a blank.

Hope it helps you!

 

[KenHigg]

'I can't find the 'useridunclass' anywhere in the modules or tables'

I suspect there's more to this problem than a simple syntax error...

ken