+ Post New Thread
Results 1 to 10 of 10
How do you do....it? Thread, Bar Code reader and Excel in Technical; I have a spreadsheet of student names and other details. Can I use a bar code scanner to read their ...
  1. #1

    Join Date
    May 2007
    Posts
    84
    Thank Post
    0
    Thanked 3 Times in 2 Posts
    Rep Power
    16

    Bar Code reader and Excel

    I have a spreadsheet of student names and other details. Can I use a bar code scanner to read their ID card bar code and get the relevant record highlighted in the spreadsheet? No data input required. I don't have the scanner to play around with.

  2. #2

    powdarrmonkey's Avatar
    Join Date
    Feb 2008
    Location
    Alcester, Warwickshire
    Posts
    4,867
    Thank Post
    412
    Thanked 778 Times in 651 Posts
    Rep Power
    182
    You can if you initiate a search first.

  3. #3
    limbo's Avatar
    Join Date
    Aug 2005
    Location
    Birmingham
    Posts
    460
    Thank Post
    2
    Thanked 41 Times in 36 Posts
    Rep Power
    26
    It would be tidier to import the spreadsheet into an access database table and create a form to fetch it.

    Basically the bardcode reader just types in the value of the barcode, usually followed by a carriage return.

    So anything where you have to type in the value and hit return to action will work with a scanner.

  4. #4

    Join Date
    May 2007
    Posts
    84
    Thank Post
    0
    Thanked 3 Times in 2 Posts
    Rep Power
    16
    Briiliant, so simple. I'll try it next week. First the spreadsheet and then get the DB running

  5. #5

    powdarrmonkey's Avatar
    Join Date
    Feb 2008
    Location
    Alcester, Warwickshire
    Posts
    4,867
    Thank Post
    412
    Thanked 778 Times in 651 Posts
    Rep Power
    182
    Note that some scanners finish with a tab character (in fact, probably most) and you can't always change that. Some come with a little book of configuration bars that you can scan to activate.

  6. #6


    Join Date
    Mar 2009
    Location
    Leeds
    Posts
    7,057
    Thank Post
    232
    Thanked 923 Times in 792 Posts
    Rep Power
    308
    Quote Originally Posted by powdarrmonkey View Post
    Note that some scanners finish with a tab character (in fact, probably most) and you can't always change that. Some come with a little book of configuration bars that you can scan to activate.
    and one i was using recently prefaced everything with something like ~s not really a problem when im just recording serial numbers as i can just edit it out later but will stop a search working

  7. #7

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    11,271
    Thank Post
    884
    Thanked 2,749 Times in 2,322 Posts
    Blog Entries
    11
    Rep Power
    785
    All of the barcode scanners that I have encountered have included the little config code book that was talked about above. This can usually set the code types read, the end character (tab/enter/none) and the encoding type. The scanner you were using was probably setup incorrectly for the lables you were scanning in hence the initial character.

  8. #8


    Join Date
    Mar 2009
    Location
    Leeds
    Posts
    7,057
    Thank Post
    232
    Thanked 923 Times in 792 Posts
    Rep Power
    308
    Quote Originally Posted by SYNACK View Post
    All of the barcode scanners that I have encountered have included the little config code book that was talked about above. This can usually set the code types read, the end character (tab/enter/none) and the encoding type. The scanner you were using was probably setup incorrectly for the lables you were scanning in hence the initial character.
    probably i just used the junior librarian pc and scanner as its still quicker than typing by hand

  9. #9

    Join Date
    Aug 2005
    Location
    London
    Posts
    3,159
    Thank Post
    116
    Thanked 529 Times in 452 Posts
    Blog Entries
    2
    Rep Power
    125
    If the barcodes aren't yet printed then you can add whatever lead and terminator characters etc you want to them (so I think you should be be able to have a barcode with something like <CTRL F> ID Number) but it's probably easier to have a system which either allows you to type on the keyboard or scan and the result ends up the same. That's good for when the scanner won't work :-)

  10. #10

    Join Date
    May 2013
    Posts
    4
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by blackcat View Post
    I have a spreadsheet of student names and other details. Can I use a bar code scanner to read their ID card bar code and get the relevant record highlighted in the spreadsheet? No data input required. I don't have the scanner to play around with.

    The following are similar posts: Hope it will help you a little.

    barcode scanner can not connect to the application to call the data from the database - DesignersTalk

    TimeTrex Time and Attendance &bull; View topic - DIY Stand Alone Barcode Punch Station



SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 1
    Last Post: 22nd December 2009, 06:05 PM
  2. Adobe reader 9.2 out
    By Theblacksheep in forum Office Software
    Replies: 37
    Last Post: 6th November 2009, 01:33 PM
  3. google bar code
    By k-strider in forum General Chat
    Replies: 13
    Last Post: 7th October 2009, 09:20 PM
  4. Adobe Reader 9
    By clarky2k3 in forum Windows
    Replies: 26
    Last Post: 17th August 2008, 01:10 PM
  5. E-Reader
    By Liam in forum General Chat
    Replies: 2
    Last Post: 6th November 2007, 04:30 PM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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