Results 1 to 4 of 4
  1. #1
    torpid is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2011
    Posts
    10

    Escape field entry


    Hi, I am attempting to build some code to ignore the last input into a table field. In full, I have people swiping cards to sign in and when the database notices that they have signed in, the second swipe updates their data to 'timeout' and ignores the second swipe. I have all the code for the rest of it, but I need to find some way of ignoring the second swipe. I have the idea that if I use KeyPress(ESC) it will just escape the input and all is well. I don't know how to implement this or if it's the best practice. Any ideas?
    Any help is appreciated.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Me.YourControlName.UnDo will reverse any edit of that control. Using YourControlName of course.

  3. #3
    torpid is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2011
    Posts
    10
    Thanks RG, once again.
    I found this on a forum about 5 minutes ago:
    DoCmd.GoToRecord , , acLast
    DoCmd.RunCommand acCmdDeleteRecord

    Which did pretty much the same thing, but a little less efficiently, just for anyone reading over this.

    Thanks champ

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Fixing the problem is the main issue. Thanks for posting back with your success and solution.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Limit data entry based on another field
    By chemengr in forum Forms
    Replies: 5
    Last Post: 01-02-2014, 01:21 PM
  2. Replies: 9
    Last Post: 02-17-2011, 03:33 PM
  3. add a new entry to the field in VB code
    By Qvatra in forum Programming
    Replies: 3
    Last Post: 12-25-2010, 03:28 PM
  4. keeping current entry in field until changed
    By Chazcoral in forum Forms
    Replies: 16
    Last Post: 09-09-2010, 12:01 PM
  5. Line Return escape character
    By Jerry8989 in forum Access
    Replies: 8
    Last Post: 10-02-2009, 09:53 AM

Tags for this Thread

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