ACCESS FEED: Re: RE: [MS_AccessPros] how to show the itinerary horizontally like this: Paris-Tours-Dijon in the unbound text box in the mainForm.

Minggu, 20 September 2015

Re: RE: [MS_AccessPros] how to show the itinerary horizontally like this: Paris-Tours-Dijon in the unbound text box in the mainForm.

Duane-

I forgot to use an actual ID to get function work. Thanks a lot for your help!

Best Regards,

Kevin

From: Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals]
Date: 2015-09-20 12:35
To: Access Professionals Yahoo Group
Subject: RE: [MS_AccessPros] how to show the itinerary horizontally like this: Paris-Tours-Dijon in the unbound text box in the mainForm.
Kevin,

You can use the generic concatenate function found at http://www.tek-tips.com/faqs.cfm?fid=4233 to return the values in one expression.

Duane Hookom, MVP

MS Access

________________________________

> To: ms_access_professionals@yahoogroups.com

> From: MS_Access_Professionals@yahoogroups.com

> Date: Sun, 20 Sep 2015 08:02:54 +0800

> Subject: [MS_AccessPros] how to show the itinerary horizontally like

> this: Paris-Tours-Dijon in the unbound text box in the mainForm.

>

>

>

> Dear All,

>

> I have a subform called "subItinerary" attached to frmMain, in the subform there is list of itinerary like this:

>

> frmMain

> "Itinerary": unbound text box

>

> subfrom: subItinerary

> ItineraryID Date City

> 1 25-Sep-2015 Paris

> 2 26-Sep-2015 Tours

> 3 27-Sep-2015 Dijon

>

> My question is how to show the itinerary horizontally like this: Paris-Tours-Dijon in the above unbound text box. I uploaded the access file to group file 2_AssistanceNeeded. Please help. Thanks in advance.

>

> Best Regards,

> Kevin

>

>

> ________________________________

> Regards,

> Kevin Zhao

>

>

>

------------------------------------

------------------------------------

------------------------------------

Yahoo Groups Links

<*> To visit your group on the web, go to:

    http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:

    Individual Email | Traditional

<*> To change settings online go to:

    http://groups.yahoo.com/group/MS_Access_Professionals/join

    (Yahoo! ID required)

<*> To change settings via email:

    MS_Access_Professionals-digest@yahoogroups.com

    MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:

    MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:

    https://info.yahoo.com/legal/us/yahoo/utos/terms/