-
Adding a line to an acces table from a vba userform
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.
-
Thanks to anyone who looked at my problem, but I have it figured out now.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules