Hello,
Without getting into great detail, I have a query that worked when I constructed it in MS Access Queries (static data)but now that I am trying to get it to work in VBA (dynamic data) it claims that I have a Datatype Mis-Match (Error 13).
I have ensured all my fields are of the same datatype and match up perfectly. (I am going to check, again, after typing this post.)
I have tested small Insert statements on other tables within VBA and they worked fine within the same code.
I have inserted a MsgBox to make sure the SQL string has been constructed properly and looks identical to the one in Access.
What gives?
Any help is appreciated.
Without getting into great detail, I have a query that worked when I constructed it in MS Access Queries (static data)but now that I am trying to get it to work in VBA (dynamic data) it claims that I have a Datatype Mis-Match (Error 13).
I have ensured all my fields are of the same datatype and match up perfectly. (I am going to check, again, after typing this post.)
I have tested small Insert statements on other tables within VBA and they worked fine within the same code.
I have inserted a MsgBox to make sure the SQL string has been constructed properly and looks identical to the one in Access.
What gives?
Any help is appreciated.