Hi,
i am developing a annaula leave system for my HR deprtment.
i find some examples from book with below coding:
conn.Execute “insert into HRVacatRequests (WhenRequested, EmpName, EmpEmail, ” _
& “FromDate, ToDate, Purpose, Status, DepartmentID) values (” _
& “‘” & CurrentDateTime & “‘, ” _
& “‘” & Request.Form(“EmpName”) & “‘, ” _
& “‘” & Request.Form(“EmpEmail”) & “‘, ” _
& “‘” & Request.Form(“FromDate”) & “‘, ” _
& “‘” & Request.Form(“ToDate”) & “‘, ” _
& “‘” & Request.Form(“Purpose”) & “‘, ” _
& “‘Approved’, ” _
& Request.Form(“DepartmentID”) & “)”
may I know how can i translate it into access database because when i try to run this program i got error said that the insert into is for SQL
pls assist
