Atiqul Haque
New Member
- Joined
- Dec 13, 2020
- Messages
- 45
- Office Version
- 2016
- Platform
- Windows
Dear All,
Re: Prob in Userform_Edit_PreventDuplicateEntry_DependableMandatoryField_DTPicker.
My database works nice but i faced the following issue:
1) Mandatory Fields:
In userform "D" & "E" are not a mandatory field, but if i put a value like "Salary" in "G" then "D" will be a mandatory field, and if put "Bonus" in "G" then "E" will be a mandatory field.
2) DTPicker:
In userform DTPicker shows "29-Jan-21" as default, but i want it to show date as "TODAY".
3) Prevent Duplicate Entries:
I need to prevent duplicate entries on "C", "D" & "E".
4) Edit Function:
If duplicate entries are not allowed then what will be the code of "EDIT" function.
Pics of database & userform sending herewith for your reference. Also sending the dropbox link of the database.
Pls anybody help me out of these problems.
Thanks in advance.
Database dropbox link.....
www.dropbox.com
Re: Prob in Userform_Edit_PreventDuplicateEntry_DependableMandatoryField_DTPicker.
My database works nice but i faced the following issue:
1) Mandatory Fields:
In userform "D" & "E" are not a mandatory field, but if i put a value like "Salary" in "G" then "D" will be a mandatory field, and if put "Bonus" in "G" then "E" will be a mandatory field.
2) DTPicker:
In userform DTPicker shows "29-Jan-21" as default, but i want it to show date as "TODAY".
3) Prevent Duplicate Entries:
I need to prevent duplicate entries on "C", "D" & "E".
4) Edit Function:
If duplicate entries are not allowed then what will be the code of "EDIT" function.
Pics of database & userform sending herewith for your reference. Also sending the dropbox link of the database.
Pls anybody help me out of these problems.
Thanks in advance.
Database dropbox link.....
Dropbox - File Deleted - Simplify your life
