+ Reply to Thread
Results 1 to 8 of 8

Pop-up to let me know its a duplicate scan

  1. #1
    Registered User
    Join Date
    01-20-2021
    Location
    USA
    MS-Off Ver
    360
    Posts
    4

    Pop-up to let me know its a duplicate scan

    Hello everyone,

    I'm working on a file for a Supply hand out station, the way it works is as followed....you open the file>click on the button that will activate the user form> you scan the person(s) ID> scan the stock code>enter QTY>submit
    from there it will be put into a list....I need a pop-up to show up when ever the same ID is trying to scan a certain item

    for example:
    someone with ID 1234 come and takes a hat, they scan their ID and leave, if they come back in two days or so and try to do it again I need a pop -up to some up and say that this person has already received 1 hat that week/ month and wont be able to get another one, then have to button, one to acknowledge it and let it pass and another to cancel the transaction.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Pop-up to let me know its a duplicate scan

    1. Paste this formula in F2

    =MATCH(F1,Table1[[#All],[Barcode]]&":"&Table1[[#All],[Employee ID]],0)

    2. Format the text in F1 and F2 to White so the text is hidden.

    3, Change your Submit button text to:

    Please Login or Register  to view this content.
    Attached Files Attached Files
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Registered User
    Join Date
    01-20-2021
    Location
    USA
    MS-Off Ver
    360
    Posts
    4

    Re: Pop-up to let me know its a duplicate scan

    Hello, thank you! but can i set it so that it does that for specific barcodes ? also not too sure what you mean by "F2" and "F1"
    im still fairly new to this whole thing

  4. #4
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Pop-up to let me know its a duplicate scan

    Enter your Barcode and Id then press submit.


    Cells F1 and F2.

    I have done all the work for you on the sample.

  5. #5
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Pop-up to let me know its a duplicate scan

    Following a Private Message.

    Op is requesting that the Message box does not appear if a month has passed since the item was last issued.

    I have taken that to mean 30 days.

    All you need to do is to change one line in the Submit Button Code:

    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    01-20-2021
    Location
    USA
    MS-Off Ver
    360
    Posts
    4

    Re: Pop-up to let me know its a duplicate scan

    i tried the code but it keeps giving me an error and highlighting this part...
    If Not IsError([F2]) And Date - Cells([F2], 4) < 30 Then

  7. #7
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Pop-up to let me know its a duplicate scan

    I do not get that error.

    Try the attached file.
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    01-20-2021
    Location
    USA
    MS-Off Ver
    360
    Posts
    4

    Re: Pop-up to let me know its a duplicate scan

    Attachment 714662

    this is the roor i am getting, with the file you attached

+ 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. Please help me with scan in and scan out sheet
    By haixingau in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-03-2020, 10:52 AM
  2. [SOLVED] top 10 values scan from vba
    By zain5683 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-16-2017, 01:35 PM
  3. [SOLVED] Prevent Duplicate Row & Population of Last Scan
    By Hackboss007 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-15-2016, 01:34 PM
  4. 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
  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. Replies: 5
    Last Post: 11-12-2012, 08:38 PM
  7. "customize" the scan to always scan a letter size page
    By zinzah in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-18-2007, 09:04 AM

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