User ID problem

Results 1 to 2 of 2

Thread: User ID problem

  1. #1
    Join Date
    Dec 1969

    Default User ID problem

    hey there ...<BR><BR>is there an easy way of automatically generating a userID field (for Access97) in the format of HYLA001, where HYLA is the first 4 letters of the users last name with a incremented number appended to the end. <BR><BR>any help much appreciated ...<BR><BR>

  2. #2
    12OzCoffeeCup Guest

    Default RE: User ID problem

    sure.<BR><BR>Just when you&#039re telling the formt o write to the database (with strUsername as the field) put it in like this:<BR><BR>Response.Write "HYLA" & strUsername & &#039some script here to generate the next number in sequence.

Posting Permissions

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