Results 1 to 2 of 2
  1. #1
    sholtzin is offline Novice
    Windows XP Access 2003
    Join Date
    Dec 2017
    Posts
    1

    Blocking automatic entry in a form field

    Is there a way to block someone from making an automatic entry in a form field by copying the previous entry's record?
    I have a user who consistently does this by using the control/Quote combo, even when the result is not what it should be.
    I would like to force the entry to be manual, with no copy over option.
    Thank you

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,523
    in the form property, turn ON : keypreview=true
    if you cannot find the property ,set it in form load:

    Code:
    Private Sub Form_Load()
    Me.KeyPreview = True
    End Sub

    then put this code in the form keydown event. It will trap the ditto key and turn if 'off'.
    Code:
    Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
    Dim bCtrlDown As Boolean
    
    bCtrlDown = (Shift And acCtrlMask) > 0
    If KeyCode = 222 And bCtrlDown Then       
      KeyCode = 0
    End If
    End Sub

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

Similar Threads

  1. Replies: 8
    Last Post: 11-13-2014, 02:41 PM
  2. Automatic Date Entry
    By Al77 in forum Access
    Replies: 3
    Last Post: 02-27-2012, 12:06 PM
  3. Automatic Recurring Entry
    By Al77 in forum Access
    Replies: 3
    Last Post: 02-15-2012, 04:24 PM
  4. Automatic Field DAta Entry
    By Lupson2011 in forum Access
    Replies: 4
    Last Post: 09-01-2011, 09:15 AM
  5. Access 2003 automatic field entry
    By RANCHLAW56 in forum Forms
    Replies: 6
    Last Post: 12-30-2010, 02:57 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