Hi All...
I'm using Append Q to append salary every month to all the staff of my company.
The month and year of my master table is a primary key so they don't accept duplicates.
After Appending, I put MsgBox "Salary Appended Successfully". But if the user choose same month and year, the result will not be appended which is right, but the MsgBox will come.
Is there any way to stop this MsgBox or replace it if sarary is not appended...
Thanks in advance
I'm using Append Q to append salary every month to all the staff of my company.
The month and year of my master table is a primary key so they don't accept duplicates.
After Appending, I put MsgBox "Salary Appended Successfully". But if the user choose same month and year, the result will not be appended which is right, but the MsgBox will come.
Is there any way to stop this MsgBox or replace it if sarary is not appended...
Thanks in advance