?
Solved

Access database questions

Posted on 2014-12-05
9
Medium Priority
?
127 Views
Last Modified: 2014-12-05
I have two tables (appointments and studentinfo).  One of my values in Appointments is a lookup from student info of the following values Student first name, Student last name, and student email. When I create a form for Appointments, and I include this lookup value, it only returns the first value (e.g. student first name) even though I can see all of the other values in the drop down.  There has to be a way to make this show everything in the lookup field.
0
Comment
Question by:mjburgard
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 3
9 Comments
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 2000 total points
ID: 40483361
You can concatenate all the other fields in the Lookup query, ...Then display the concatenated field:

For example:
SELECT StudentID, StudentFirstName & ", " & StudentLastName & ", " & StudentEmail
FROM tblStudents

Then set the Bound column as 1
Then set the Column width as something like this: 0,3
0
 
LVL 1

Author Comment

by:mjburgard
ID: 40483388
That works - I now have the issue that the person who designed this setup the email as a hyperlink - which means the email is displaying as blah@whatever.com#mailto:Blah@whatever.com#  any fast solutions for this?
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40483391
Something like this should work for you:
Database44.mdb
0
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40483392
Sorry, ...hold on...
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40483432
Try this newer sample
Database44.mdb
0
 
LVL 1

Author Comment

by:mjburgard
ID: 40483444
I wonder if it would be better to separate the email out and create a lookup that references the first studentN and is actually a hyperlink - that would allow people to click and email a record to the student.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40483484
Most experts stay away form these email formatted fields, because they can cause problems later on...
Besides, opening up an email by clicking the hyperlink field:
1. Will only work if the end user has Outlook installed as their default email client
2. Might not be possible with your networks security settings
3. Might result in errors if the email is incorrect or invalid

In my opinion, sending out emails should be an administrative function...
Not something that every user of the database should be able to do...

But I leave that up to you...


JeffCoachman
0
 
LVL 1

Author Closing Comment

by:mjburgard
ID: 40483740
Awesome, quick feedback and it worked like a charm.  Thanks
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40483764
Thanks
Enjoy your weekend
;-)

Jeff
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

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

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
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.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

801 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