[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 >> 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 2724 bytes
Desc: not available
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030428/ad2a27d8/attachment-0001.bin>