Improve company productivity with a Business Account.Sign Up

x
?
Solved

barcode scanner

Posted on 2011-03-10
14
Medium Priority
?
719 Views
Last Modified: 2012-05-11
I have a laser bar code scanner that works with the barcode 3 of 9 font. I need to know the code for tab function to use  it in my crystal report form. So, every time the barcode scanner scans, it would tab and scans the next barcode.

for example I already tried these variables in crystal report and none of them works:
'chr13'+ OR '\t' + OR '\I ' and etc
So, I only need the tab function to hard code it in my reports.


Thanks,
Paul
0
Comment
Question by:pauledwardian
  • 5
  • 4
  • 3
  • +1
14 Comments
 
LVL 12

Expert Comment

by:JayConverse
ID: 35102360
Look at the manual for your scanner, it's probably listed under "suffix".  With barcode scanners you program the tab or return key in the hardware, not the barcode.
0
 

Author Comment

by:pauledwardian
ID: 35102541
so it is cannot be programmed in the crystal report itself?
0
 
LVL 12

Expert Comment

by:JayConverse
ID: 35102611
No, that's not how barcode scanners work.
0
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
LVL 101

Expert Comment

by:mlmcc
ID: 35102776
What is it you want Crystal to do?

Crystal is a reporting tool.

mlmcc
0
 

Author Comment

by:pauledwardian
ID: 35103322
I'm sorry. Maybe I wasn't clear enough. In crystal it lets me to edit the bar code font( which in my case is "barcode 3 of 9"). For example I used + '~' + and it worked when I scanned the barcode with the scanner but instead of doing the tab function it added space after inserting the numbers in notepad. So, I'm looking for some function that lets me to edit the barcode font so that whenever I scan the barcode with the scanner; it would make the barcode to tab after specified tables. For example:

table name from SQL database that includes a number + '\ Tab function+ other table name with number + '\tab function

so I need a tab function on the barcode itself that can be embedded in crystal and makes the scanner to tab anytime it recognizes that function inside the barcode font.

Thanks,
Paul
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 35103436
So Crystal is producing a report with barcodes and you want to read the barcodes and in speficic instances you want a tab character in the result?

WHen you scan a barcode, the results are put into a notepad file.

How do you know notepad didn't get a tab character?
Notepad produces text files and converts tabs to spaces.

mlmcc
0
 
LVL 12

Expert Comment

by:JayConverse
ID: 35103536
I repeat, that's not how barcode scanners work.  I've been coding them since the DOS days, and using various Crystal fonts, both free and commercial, including Code 128, 3 of 9, and UPC.  Read the scanner's manual, it takes at most 3 scans to set the suffix code that you need.
0
 
LVL 35

Expert Comment

by:James0628
ID: 35107326
Jay seems pretty sure that this isn't what you really need, but FWIW, you can produce a Tab character in a CR formula using ChrW (9).

 James
0
 
LVL 12

Assisted Solution

by:JayConverse
JayConverse earned 600 total points
ID: 35107701
It's real simple.  A tab character is by definition an unprintable character.  The scanner can't react to something that it can't see.
0
 

Author Comment

by:pauledwardian
ID: 35108754
James0628 can you please provide more details?
0
 
LVL 12

Expert Comment

by:JayConverse
ID: 35108820
It's not going to work, Paul.
0
 
LVL 35

Accepted Solution

by:
James0628 earned 900 total points
ID: 35114995
Jay,

 <chuckle>  OK.  That was kind of obvious, but it never occurred to me.  It would be kind of hard for a scanner to pick up a Tab character.  I guess maybe if it was looking for a certain amount of blank space, and not a Tab, per se.


 Paul,

 From your original post (and your use of '\t' and '\I '), it sounded like you were trying to add an actual Tab character (what you get when you hit the Tab key) to a string.  Something like "some characters<Tab character>some other characters".  ChrW (9) produces a Tab character, in the same way that ChrW (65) produces an "A", and ChrW (49) produces a "1".  So, to produce a string like the one above in a formula, you could use:

"some characters" + ChrW (9) + "some other characters"


 However, as Jay pointed out, a Tab character can not be seen (so it can not be scanned), except as some blank space, so it really doesn't seem like that's what you need.  And if you do just need some blank space, why not just use spaces?

 James
0
 

Author Closing Comment

by:pauledwardian
ID: 35132043
good comments. Thanks everyone.
0
 
LVL 35

Expert Comment

by:James0628
ID: 35136216
You're welcome.  I'm glad I could help.

 But did I help?  Did you actually get a solution out of this?  Did you actually need a Tab character, or something else?  I'm just curious.

 James
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
An introductory discussion about Oracle Analytic Functions which are used to calculate or compute Aggregate values, based on a group of rows.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…

579 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