putting username in a msgbox

R

rglasunow

Is there a way in Access to put the user's name in a msgbox. I know i
Excel you can just write

MsgBox "Good Afternoon " & Application.UserName & "."

However, I've found in Access it's not the same. Any sugestions?

Thank you
 
P

prabha

Hi,

If you are trying to get User Name in relation to Access User Level
Security it would be

Msgbox CurrentUser

If you are trying to retrieve the Windows User name see the following
article
ACC2000: How to Retrieve Workgroup Information Under Win32
http://support.microsoft.com/?id=210088

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."


--------------------
| From: rglasunow <[email protected]>
| Subject: putting username in a msgbox
| Date: Tue, 17 Feb 2004 11:44:21 -0600
| Message-ID: <[email protected]>
| Organization: MSAccessForum.com
| User-Agent: MSAccessForum.com
| X-Newsreader: MSAccessForum.com
| X-Originating-IP: 204.238.150.159
| Newsgroups: microsoft.public.access.macros
| NNTP-Posting-Host: 69-56-172-122.theplanet.com 69.56.172.122
| Lines: 1
| Path:
cpmsftngxa07.phx.gbl!cpmsftngxa10.phx.gbl!TK2MSFTNGXA05.phx.gbl!TK2MSFTNGP08
.phx.gbl!TK2MSFTNGP10.phx.gbl
| Xref: cpmsftngxa07.phx.gbl microsoft.public.access.macros:30166
| X-Tomcat-NG: microsoft.public.access.macros
|
|
Is there a way in Access to put the user's name in a msgbox. I know in
Excel you can just write
|
| MsgBox "Good Afternoon " & Application.UserName & "."
|
| However, I've found in Access it's not the same. Any sugestions?
|
| Thank you!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top