WILDDUSTIE
04-09-2017, 06:17 PM
I am relatively new to programming and have an issue I can't seem to overcome. I need to insert a record into an access table based on entries from a userform. I'm getting a syntax error on my sql query:
strSQL = "INSERT INTO appointment SET APPTID = '" & SETAPPTUF.apptid & _
"', SET DOCTORID = '" & SETAPPTUF.drid & _
"', SET PATIENTID ='" & SETAPPTUF.ptid & "'" & _
"', SET APPTTIME ='" & SETAPPTUF.apptdate & "'"
Any help is appreciated.
strSQL = "INSERT INTO appointment SET APPTID = '" & SETAPPTUF.apptid & _
"', SET DOCTORID = '" & SETAPPTUF.drid & _
"', SET PATIENTID ='" & SETAPPTUF.ptid & "'" & _
"', SET APPTTIME ='" & SETAPPTUF.apptdate & "'"
Any help is appreciated.