LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 130
Default Automatically generate next available user ID?

Hello folks-

I'm going to be trying to perform a task that I'm not sure if it's possible,
so i'm not looking for someone to write it for me, I just wanted to know if
something similar had already been written that I could get some perspective
from. Thank you in advance if you can point me to this!

I have a list of existing users (20,000+) in our application - and when new
users come in, we have to see if they already exist in the system by matching
name and 'group' - and if they do, we would assign them their existing id, if
we don't, we would assign them a new id.

The ids are generated simply by using first initial and last name, (I.E.
JSmith for John Smith) and if there is already a "jsmith" then we would
append with a 1 to make it "jsmith1" and so on. (jsmith2, jsmith3, etc.)

Does anyone know of any existing code written to perform this task that I
could user for inspiration?

Thank you!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I automatically generate a worksheet. genesis1923 Excel Discussion (Misc queries) 1 July 27th 09 12:14 PM
generate automatically sum Luchian Excel Worksheet Functions 6 October 8th 08 05:31 PM
Automatically generate letter svavp Excel Discussion (Misc queries) 1 July 28th 08 10:48 PM
Automatically generate user forms Rominall Excel Programming 1 March 21st 06 01:18 AM
How do I automatically generate dates? alvoons28 Excel Discussion (Misc queries) 1 June 24th 05 03:27 PM


All times are GMT +1. The time now is 12:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"