+ Reply to Thread
Results 1 to 2 of 2

I would like to scan a badge and have the date imported as a name

  1. #1
    Registered User
    Join Date
    01-25-2017
    Location
    Arcadia, Michigan
    MS-Off Ver
    MS Office 2013
    Posts
    1

    I would like to scan a badge and have the date imported as a name

    All,

    I would like to use a barcode scanner to scan a badge, after the badge is scanned i would like the document to populate with a Title, Name, Access Level, Time Stamp.

    If i had to scan a badge a populate that information once during a check-in process that would be fine as long as when scanned again it would populate. Any help would be appreciated.
    Last edited by bschram50; 01-25-2017 at 07:12 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    03-24-2014
    Location
    England
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    560

    Re: I would like to scan a badge and have the date imported as a name

    So, what you're saying is.....

    1) scan a badge and get the ref number.
    2) check that ref number against a list of ref numbers and if found, log the name, title, access level and timestamp on another sheet
    3) If not found then display an input box for the user to enter the name, title and access level and then add that to the list. Repeat step 2.

    You'll need 3 worksheets.

    The first is your list of badge numbers and associated data.
    The second is your logging sheet.
    The third is your data input sheet....or if you're feeling fancy you could put this on a userform instead. But since it sounds like you're new to VBA I'd stick to simple for now.


    Have a look at the top of this forum, there's a thread with lots of links for those new to VBA. You'll need a basic grounding in order to do this.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Badge Inventory look up
    By Shamz41 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-09-2017, 07:58 AM
  2. Badge Inventory Scanning
    By Shamz41 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-30-2015, 10:59 PM
  3. RFID Time and date stamp on scan and off scan
    By forey89 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-14-2015, 06:46 AM
  4. RFID Time and date stamp on scan
    By surfershort in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-27-2014, 02:57 PM
  5. Scan-in, Scan-out tool inventory with barcode scanner
    By rycr023 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-20-2014, 11:52 AM
  6. A Macro to print name badge from a list
    By cecemf in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-06-2011, 05:02 AM
  7. ID Badge Form with Preview (?)
    By rfhall50 in forum Excel General
    Replies: 1
    Last Post: 03-28-2011, 12:56 PM

Tags for this Thread

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