Solved

Use of Pipe symbol as Text

Posted on 2002-03-07
6
756 Views
Last Modified: 2010-05-18
I have a database that uses a bar-code reader to input data.  The barcode uses the Pipe symbol "|" as a delimiter between data segements.  I wish to query data out of an Access DB and place the pipe in the string using something like the following:

BarCode: "TEXT" & [TableName].[Field] & "|" & [TableName2].[Field]

Access will not let me enclose the Pipe in quotations to represent it as text.  I get the error "The expression you entered has an invalid string". Virtually any other symbol or character I enclose in the quotations will work and print as text in the string.  But not the Pipe?!?!

Any Suggestions??
0
Comment
Question by:JohnValue
  • 3
  • 2
6 Comments
 
LVL 6

Accepted Solution

by:
xSinbad earned 50 total points
ID: 6848492
Have you tried using chr(124) in it place?
0
 
LVL 7

Expert Comment

by:lmerrell
ID: 6848508
Instead of using "|" in your code use Chr(124).

BarCode: "TEXT" & [TableName].[Field] & Chr(124) & [TableName2].[Field]

lmerrell
0
 
LVL 7

Expert Comment

by:lmerrell
ID: 6848511
Sorry, xSinbad.  I just got through finding the chr equivilant of |.  :-)
0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

Author Comment

by:JohnValue
ID: 6848524
Thanks!!!

I say the character set 124 but did not know how to insert it.

You-da-man!
0
 
LVL 6

Expert Comment

by:xSinbad
ID: 6848545
lmerrell I was lucky I have Hex Workshop so I put a pipe in a txt file and opened it with Hex Workshop and there it was.

Any time JohnValue.
0
 
LVL 7

Expert Comment

by:lmerrell
ID: 6848559
I had to open Access and invoke the debug window and put in:

?asc("|")

I just took a minute to think of doing it that way.
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question