Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004
    Posts
    18

    Question Unanswered: This should be easy - I hope

    I need to use a form to collect the users Firstname, Lastname and create a LoginName formated as Lastname,F initial.

    Firstname = Roger
    Lastname = Ramjet
    LoginName = Ramjet,R

    or

    Firstname = roger
    Lastname = ramjet
    LoginName = ramjet,r

    Please see the example attached.

    Thanks in advance.
    Attached Files Attached Files

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    And what is your problem????

  3. #3
    Join Date
    Mar 2004
    Posts
    18
    What I need is when tabbed into the LoginName fields, the LoginName will auto populate.

    Field1 - Firstname = Roger
    Field2 - Lastname = Ramjet
    Field3 - LoginName = Ramjet,R auto populated based on whats entered in fields 1 & 2.

    Hope that helps.

    Originally posted by M Owen
    And what is your problem????

  4. #4
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,423
    Provided Answers: 8

    Bob_g7

    Base on your Attach DATABASE I would

    Just

    Code:
    Private Sub Lastname_AfterUpdate()
    Me.LoginName = Me.Firstname & "," & Left(Me.Lastname, 1)
    End Sub
    Will need to add some error checking?
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  5. #5
    Join Date
    Mar 2004
    Posts
    18

    Talking Re: Bob_g7

    Great, thanks that worked just right. Now on to bigger and better things. I'll post then later.

    Originally posted by myle
    Base on your Attach DATABASE I would

    Just

    Code:
    Private Sub Lastname_AfterUpdate()
    Me.LoginName = Me.Firstname & "," & Left(Me.Lastname, 1)
    End Sub
    Will need to add some error checking?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •