[AccessD] Using the pipe character in strings

John W. Colby jcolby at ColbyConsulting.com
Mon Apr 28 09:43:44 CDT 2003


Actually that is exactly what I am looking for.  I want to place the
form!myForm!MyControl into the string and have it interpreted.

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 Jim Dettman
Sent: Monday, April 28, 2003 10:22 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Using the pipe character in strings


John,

  Two things that you may be thinking of:

1. Access internally uses the pipe symbol as a place holder for where data
is to be inserted, but it does not do the actual insertion.  This appears
mostly in error messages in A2 when Access screws up and has not finished
formatting the message, but displays it anyway.

2. Access also uses the pipe symbol within a string to force an EVAL(). i.e.
"|rst![FieldName]|".  That does force an actual substitution.

  Not sure if that really helps or not, but I'd be careful of using a pipe
character with Access because of this.

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]On Behalf Of John W. Colby
Sent: Monday, April 28, 2003 9:28 AM
To: AccessD
Subject: [AccessD] Using the pipe character in strings


Long ago (in a galaxy far far away) I remember looking at the open source
libs from Microsoft.  They used the pipe symbol | to insert information into
a string.  Does anyone know how they accomplished this feat?  In short, I
need to have a string of text with dates inserted in various places.  "Blah
blah blah Date blah blah Date" etc.  Of course, being the "reusable code"
kinda guy I am, I want to do it with a pair of tables with the main text
going in the parent and the dates (or pointers to controls) going into the
child.  Pull out the parent text string, start replacing the | with child
records (dates, or contents of controls on forms).

Has anyone done this kind of thing?

John W. Colby
Colby Consulting
www.ColbyConsulting.com
-----------------------------------------------------
eMailBoss puts you in command of your email.
Get your copy today at http://www.eMailBoss.com


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


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


More information about the AccessD mailing list