MEmory Variables

[Eliasgitau]

Hi all! Here's what I'm trying to do and I'm having a hard time figuring it out. I have a login in a database. I would like to capture the login name to a memory variable called wuser. then i use it to filter records in various forms and reports. I was able to filter data using currentuser() function since i have stopped using workgroup security file to use a table and a form. this was the way was filtering.

wuser = CurrentUser()
wuser = UCase(wuser)
If wuser = "RN" Then
DoCmd.OpenForm "JobSystemcreation", , , "projectcoordinator='RN'"
endif

 

[PHV]

Have a look at the DLookUp function.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[gwinn7]

Dlookup works, but in the long term, you should create your own alternative, or steal one from the Internet, like elookup. Dlookup really sucks for more involved operations.

Gary
gwinn7

 

[TheAceMan1]

[blue] . . . Dlookup really sucks for more involved operations.[/blue]

An academic quote since [blue]Eliasgitau[/blue] hasn't presented anything that requires [purple]a more involved operation![/purple]

[blue]DLookup[/blue] is just fine!

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[gwinn7]

Aceman,

Ummm. Duh!!!

I was just being informative in case some bright eyed Access Developer decides Dlookup is actually a good function to use!

Gary
gwinn7

 

[TheAceMan1]

gwinn7 . . .

[blue]Everyone's entitled to their opinion! . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886