Consulting

Results 1 to 2 of 2

Thread: Adding a line to an acces table from a vba userform

  1. #1

    Question 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.

  2. #2
    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
  •