Usmantahir
New member
- Local time
- Today, 04:43
- Joined
- Oct 6, 2022
- Messages
- 6
Hello All,
I have a access database to give pension for pensioners in transaction form i have 8000 accounts in my data table and i am using drop down list combo box to make transactions.
I want single entry in each month of every account if any user try to do duplicate entry ms access prevent to duplicate entry in same month.
I have these field in my transaction form
Date,account no,name of pensioner,amount of pension
I have a access database to give pension for pensioners in transaction form i have 8000 accounts in my data table and i am using drop down list combo box to make transactions.
I want single entry in each month of every account if any user try to do duplicate entry ms access prevent to duplicate entry in same month.
I have these field in my transaction form
Date,account no,name of pensioner,amount of pension