 Creating E-mail Address.., ..from names stored in a database. |
Welcome Guest ( Log In | Click here to Register a free account now! )
Register a free account to unlock additional features at BleepingComputer.com
Welcome to Bleeping Computer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.  |
 Mar 4 2008, 06:46 AM
Post
#1
|
|
|
Member  Group: Members Posts: 85 Joined: 5-March 07 From: Brighton, UK Member No.: 115,537  |
I was thinking, because a majority of peoples E-Mail addresses are basically (firstname).(surname)@company.com, and I have peoples first and last names stored in the table I could write a formula or piece of VBA code to help me with this. Is there anyway of being able to do this using Access 2007 (Don't ask, we have to use it =]) Thanks in advance for anyone who can help! Dan Brownlow. |
 |
 
|
|
Mar 4 2008, 10:50 AM
Post
#2
|
|
 Hail Groovicus! Group: Site Admin Posts: 5,997 Joined: 5-June 04 From: Vermillion, SD Member No.: 689 |
If you can read a list that happens to contain names, and split those names from the list, then you can easily combine them into an email address. Use your language of choice. Depending on the length of your list, it might take longer to create the program than it would to actually just type in the names....
Moving this to the programming forum. -------------------- |
|
|
|
|
Mar 4 2008, 11:38 AM
Post
#3
|
|
|
Member Group: Members Posts: 85 Joined: 5-March 07 From: Brighton, UK Member No.: 115,537 |
What I did in the end was to use Excel, copy and paste the name's in a constantate (forgot how to spell it) into a string and then copied them back into Access. I was going to to type in but, I've got 80 entries and that could take some time. Thanks anyway.
I have another question.. Do you know how to make a custom ID for a customer using say, there first and last name? No worries but thought you might be able to lend a hand. Sorry about having to move, wasn't really sure where to put the post. Dan |
|
|
|
|
Mar 4 2008, 12:49 PM
Post
#4
|
|
|
Hail Groovicus! Group: Site Admin Posts: 5,997 Joined: 5-June 04 From: Vermillion, SD Member No.: 689 |
Do you mean a custom ID other than the id given to the entity by Access?
-------------------- |
|
|
|
|
Mar 4 2008, 02:09 PM
Post
#5
|
|
|
Member Group: Members Posts: 85 Joined: 5-March 07 From: Brighton, UK Member No.: 115,537 |
Well, I'm doing a database for a video rental shop, and within the company are 3 stores. What I wanted to have, was have a unique identifier that was say, the branch code, followed by last digits of customer name and then a number. I've tried numerous things but I can't seem to get it working.
Might just stick with something more simple lol. Thanks again. |
|
|
|
|
Mar 4 2008, 04:18 PM
Post
#6
|
|
|
Hail Groovicus! Group: Site Admin Posts: 5,997 Joined: 5-June 04 From: Vermillion, SD Member No.: 689 |
What I was trying to get at is that all relational databases have the ability to assign a unique primary key to entities, and that could serve as the unique user id. No extra steps needed, other than to add a column to the database.
-------------------- |
|
|
|
|
Mar 4 2008, 06:29 PM
Post
#7
|
|
|
Member Group: Members Posts: 85 Joined: 5-March 07 From: Brighton, UK Member No.: 115,537 |
Lol, oh sorry, yea' I knew that thanks =]
Was just trying to make it a bit more exciting for myself lol. Databases aren't my favorite part of computing to be honest. |
|
|
|
|
Mar 19 2008, 10:58 PM
Post
#8
|
|
 Member Group: Members Posts: 71 Joined: 15-January 06 From: Junee, NSW, Australia Member No.: 50,879 |
If you want something exciting switch the computer off and go abseiling or white-water rafting!!
Usually a Customer ID is the first few letters of the last name, then the initials, and maybe a number. Eg - Fred Smith might be SMIF01 The Branch name would only be usefull if you are developing the program for use in several branches - and then only if there were a real need for one branch to have access to the customers of another branch. Unless you have a very large number of clients, sorting your Database on Client Last name then the First name should give you an easily accessible list. Alan -------------------- There are 10 types of people - those who understand binary and those who don't!!
Today is the Beta version of Tomorrow! |
|
|
|
|
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:
| Lo-Fi Version | Time is now: 13th October 2008 - 12:42 PM |
© 2003-2008 All Rights Reserved Bleeping Computer LLC.