+ Reply to Thread
Results 1 to 7 of 7

Barcode scanning, very simple request to go to new line when user scans 'finish'

  1. #1
    Registered User
    Join Date
    06-08-2012
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    1

    Barcode scanning, very simple request to go to new line when user scans 'finish'

    First of all, hello and thanks for letting me into the forum.

    The requirement:

    I am setting up a scanner in one of the repair stations, to help gather some further information as to how product is moving through the stations. Currently its a small operation, with non of the normal requirements for warehouse management, but if I have more information I can improve things somewhat.

    What I want to do is the following:

    The user scans a barcode with their name. They then scan the item coming into the bay, and scan a barcode for what it is (there are only a couple of items). Then then scan from a list of repair types (They can do a number of repairs on one item), and scan what parts are being used (again there can be a number of items). They then scan a 'finished' barcode, and this 'saves' the line, and starts a new one.

    Ideally, I'd liek them to be abel to do this out of order (once they have scanned the item in, and for something to work out which field it should be entered into, based on knowing what the metadata is)

    Does anyone have a template already setup that does anything similar?

    I haven't even started (bar getting a scanner), and not sure where to, so any tips gratefully received!

    Thanks in advance

    Michael

    I did a good search and found some good inventory sheets, but nothing quite matches what I want....I don't want them to press a keyboard at all.

  2. #2
    Forum Contributor
    Join Date
    06-09-2011
    Location
    Germany
    MS-Off Ver
    Excel 2016
    Posts
    194

    Re: Barcode scanning, very simple request to go to new line when user scans 'finish'

    Hi Mintag,
    when you use a barcode scanner you can typically set it up to send a "Carriage Return Line Feed" at the end of each scan. In other words, if you scan a code it will be just the same as if you enter the code manually using your keyboard and then press enter. What I would (most likely) do, is to create a lookup table for all the different barcode values used, and in which column the information should be entered. YOur workbook, could use a "Userform" with just one inputfield for the barcode and the ok button (which would be pressed by the Carriage Return Line Feed send by the scanner). The Macro would then check in which column to enter the informaton, clean the inputfield of the userform and wait for the next input. As soon as the "finished" barcode is detected the next row would be used.

    You can easily create the barcodes from excel using a font called free-3-of-nine which is scannable, as long as you add a * at the beginn and at the end of the code.

    Hope I was able to provide you with some ideas

    Theo
    Remember To Do the Following....
    1. Upload sample files
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.

  3. #3
    Registered User
    Join Date
    03-04-2013
    Location
    Scranton
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Barcode scanning, very simple request to go to new line when user scans 'finish'

    I think you are handling the same problem. You want the barcode reader jump the next line automatically when it finished the last line, right?

    http://dynamicsuser.net/forums/p/49497/255510.aspx

  4. #4
    Registered User
    Join Date
    04-24-2013
    Location
    orange
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Barcode scanning, very simple request to go to new line when user scans 'finish'

    if you wanna make barcode reader jump automatically, you should employ a barcode scanner which contains such function. follow the steps and you may make it, good luck!

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,050

    Re: Barcode scanning, very simple request to go to new line when user scans 'finish'

    perhaps you need to keep an eye on this thread?

    http://www.excelforum.com/excel-gene...ic-column.html
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  6. #6
    Registered User
    Join Date
    08-05-2013
    Location
    fdf
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Barcode scanning, very simple request to go to new line when user scans 'finish'

    Quote Originally Posted by danny rough View Post
    if you wanna make barcode reader jump automatically, you should employ a barcode scanner which contains such function. follow the steps and you may make it, good luck!
    hi danny rough, i have installe the barcode you provided. but i am not sure how to use this software. can you help me a little bit.

  7. #7
    Registered User
    Join Date
    05-03-2013
    Location
    Los Angeles
    MS-Off Ver
    Excel 2003
    Posts
    31

    Re: Barcode scanning, very simple request to go to new line when user scans 'finish'

    Quote Originally Posted by danny rough View Post
    if you wanna make barcode reader jump automatically, you should employ a barcode scanner which contains such function. follow the steps and you may make it, good luck!
    Yup indeed, danny rough.
    I agree with you. And do you have some good recommendation about the related
    barcode scanner programs? Thanks in advance.



    Best regards,
    Arron
    Best Regards,
    Arron

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1