S
Souris
Dim qd As DAO.QueryDef
Set qd = EISDb.QueryDefs("MYQUERY")
qd.Parameters("pComments").Value = CStr(Replace(Me!
txtComments.Value, Chr(34), Chr(34) & Chr(34)))
qd.Execute
I have above code which failed when the comment has 874 characters and
double quotes, single quote and number sign on it.
Are there any limitations to pass paramter to a query?
Your information is great appreciated,
Set qd = EISDb.QueryDefs("MYQUERY")
qd.Parameters("pComments").Value = CStr(Replace(Me!
txtComments.Value, Chr(34), Chr(34) & Chr(34)))
qd.Execute
I have above code which failed when the comment has 874 characters and
double quotes, single quote and number sign on it.
Are there any limitations to pass paramter to a query?
Your information is great appreciated,