Results 1 to 4 of 4
  1. #1
    jpkeller55 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Sep 2010
    Posts
    169

    Message popup based on USERNAME

    Is it possible to drive a popup message box in Access 2003 on the On Click event of a control button if the username is a particular value? I tried to do something like this"
    Code:
    If Environ = "jpkeller" Then MsgBox "WELCOME JIM!", vbInformation, "Welcome Message"
    I get an error message that says: "Complile error: Arguement not optional"

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,522
    Environ("UserName")
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    jpkeller55 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Sep 2010
    Posts
    169
    Thanks Paul...I am not sure how I missed that. So the code that I am using that works is:
    Code:
      If Environ("UserName") = "jpkeller" Then
       MsgBox "WELCOME JIM!", vbInformation, "Welcome Message"
       End If

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,522
    Happy to help Jim.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Change username and password form..
    By Mrcams in forum Access
    Replies: 9
    Last Post: 12-07-2010, 11:22 AM
  2. Popup form
    By triplee23 in forum Forms
    Replies: 1
    Last Post: 10-24-2010, 04:09 PM
  3. Username For Sharepoint
    By is49460 in forum SharePoint
    Replies: 0
    Last Post: 10-08-2010, 05:40 PM
  4. Replies: 3
    Last Post: 09-29-2010, 08:31 AM
  5. request username and password
    By meysam_e2006 in forum Access
    Replies: 2
    Last Post: 07-02-2010, 02:03 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums