Page 2 of 2 FirstFirst 12
Results 16 to 17 of 17
  1. #16
    RandyH is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Dec 2020
    Posts
    25
    There is no Input Mask. Just the Data Type in Table Design as Currency.



    I can get to the Immediate Window, but not sure how or what code to enter.

    I do have other Forms that use the [Table1].[Amount] that do different tasks on Keyboard Enter like Requery.List33 and Requery.List45.

    But, Me.Amount limits the code to the Form is that is open, right? This particular Form is Setter Billing.

    Thanks for being so patient!

    RandyH

  2. #17
    Minty is offline VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    You should be able to see the result of the Debug.Statement

    Scanned value: 9999991



    This will confirm that what is being scanned matches your If Clause value or not.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. check barcode serial number before scanning
    By hullstorage in forum Programming
    Replies: 1
    Last Post: 07-14-2020, 06:33 AM
  2. Replies: 5
    Last Post: 05-16-2019, 09:01 PM
  3. Replies: 2
    Last Post: 11-10-2017, 04:38 AM
  4. Employee time clock with barcode scanning
    By trevor40 in forum Programming
    Replies: 2
    Last Post: 03-26-2014, 10:54 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums