Combining and splitting fields

  • Thread starter Thread starter DEVOURU
  • Start date Start date
D

DEVOURU

I have a control source =[pono]&[item] to display/print a single bar code
for a purchase order and line item.
I have a form linked to a query to lookup the purchase order and litem.
What would ya'll suggest so that I can scan the above barcode and have it
split the number for query entry?

Example:
The barcode is scanned - 0546590011
Query - Enter PO Number
Left([barcode],6)
Query - Enter Line Item
Right([barcode],4)

I am trying to reduce scanning errors and time by scanning the bar code once
with both field entries.
I hope I was able to explain this well.

TIA, -JS
 
I'm confused. the combined barcode was seperate at one
time. why can't you get the po data and the item data from
the source instead of going through the barcode routine.
seem like the long way around to me.
one way - put hidden test boxes on the form with the po
data and the item data. use that for the query. unless
there is something you left out of your explination, i
would skip the scanning stuff.
 
Hidden fields may work. Basically this is a production application. The
person is given a worksheet with jobs to complete. At the end of the day,
they scan the barcode, enter the qty, repeat as necessary. It is to reduce a
ton of data entry errors.

-JS


Frank Stone said:
I'm confused. the combined barcode was seperate at one
time. why can't you get the po data and the item data from
the source instead of going through the barcode routine.
seem like the long way around to me.
one way - put hidden test boxes on the form with the po
data and the item data. use that for the query. unless
there is something you left out of your explination, i
would skip the scanning stuff.
-----Original Message-----
I have a control source =[pono]&[item] to display/print a single bar code
for a purchase order and line item.
I have a form linked to a query to lookup the purchase order and litem.
What would ya'll suggest so that I can scan the above barcode and have it
split the number for query entry?

Example:
The barcode is scanned - 0546590011
Query - Enter PO Number
Left([barcode],6)
Query - Enter Line Item
Right([barcode],4)

I am trying to reduce scanning errors and time by scanning the bar code once
with both field entries.
I hope I was able to explain this well.

TIA, -JS


.
Click to expand...
Click to expand...
 
I ended up hiding the scanned barcode, and displaying the Left,6 and Right,4
values. Thankx

-JS

DEVOURU said:
Hidden fields may work. Basically this is a production application. The
person is given a worksheet with jobs to complete. At the end of the day,
they scan the barcode, enter the qty, repeat as necessary. It is to reduce a
ton of data entry errors.

-JS


Frank Stone said:
I'm confused. the combined barcode was seperate at one
time. why can't you get the po data and the item data from
the source instead of going through the barcode routine.
seem like the long way around to me.
one way - put hidden test boxes on the form with the po
data and the item data. use that for the query. unless
there is something you left out of your explination, i
would skip the scanning stuff.
-----Original Message-----
I have a control source =[pono]&[item] to display/print a single bar code
for a purchase order and line item.
I have a form linked to a query to lookup the purchase order and litem.
What would ya'll suggest so that I can scan the above barcode and have it
split the number for query entry?

Example:
The barcode is scanned - 0546590011
Query - Enter PO Number
Left([barcode],6)
Query - Enter Line Item
Right([barcode],4)

I am trying to reduce scanning errors and time by scanning the bar code once
with both field entries.
I hope I was able to explain this well.

TIA, -JS


.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top