Barcoding in Vantage / Crystal

Yahoo Archive
1
Sorry, Chris, I was just typing quickly off top of my head. You want to put it in the curly braces, like you have there.
You will have to put chr({orderhed.ordernum}) also, because ordernum is an integer.

So here's the correct string:

"*" & Chr({orderhed.ordernum}) & "$I*"




________________________________
From: Chris Thompson <chriselectrix@...>
To: vantage@yahoogroups.com
Sent: Tuesday, November 11, 2008 8:12:55 AM
Subject: Re: [Vantage] Barcoding in Vantage / Crystal


Hi Tony,

Thanks for the prompt reply.

When you say [ordernumber] do you mean {orderhed.ordernum} like that or do you actually mean to include the [square brackets]?

Thanks,

CHRIS

____________ _________ _________ __
From: Tony Hughes <thughes281@yahoo. com>
To: vantage@yahoogroups .com
Sent: Tuesday, November 11, 2008 1:58:08 PM
Subject: Re: [Vantage] Barcoding in Vantage / Crystal

Build the string like this:
"*" & [ordernumber] & "$I*"

but the scanner has to be programmed to be using Full 39 for this to work.
another useful one is $M which is the Enter key.

____________ _________ _________ __
From: Chris Thompson <chriselectrix@ ymail.com>
To: vantage@yahoogroups .com
Sent: Tuesday, November 11, 2008 7:51:52 AM
Subject: [Vantage] Barcoding in Vantage / Crystal

Hi,

We are going live at the beginning of next year and I have been given the task of getting all of the forms etc designed to be used in-house.

On the Sales Order Pick List, I would like to have a barcode that contains *Order Number[TAB]* .

The asterisks are the beginning and end of the 3of9 barcode.

Order Number comes from orderhed.OrderNum.

I imagine that I need to creat a formula that reads ...

"*" & {orderhed..OrderNum } & Chr (9) & "*"

Then I would need to convert the standard Arial to the DataWorks 3of9 font.

However, when this prints, it actually puts part of the barcode, then a space then a bit more of the barcode.

The gap is obviously generated by the Chr (9) in the formula.

I have also tried an option that I read about in this yahoo group "*" & {orderhed.OrderNum} & "$I*", but the $I is just read and displayed as $I.

How can I create a barcode to display the Order Number, and to tab in one action?

Although our scanners can be configured to automatically TAB, I dont want to use this function as they are dual prupose throughout the site and some operations don't require a TAB.

Any help on this would be greatly appreciated.

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]






[Non-text portions of this message have been removed]
2
Hi,

We are going live at the beginning of next year and I have been given the task of getting all of the forms etc designed to be used in-house.

On the Sales Order Pick List, I would like to have a barcode that contains *Order Number[TAB]*.

The asterisks are the beginning and end of the 3of9 barcode.

Order Number comes from orderhed.OrderNum.

I imagine that I need to creat a formula that reads ...

"*" & {orderhed..OrderNum} & Chr (9) & "*"

Then I would need to convert the standard Arial to the DataWorks 3of9 font.

However, when this prints, it actually puts part of the barcode, then a space then a bit more of the barcode.

The gap is obviously generated by the Chr (9) in the formula.

I have also tried an option that I read about in this yahoo group "*" & {orderhed.OrderNum} & "$I*", but the $I is just read and displayed as $I.Â

How can I create a barcode to display the Order Number, and to tab in one action?

Although our scanners can be configured to automatically TAB, I dont want to use this function as they are dual prupose throughout the site and some operations don't require a TAB.

Any help on this would be greatly appreciated.




[Non-text portions of this message have been removed]
3
Build the string like this:
"*" & [ordernumber] & "$I*"

but the scanner has to be programmed to be using Full 39 for this to work.
another useful one is $M which is the Enter key.





________________________________
From: Chris Thompson <chriselectrix@...>
To: vantage@yahoogroups.com
Sent: Tuesday, November 11, 2008 7:51:52 AM
Subject: [Vantage] Barcoding in Vantage / Crystal


Hi,

We are going live at the beginning of next year and I have been given the task of getting all of the forms etc designed to be used in-house.

On the Sales Order Pick List, I would like to have a barcode that contains *Order Number[TAB]* .

The asterisks are the beginning and end of the 3of9 barcode.

Order Number comes from orderhed.OrderNum.

I imagine that I need to creat a formula that reads ...

"*" & {orderhed..OrderNum } & Chr (9) & "*"

Then I would need to convert the standard Arial to the DataWorks 3of9 font.

However, when this prints, it actually puts part of the barcode, then a space then a bit more of the barcode.

The gap is obviously generated by the Chr (9) in the formula.

I have also tried an option that I read about in this yahoo group "*" & {orderhed.OrderNum} & "$I*", but the $I is just read and displayed as $I.

How can I create a barcode to display the Order Number, and to tab in one action?

Although our scanners can be configured to automatically TAB, I dont want to use this function as they are dual prupose throughout the site and some operations don't require a TAB.

Any help on this would be greatly appreciated.

[Non-text portions of this message have been removed]






[Non-text portions of this message have been removed]
4
Hi Tony,

Thanks for the prompt reply.

When you say [ordernumber] do you mean {orderhed.ordernum} like that or do you actually mean to include the [square brackets]?

Thanks,


CHRIS




________________________________
From: Tony Hughes <thughes281@...>
To: vantage@yahoogroups.com
Sent: Tuesday, November 11, 2008 1:58:08 PM
Subject: Re: [Vantage] Barcoding in Vantage / Crystal


Build the string like this:
"*" & [ordernumber] & "$I*"

but the scanner has to be programmed to be using Full 39 for this to work.
another useful one is $M which is the Enter key.

____________ _________ _________ __
From: Chris Thompson <chriselectrix@ ymail.com>
To: vantage@yahoogroups .com
Sent: Tuesday, November 11, 2008 7:51:52 AM
Subject: [Vantage] Barcoding in Vantage / Crystal

Hi,

We are going live at the beginning of next year and I have been given the task of getting all of the forms etc designed to be used in-house.

On the Sales Order Pick List, I would like to have a barcode that contains *Order Number[TAB]* .

The asterisks are the beginning and end of the 3of9 barcode.

Order Number comes from orderhed.OrderNum.

I imagine that I need to creat a formula that reads ...

"*" & {orderhed..OrderNum } & Chr (9) & "*"

Then I would need to convert the standard Arial to the DataWorks 3of9 font.

However, when this prints, it actually puts part of the barcode, then a space then a bit more of the barcode.

The gap is obviously generated by the Chr (9) in the formula.

I have also tried an option that I read about in this yahoo group "*" & {orderhed.OrderNum} & "$I*", but the $I is just read and displayed as $I.

How can I create a barcode to display the Order Number, and to tab in one action?

Although our scanners can be configured to automatically TAB, I dont want to use this function as they are dual prupose throughout the site and some operations don't require a TAB.

Any help on this would be greatly appreciated.

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]






[Non-text portions of this message have been removed]