NauticalGent
Ignore List Poster Boy
- Local time
- Today, 08:11
- Joined
- Apr 27, 2015
- Messages
- 6,712
Well almost...Right on, glad you found it useful!
Cheers,
Trying to adapt it to use with an INSERT statement:
Code:
strSQL = INSERT into tblCombinedStatus ([FolderNumber], [CombStatus]) VALUES ('" & strFolderNumber & "','" & strStatus & "')"
With CurrentDb.CreateQueryDef("", SQL)
.Parameters(0) = strFolderNumber
.Parameters(1) = strStatus
.Execute dbFailOnError
.Close
End With
But I get an "Item not found in this collection" error. I know it is because I didn't set the fields to anything but everything I have tried cant get past the compiler...
I originally just used the Replace() function to remove all the Chr(34) and Chr(39) characters and it runs until it hits some other BS character I didn't account for.
What really chaps my behind is that I found something a few years ago that handled this issue but cant find it now.
Any ideas?
Edit: The error I get is 3075 - Syntax error (missing operator) blah, blah, blah
Last edited: