Access database query

Computing.Net > Forums > Database > Access database query

Original Message

Name: mullen103
Date: November 9, 2007 at 13:11:10 Pacific
Subject: Access database query
OS: 98se
CPU/Ram: p 2

Comment:

Hi
I have a reference table created from global adress list in outlook it has alias in it. I have created a table and want user to input alias and it automatically fill in data for surname and Forename.
Is this posible I do not want to link my tables to the address list as there is data that will not be used
Thankyou
www.mullen103.com

Report Offensive Message For Removal

Response Number 1

Name: Jennifer SUMN
Date: November 9, 2007 at 16:25:41 Pacific
Subject: Access database query

Reply: (edit)

Where are the names stored? Do you want the user to enter the data into a field, or into a form based on a query?
Life's more painless for the brainless.

Report Offensive Follow Up For Removal

Response Number 2

Name: mullen103
Date: November 10, 2007 at 02:14:16 Pacific
Subject: Access database query

Reply: (edit)

The names are stored in another table just a reference one. I want the user to input a number in one field then the surname and forename appear automatically in the fields in the tables. I have done no forms or queries yet.
www.mullen103.com

Report Offensive Follow Up For Removal

Response Number 3

Name: Jennifer SUMN
Date: November 10, 2007 at 14:12:34 Pacific
Subject: Access database query

Reply: (edit)

Proper database structure is to store data in one table only. Why do you want the data duplicated? Redundancy is not really good database design.
What exactly are you going to do with the database?
Life's more painless for the brainless.

Report Offensive Follow Up For Removal

Response Number 4

Name: mullen103
Date: November 11, 2007 at 05:19:02 Pacific
Subject: Access database query

Reply: (edit)

I would not really call it redundancy as its not linked to the database. I do not want to link it because there are names that are not going to be used in the database.
www.mullen103.com

Report Offensive Follow Up For Removal

Response Number 5

Name: Jennifer SUMN
Date: November 11, 2007 at 15:10:03 Pacific
Subject: Access database query

Reply: (edit)

What isn't linked to the database? Perhaps you could be a little more clear exactly what you're using the database for, and what the ultimate goal is.
Life's more painless for the brainless.

Report Offensive Follow Up For Removal


Convert Excel to Access database Access Query to Merge with Word Doc Inner joins in MS Access convert access to mySql ACCESS Record Merge	summarising in access-using query How to access local database? Linking Access tables over Internet attaching files/linking in access creating a database for a game

MS Access SQL query

Setting up WAMP

Use following form to reply to current message:

Name: From My Computing.Net Settings E-Mail: From My Computing.Net Settings Subject: Access database query

Comments:

  Homepage URL (*): 
Homepage Title (*): 
         Image URL:

How often do you use Computing.Net?

Poll Finishes In 2 Days.
Discuss in The Lounge

my lj p2015n printer wont install

Can I change this?

Philips adds new Pronto uber touchs

filename concatenation

Second SATA drive problems

All Posts Awaiting Replies