Simple question combining first initial and last name

E

emanuel.levy

I have an Employee Table composed of 3 items
A Primay Key which is Auto Number
First Initital
Last name

I'm trying to use them in a new table where when you click on Employee
it shows the list of employees. On the initial screen it shows the
First Initial and Last name but once you go to the next field it shows
only the First Initial. How do I make it keep both displayed?
 
R

Rick B

Not sure I understand your question since you say your trying to use them
"in a new table" then you say "on the initial screen". Are you doing this
in a table or a form?

In any case, the whole point of a relational database is to store the data
in only one place, and to point to it from other places. The short answer
is that you can DISPLAY the name in any format you wish using unbound text
fields in forms, queries, and reports, but you don't store it a second time.

To show what you want in a form, add an unbound field and put the following
in it...

=[FirstInitial] & ". " & [LastName]
 
E

emanuel.levy

Ok. On the Data tab it shows

Row Source Type Table/Query
Row Source SELECT tblsafety_Employees.tblSaftey_EmployeesID,
tblsafety_Employees.[First Initial], tblsafety_Employees.[Last Name]
FROM tblsafety_Employees;
Bound Column 1
Limit to List Yes
Auto Expand Yes

I'm doing this in a Form so someone else can assign employees to tasks.
 
R

Rick B

Ok, so that selects the appropriate employee number and stores it in your
table, right?

Now, if you want to display the employee name, add an Unbound Text Box to
the right of that field and set it to show the employee name as I indicated
in my first post.
 
E

emanuel.levy

Ok I semi understand. I'm using the following code now for Row Source

SELECT tblsafety_Employees.tblSaftey_EmployeesID,
tblsafety_Employees.[First Initial] & "." & tblsafety_Employees.[Last
Name], tblsafety_Employees.[Last Name] FROM tblsafety_Employees;

When I look at the records in the Form it shows the First Initial and
last name which is perfect. When I manually look at the employer table
it shows the first initial which is fine

Howver when I am using the form to enter employer info I have having a
problem. When I click on the drop down to get the list instead of
showing something like

K | Clarkson
M | Jackson
P | Gabriel
B | Joel
E | John


It shows

K.Clarkson | Clarksson
M.Jackson | Jackson
P.Gabriel | Gabriel
B.Joel | Joel
E.John | John

What did I do wrong to cause that?
 
R

Rick B

This should work exactly like the "Salesperson" field in the Northwinds
ORDERS form and table. Take a look at how it works and see if that helps.
I'm not following your post very well. I must be a bit fuzzy today.

Maybe someone else can jump in and see what I'm missing.
 
R

Rick B

Ah sorry. It ships with the application. It is on the CD. You might be
able to get it on the Microsoft website. I've never looked.


--
Rick B



Would this Northwinds Orders form and table be on the Microsoft site or
Click to expand...
 
E

emanuel.levy

I didn't find it on the Microsoft site. Out system tech won't install
the sample file. Is there any chance you can either e-mail me or put
the file on a site I can get it from.
 
F

Fred Boer

Hello:

Go to www.microsoft.com.
Enter "Northwind traders" in the search box on top right.
The sixth link listed in the results will take you to a page where you can
download the file for Access97.
The seventh link listed in the results will take you to a page where you can
download the file for Access 2000 (this will work in Access XP and 2003).
or...

The exact link is (watch for word wrap):

http://www.microsoft.com/downloads/...c8-b91a-4603-8467-20215e441528&displaylang=en

http://www.microsoft.com/downloads/...72-8dbe-422b-8676-c632d66c529c&displaylang=en


HTH
Fred Boer
 
E

emanuel.levy

I just noticed it's displying the full name in the field but on the
drop down it is limiting the display to 5 letters for the last name how
do I fix that?
 
Top