Scan a UPC on a txtfield on mainform & add to subform Please Help!

Access Discussion in 'Microsoft Office' started by yeasir01, Jul 15, 2017.

  1. yeasir01

    yeasir01

    Joined:
    Nov 21, 2014
    Likes Received:
    0
    I'm creating a simple inventory stocktake database for tracking inventory bought from certain vendors. I dont need to subtract inventory sold or anything like that just inventory intake. Hope that makes since.

    My objective it to have a form that I open, set the date vendor & invoice number then place the focus on the scan txt box & start scanning using a wedge type scanner (Basicly inputs the barcode data & then hits the enter button). I prefer this method because I can input the information much quicker than finding the item in a combobox and setting the quantity.

    I've created all the necessary tables & set the relationships to accomplish this. What I can't figure out is how to have the scan txtbox linked from the mainform to the sub or make the box lookup UPCs that are related to the product & produce 1 item per scan to add to the purchase order detail subform. Or change the qty if the item exist on the list. I have no VBA experience, iv tried using macros with no success. I would really appreciate someones help on this

    I attached a copy of the DB im working on for review.
     

    Attached Files:

    yeasir01, Jul 15, 2017
    #1
    1. Advertisements

  2. yeasir01

    yeasir01

    Joined:
    Nov 21, 2014
    Likes Received:
    0
    Any help guys?
     
    yeasir01, Jul 18, 2017
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. tevigen

    Access MS Access - Emailing Subform Data

    tevigen, Jun 15, 2005, in forum: Microsoft Office
    Replies:
    0
    Views:
    847
    tevigen
    Jun 15, 2005
  2. wintersilke

    Access Automating text input into MS Access subform

    wintersilke, Jun 22, 2005, in forum: Microsoft Office
    Replies:
    0
    Views:
    857
    wintersilke
    Jun 22, 2005
  3. Scott Price

    Access MS Access 2003, problem filtering subform

    Scott Price, Jul 3, 2007, in forum: Microsoft Office
    Replies:
    0
    Views:
    1,783
    Scott Price
    Jul 3, 2007
  4. haservices

    Access Access: Select a record in continuous subform

    haservices, Apr 20, 2011, in forum: Microsoft Office
    Replies:
    1
    Views:
    795
    haservices
    Apr 20, 2011
  5. NoviceBoy

    Access Filter Subform in Access 2007

    NoviceBoy, Jun 14, 2011, in forum: Microsoft Office
    Replies:
    1
    Views:
    747
    NoviceBoy
    Jun 24, 2011
  6. angie057

    Access Access 2007 New Record Command for subform

    angie057, Jun 6, 2012, in forum: Microsoft Office
    Replies:
    0
    Views:
    759
    angie057
    Jun 6, 2012
  7. JBren

    Access Enable/Disable Access Subform

    JBren, Oct 19, 2012, in forum: Microsoft Office
    Replies:
    1
    Views:
    1,186
    Projectnow
    Oct 20, 2012
  8. sunking_2013

    Access Subform in MS Access 2010

    sunking_2013, Jul 22, 2013, in forum: Microsoft Office
    Replies:
    0
    Views:
    680
    sunking_2013
    Jul 22, 2013
Loading...