Using usernames to edit reports

[Breeves22]

Good morning to you all.

I have created a database for my company to monitor all of our cases. Within this database i use reports to create standard letters for our housing advisers to send out to clients and contractor.

What i need to do now is to find an easy way to update the name at the bottom of the letters. For example if John Doe sent a letter it would automatically put his name at the bottom but if Jane Doe sent one it would be hers.

After consulting with other members of staff they suggested individual usernames that they signed in on and the letters would update to reflect the user currently signed in. I wasnt sure if this was possible but said i would look into it. However a search on the internet did not yeild any results. So i am asking you good people if there is any possible way to achieve my goal?

Do not worry if my aim is impossible as i have a backup plan of creating a drop down box will all the staff names. WHich would be much easier to create but to make the staffs lives easier i will attempt the user name idea.

Thankyou for your time

[nico5038]

When you have the Windows login name registered in your person/email table you can use the Environ() function to detect who's logged in like:

Environ("Username")
 

Nic;o)

[NeoPa]

An alternative would be Function to Return UserName (NT Login) of Current User, but for a non-security situation Environ() would be a perfectly adequate solution.

[dsatino]

I actually have an application that derives the persons name from the NT Logon, but you need to be careful with that because for some reason (maybe just my company) there may not be an actual name attached to the logon so you may get blanks.