Query and bar code labels

[benzhaotb]

Hi every one;
I am using Foxpro 7.0. I want to do a query, then use the queyr to make bar code labels. I know how to make bar code labels but I don't know how to link the barcode labels with the query. Please help! Thanks.

 

[Mike Lewis]

You'll need to give us some more information.

What data do you want to print in the barcode? What information is the query producing?

Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk

 

[benzhaotb]

Thanks. I need to print out patient ID, specimen type, and date from our hospital admision. I need to do a query by date, then print bar code according the query results.

 

[Mike Gagnon]

Thanks. I need to print out patient ID, specimen type, and date from our hospital admision. I need to do a query by date, then print bar code according the query results.

Barcode is just a font like any other fonts. You can find free barcode fonts on the internet, and instead of using a "regular" font for your lable, change it to the barcode font. Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[benzhaotb]

Hi Mike;
I knew how to do bar code. My problem is that how can link a bar code to a query, I only need to print out bard code for cerntain dates e.g 2/27/03.

 

[DSummZZZ]

Use the report designer, label designer, or even ???.
Using the report or label designer, create fielsd corresponding to the fields from the query, and set the font to whichever the barcode font is. Then:

SELECT f1, f2, f3 FROM MyTable ;
INTO CURSOR MyCursor

LABEL FORM MyBarCodes
-or-
REPORT FORM MyBarCode
-or-
??? patient_ID + ' ' + specimen_type + ' + DTOS(date );
FONT 'Code39'

Dave S.