Search results

  1. B

    Solved Insert INTO if not exist

    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...
  2. B

    Solved VBA Code not looping through Outlook inbox

    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...
Top Bottom