Prevent Duplicate entry in a month (1 Viewer)

[USMAN55]

Hello

I have a database for pay pensions and i want to prevent duplicate entry in a month of each pension account
I.e i have account number 4124A and i want to create only one entry in a month.

how i create it.?

here is the form view i have use for transaction.

 

[Pat Hartman]

You need to add a field to hold yyyy/mm, using a calculated field is best. Then you can make a unique index on Account + the ym field. To create a multi-field unique index, you must use the indexes dialog.

 

[June7]

Cross post https://www.accessforums.net/showthread.php?t=85201

AFAIK, cannot use table calculated field in an index.

 

[theDBguy]

Hi @USMAN55. Welcome to AWF!

You could also try using the BeforeUpdate event of your form to prevent duplicate entries.

 

[isladogs]

Also posted at https://bytes.com/topic/access/answers/976874-prevent-duplicate-entry-amonth where I gave an answer similar to Pat's

@USMAN55 - please don't crosspost without telling readers you have done so and providing links - it just wastes everyone's time duplicating what others have written

 

[oleronesoftwares]

Welcome @USMAN55 .

 

[arnelgp]

you can also add a button in your form that will open a Form
with the Last Transaction of the Account owner.