Combining and splitting fields

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Frank Stone (anonymous_at_discussions.microsoft.com)
Date: 08/24/04 

Date: Tue, 24 Aug 2004 11:25:34 -0700

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
>
>
>.
>

Relevant Pages

  • Re: Combining and splitting fields
    ... Hidden fields may work. ... they scan the barcode, enter the qty, repeat as necessary. ... use that for the query. ... > would skip the scanning stuff. ...
    (microsoft.public.access.forms)
  • Sum Duplicates Query?
    ... Just create a query in design view, add your table, add ... on the design grid and choose Sum Totals. ... When you view the query it should group by the barcode ... and eliminate the duplicates being left with one version ...
    (microsoft.public.access.queries)
  • Re: max function
    ... I visited your website and understand. ... there were only two field in the subquery. ... The following is my query, but doesn't this assume that the items were ... >> are barcode, transaction date and Indexid. ...
    (microsoft.public.access.queries)
  • More Detail Button
    ... I have form (its name is frmproduct) containing the following records (the ... the primary key has this format X10-1234 ... I creaded a parameter query to search on the ... me to enter the remaining part of the barcode. ...
    (microsoft.public.access.formscoding)
  • Thanks! (Re: Sum Duplicates Query?)
    ... > Just create a query in design view, add your table, add ... > When you view the query it should group by the barcode ... > and eliminate the duplicates being left with one version ...
    (microsoft.public.access.queries)