Results 1 to 3 of 3
  1. #1
    usman55 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2022
    Posts
    1

    Prevent duplicate record in a month

    Hello


    i have an access database for pay pensions and i want to prevent duplicate entry against pension accounts in a month.


    i.e i have an account (2244A) i pay him pension on 03.01.2022 if i enter this account on 23.01.2022 access denied this entry till the month changed.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Are you selecting account from a combobox? Limit combobox list to accounts that don't have record for the specified month.

    Use code in some event to check if account already has record for specified month.

    Do you save a full date value in a date/time field?

    Cross post https://www.access-programmers.co.uk...-month.321463/
    Last edited by June7; 01-21-2022 at 03:33 PM.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    can you key the table for ACCT & Month?
    then it wont allow you to add a dupe.

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

Similar Threads

  1. Prevent duplicate record
    By Vanz in forum Import/Export Data
    Replies: 4
    Last Post: 02-07-2021, 09:21 PM
  2. Prevent duplicate value
    By IvanGAa in forum Forms
    Replies: 1
    Last Post: 03-11-2020, 01:18 AM
  3. Replies: 12
    Last Post: 06-26-2017, 02:40 PM
  4. How do you prevent duplicate records?
    By cwjakesteel in forum Database Design
    Replies: 28
    Last Post: 11-28-2016, 09:05 AM
  5. Prevent duplicate dates
    By bishop0071 in forum Access
    Replies: 1
    Last Post: 01-09-2013, 09:04 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