Hey all, hope everyone is well. I have a dilema that I hope you guys can help me with. I have created an Access database (that I am currently running from my workstation) that has multple linked tables to a SQL DB on a stand-alone server. I have a form that I allow users to enter information in several text boxes and combo boxes. When the user hits the 'Enter' button, I want to insert these records into a table in a SQL DB.
I am getting a "Run-time error '3024': Could not find output table 'ProjectNotes'.
I believe I have some connection info incorrect in my VB code within the form but cannot figure out what it is. My code is below:
Private Sub cmdEnter_Click()
Dim adoConn As New ADODB.Connection
Dim connString As String
connString = "Driver={SQL Server};Server=10.20.100.22;Database=TestDatabase; Uid=TestUserID;Pwd=TestPass;"
adoConn.ConnectionString = connString
adoConn.Open connString
Dim strSQL As String
Dim strProjectTitle As String
Dim strNotes As String
Dim strResponsibleProf As String
Dim strAddingDateTime As String
Dim strTargetedCompletionDate As String
Dim strNotesEnteredBy As String
Dim strMeetingTitle As String
'set variable values
strProjectTitle = Me.cboProject.Value
strNotes = Me.txtNotes.Value
strResponsibleProf = Me.cboRespProf.Value
strAddingDateTime = Me.txtAddingDateTime.Value
strTargetedCompletionDate = Me.txtTargetedCompletionDate.Value
strNotesEnteredBy = Me.cboNotesEnteredBy.Value
strMeetingTitle = Me.cboMeeting.Value
strSQL = "Insert Into ProjectNotes ([ProjectTitle],[Notes],[ResponsibleProfessional],[AddingDateTime],[TargetedCompletionDate],[NotesEnteredBy],[MeetingTitle]) Values ('" & strProjectTitle & "','" & strNotes & "','" & strResponsibleProf & "'," & strAddingDateTime & "," & strTargetedCompletionDate & ",'" & strNotesEnteredBy & "','" & strMeetingTitle & "');"
DoCmd.RunSQL strSQL
End Sub
...Can anyone tell from a quick glance what I am doing incorrectly here? I have been playing with this for about a week now and have used what I could from online forums and sources but am now stuck on this error. I appreciatte any help in advance, thanks!!!!!