Search results

seems working

How would I append multiple values using that?

But there ll be other employees attendance for same date so if i add unique index it won't let me add their attendance for same date. I want look for records with 2 criteria before appending emp_id and atn_date

I want to append only data to payroll table if employee ID (Emp_ID) and attendance Date (Atn_Date) does not exist for employee in payroll table to avoid duplicate entries INSERT INTO Tbl_Payroll ( PR_ID, Emp_ID, Full_name, Payroll_Date, Payroll_Month, Payroll_Year, Basic_Daily_Wage...

Hi, Followed your advice managed to get it work. but SenderEmailAddress property does not contain a standard email address for internal contacts. for example for below example for internal emails it had a value similar to this: Is it possible that this code keeps running in background when...

i want VBA to scan the inbox for emails that are from todays date and if email contain a word "YES" then it should update the availability field of table to available based sender's email address and if the email has word "NO" then it should update the availability field of table to not...

i found this piece of code for excel online and trying to make it work for access but failed...Can u amend it please 🙏...i am newbie

Hi, Need Help 😵 i am trying to read emails from outlook for today and updating the access table based on specific keyword. however it just updates the first record and does not look for any other email. also it just goes not Elseif section of code even if there is first keyword is present in...

Not working..... if i keep the [Color=Blue"] it keeps giving error, removing it does not store data Sub AuditChanges(IDField As String, UserAction As String) 'On Error GoTo AuditChanges_Err Dim cnn As ADODB.Connection Dim rst As ADODB.Recordset Dim ctl As Control Dim...