Results 1 to 3 of 3
  1. #1
    Abhijeet is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2015
    Posts
    3

    Prevent Duplicate Entries

    Hi



    I am using Ms Access 2010. I have in one folder 10 users using access database files i want If any Users update any entry then same entry update by different user or that user then pop up which user already update that entry.please tell me how to do this.
    OR

    All users database data can automatic update in single excel files after each 15min then macro can tell us any duplicate entry update or not.

    Please tell me which is possible case

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Have a field that saves the userID and date of rec change, invisible to user.
    if record goes into edit mode, set txtUser box to the userID,

    Code:
    'Check if edited previously...
    if isNull(txtDate) then
    txtUser = Environ("Username")
    txtDate = now()
    else
        MSGbox "already edited by " & txtUser
    end if

  3. #3
    Abhijeet is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2015
    Posts
    3
    Hi

    Is that possible all users data store in one Database. After each entries save by each users then store quickly & save in master Database.Please tell me how to do this

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

Similar Threads

  1. How to prevent duplicate data
    By ariansman in forum Forms
    Replies: 2
    Last Post: 08-11-2015, 06:25 AM
  2. Prevent duplicate entries in linked table
    By arothacker in forum Forms
    Replies: 5
    Last Post: 02-11-2014, 11:08 PM
  3. Replies: 19
    Last Post: 04-05-2013, 01:28 PM
  4. Problem with code to prevent duplicate entries
    By ResearchRN in forum Programming
    Replies: 5
    Last Post: 11-08-2011, 12:12 PM
  5. prevent editing current entries in forms
    By Chazcoral in forum Forms
    Replies: 1
    Last Post: 05-20-2010, 06:49 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