Why not to use user function?
 
select user from dual
 
should list username for current session.
 
Mark Brown
Product Management, AgileInfoSoftware
 
----- Original Message -----
From: eliotchs
Sent: Wednesday, August 17, 2005 11:49 AM
Subject: [AccessDevelopers] selecting a value based on Environ("USERNAME")

Hi,

Does anyone know how I can base a value on a dataentry screen on a
Environ("USERNAME") from a user table?

Example:
usertable has username and locationcode,
depending on who logs in the LocationCode on another table gets the
value on Location on the Usertable?

Thanks in Advance






Please zip all files prior to uploading to Files section.




YAHOO! GROUPS LINKS




Reply via email to