[AccessD] Using the pipe character in strings

Charlotte Foust cfoust at infostatsystems.com
Mon Apr 28 18:19:56 CDT 2003


I've run into problems with pipes used in controlsource properties.
They worked in 97 but broke completely in 2000/2002.  They were someone
I had never used anyhow, but there were some in our application when I
converted it.

Charlotte Foust

>  -----Original Message-----
> From: 	accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]  On Behalf Of Jim
> Dettman
> Sent:	Monday, April 28, 2003 10:54 AM
> To:	accessd at databaseadvisors.com
> Subject:	RE: [AccessD] Using the pipe character in strings
> 
> John,
> 
>   I'd use Eval() and concatenate rather then a pipe character.  That
> way you can use it anywhere.  Pipes only work in an SQL string if I
> remember correctly.
> 
> Jim Dettman
> President,
> Online Computer Services of WNY, Inc.
> (315) 699-3443
> jimdettman at earthlink.net 
> 
> 	 -----Original Message-----
> 	From: 	accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] 
> 	Sent:	Monday, April 28, 2003 1:09 PM
> 	To:	accessd at databaseadvisors.com
> 	Subject:	RE: [AccessD] Using the pipe character in
> strings
> 
> 	Yep.  But I am trying to make it table driven.  Which means the
> "Forms!myForm!MyControlDate.Value" has to be interpreted first, i.e.
> that exact string will be saved in a table and be pulled out of the
> table, interpreted to a date (or other value) and dropped into the
> string.
> 
> 	John W. Colby
> 	Colby Consulting
> 	www.ColbyConsulting.com
> 
> 	-----Original Message-----
> 	From: accessd-bounces at databaseadvisors.com
> 	[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Gustav
> Brock
> 	Sent: Monday, April 28, 2003 11:10 AM
> 	To: accessd at databaseadvisors.com
> 	Subject: Re: [AccessD] Using the pipe character in strings
> 
> 
> 	Hi John
> 
> 	I wonder how you have spent the weekend ... ??
> 
> 	> Actually that is exactly what I am looking for.  I want to
> place the
> 	> form!myForm!MyControl into the string and have it interpreted.
> 
> 	> .. In short, I need to have a string of text with dates
> inserted in
> 	> various places.  "Blah blah blah Date blah blah Date" etc. ..
> 
> 	So:
> 
> 	strColby = "Blah blah blah " & Forms!myForm!MyControlDate.Value
> &
> 	           " blah blah " & Forms!myForm!MyControlDate.Value & ""
> etc.
> 
> 	You may need to wrap the values in Format().
> 
> 	/gustav
> 
> 	_______________________________________________
> 	AccessD mailing list
> 	AccessD at databaseadvisors.com
> 	http://databaseadvisors.com/mailman/listinfo/accessd
> 	Website: http://www.databaseadvisors.com
> 
> 
> 	-----------------------------------------------------
> 	eMailBoss puts you in command of your email.
> 	Get your copy today at http://www.eMailBoss.com << File:
> ATT00002.txt >>  << File: ATT10553.txt >> 


More information about the AccessD mailing list