If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Combining and splitting fields
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 |
#2
|
|||
|
|||
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 . |
#3
|
|||
|
|||
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" wrote in message ... 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 . |
#4
|
|||
|
|||
I ended up hiding the scanned barcode, and displaying the Left,6 and Right,4
values. Thankx -JS "DEVOURU" wrote in message om... 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" wrote in message ... 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 . |
Thread Tools | |
Display Modes | |
|
|