Solved

how do I make the lastname and first show

Posted on 2011-03-08
7
339 Views
Last Modified: 2012-05-11
How do I make the last name and first name show in the box with red circle around.  See attached. screen screen
0
Comment
Question by:Kdankwah
7 Comments
 
LVL 17

Expert Comment

by:Barry Cunney
ID: 35073754
If the box you are referring to is a combo box the for the rowsource query you need a expression field in the query which concatenates the forst name and last name from the separate first name and last name fields in the relevant underlying table - In Design select box and press F4 for the poperties
0
 

Author Comment

by:Kdankwah
ID: 35073779
This is the syntax I am using on the field.  I need to get it to read first and lastname together

SELECT [Contacts Extended].[Last Name], [Contacts Extended].[First Name], [Contacts Extended].ID
FROM [Contacts Extended]
ORDER BY [Contacts Extended].[Last Name], [Contacts Extended].[First Name], [Contacts Extended].ID;
0
 
LVL 19

Expert Comment

by:Eric Sherman
ID: 35073821
In your ComboBox, what is the Bound Field (Employee ID, Last Name, etc.)???

Can you upload a sample db in Access 2000 format???


ET
0
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 

Author Comment

by:Kdankwah
ID: 35073892
Its bound to last name, but I can change to ID.
0
 
LVL 19

Expert Comment

by:Eric Sherman
ID: 35074430
<<<<<Its bound to last name, but I can change to ID.>>>>>>

What do you need it to be??

Can you upload a sample ...  will probably make it a lot faster.

ET
0
 
LVL 19

Expert Comment

by:Eric Sherman
ID: 35074557
Also, I would change the Bound Field to a Unique ID field so you will handle duplicate last names properly.

ET
0
 
LVL 6

Accepted Solution

by:
JVWC earned 500 total points
ID: 35080575
You'll need to change the layout of your combo for the different nomber of columns...

Something like:

SELECT [Contacts Extended].[Last Name] & " " & [Contacts Extended].[First Name] AS FullName, [Contacts Extended].ID
FROM [Contacts Extended]
ORDER BY [Contacts Extended].[Last Name], [Contacts Extended].[First Name], [Contacts Extended].ID;

Cheers
JC
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Launch app from Access custom ribbon 8 33
Column Layout in Access Xp VBA Report 3 19
trying to catch ODBC error when database opens 2 28
Criteria for Date for DCount 4 26
This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question