Good morning I have this insert command and I got "INVALID PROPERTY VALUE" error some times. The field ordcomments is a memo type.
Isql = "INSERT INTO ordStatus ( stDate, RecLoc, StatusID, ordcomments, empid )"
'Isql = Isql & " Values (date(),[Forms]![orders].form![RecLocationFrm]![RecLoc],'XSL', [Forms]![requestReportsDialog]![txtStrStatusComments] & ' ' & [Forms]![requestReportsDialog]![Text97], [Forms]![requestReportsDialog]![intempNumber]);"
'Set qdf = CurrentDb.CreateQueryDef("", Isql)
'For Each prm In qdf.Parameters
'prm.Value = Eval(prm.name)
'Next prm
'qdf.Execute dbFailOnError
'*******************************
And this command works ok always.
DoCmd.Hourglass True
Set rs = db.OpenRecordset("ordstatus", dbOpenDynaset)
rs.AddNew
rs!RecLoc = Forms!orders.Form!RecLocationFrm!RecLoc
rs!StDate = Date
rs!StatusID = "XSL"
rs!OrdComments = ([Forms]![requestReportsDialog]![txtStrStatusComments] & "...>" & [Forms]![requestReportsDialog]![Text97]) '"Status Letter To CLIENT"
rs!Empid = intEmpIDNumber 'DLookup("[Empid]", "Employees", "[UserName]= '" & strUserLoginName & "'")
rs.Update
I like to know what command is faster is the best one to use in my program. In advance thank you for your help.