In the sub below i get an error:
Run-time error '3061':
too few parameters, expected 2.
[VBA]Private Sub RUN_Click()
Dim filename As Variant
Dim daterecd As Variant
Dim strSQL As String
filename = txtFileName.Value
daterecd = txtDateRecd.Value
Set db = CurrentDb()
strSQL = "INSERT into gwexport (filename, daterecd) Values (" & [filename] & ", " & [daterecd] & ")"
Debug.Print strSQL
db.Execute strSQL
End Sub[/VBA]
Table gwexport:
filename is text
daterecd is text
Where am i going wrong?
Let me know if you need more information.
Thanks