[mso] Re: Access Help

BINGO!!!

Thank you, thank you, thank you! ;-)

(HA...now I can go back to the Access MVPs who weren't able to help me
fix it and tell them how YOU did!<hee, hee>)

And I had another, similar, field that was messing up about the same
way. Now I can fix that one, too. I'm so happy! <g>

Dian Chapman
Technical Consultant, Instructor,
Microsoft MVP & TechTrax Editor

Word AutoForm/VBA eBook: http://www.mousetrax.com/books.html
Tutorial web site: http://www.mousetrax.com/techpage.html
TechTrax Ezine: http://www.mousetrax.com/techtrax/

-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Colli, Anthony G
Sent: Monday, November 25, 2002 11:08 AM
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Re: Access Help


Dian-

 I just reread your original post, maybe when using the lookup wizard
concatenation is not a legal operation. It's just a guess. 

 As a test open a new query and try the query in SQL view if it works as
a standalone query then the problem might be with using a lookup as a
datatype.

 Disregard all the above it can be done. Try this SQL

SELECT [TrainingStudents].[StudentID], [TrainingStudents].[FName] & " "
& [TrainingStudents].[LName] AS name FROM TrainingStudents; 

When in table design view the lookup tab, the row source click the ...
and paste the above SQL into the SQL view. click the ! to see the
result. It will hopefully work.

then in the properties of the lookup set this:

set the bound column to 1
set the column count to 2 
set the column heads to no
set the column widths to 0";1"

that should do it

-Anthony



*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx
or MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe

Or, visit the group's homepage and use the dropdown menu.  This will
also allow you to change your email settings to digest or vacation (no
mail). http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group,
send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an
invitation with instructions.  Once you are a member of the files group,
you can go here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: