Solved

how do I make the lastname and first show

Posted on 2011-03-08
7
340 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
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
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…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

830 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