By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,306 Members | 1,673 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,306 IT Pros & Developers. It's quick & easy.

Solution for cmd.CreateParameter and Access memo field types

P: n/a
It took me way too long to figure this out and I saw a lot of
unanswered questions regarding how to deal with ms-Access memo fields
and creating SP parameters. This is what I finally figured out and it
works (and works with null values as well...

Dim myMemoLen as long, myFrm as string
myFrm = "myFormName"

With Forms(myFrm)

myMemoLen = Nz(Len(.myMemoFieldName), 1)

Set prm = cmd.CreateParameter("myMemoFieldName", _
adLongVarWChar, adParamInput, myMemoLen, .myMemoFieldName)
cmd.Parameters.Append prm

End With

cmd.Execute Options:=adExecuteNoRecords
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.