Hello Old Pedant
Thank you for your reply.
I am still getting this error:
Microsoft JET Database Engine error '80040e14'
Syntax error in INSERT INTO statement.
Apparently, "This commonly occurs when your field name is a reserved word" (http://www.adopenstatic.com/faq/80040e14.asp
However, I have visited here: http://support.microsoft.com/?id=248738
, and I haven't used any of those reserved words.
The fields I have are:
fullName (text field)
So, I decided that the syntax is wrong because I haven't used the '#' correctly. It seems that you use it instead of the inverted comma. I am not sure if it is related, but the dispatched/my_dispatched field is a text field in my MDB, not a date/time, or numeric field.
I have tried different combinations and this is what I now have:
sSQL="INSERT INTO tblWolf " _
& "(fullName, wolfID, telNo, address, email, description, received, action, dispatched)" _
& " VALUES ('" & my_fullName & "', " & my_wolfID & ", " & my_telNo & ", '" & address & "', '" & my_email & "', '" & my_description & "', #" & my_received & "', '" & my_action & "', '" & my_dispatched & "')"
As I say, this generates the error message above.
If you could throw any light on this labyrinth of confusion, I would be grateful.