Vba parameter adodb null value

Dim cmd As New ADODB.Command
Dim p1 As ADODB.Parameter
' use Null as value
set p1 = cmd.CreateParameter("param_name", adVarChar, adParamInput, 50, Null)
p1.Attributes = adParamNullable  
cmd.Parameters.Append p1

Source: stackoverflow.com

Similar codes

0 vote188 views1 answer
Vba argument is set
VBA
0 vote190 views1 answer
Change "location" of binding navigator vb
VBA
0 vote210 views1 answer
Vbscript check if string is empty
VBA
0 vote198 views1 answer
Vb get ip address
VBA
0 vote204 views1 answer
Add text to combobox drop down vb
VBA
1 vote171 views1 answer
Vba listindex select multiple items vba
VBA
9 votes474 views2 answers
Excel vba convert 2 Short integers to a Long integer
VBA
5 votes217 views1 answer
Excel-vba get integer high byte
VBA
0 vote194 views1 answer
Type excel.application is not defined vb
VBA
0 vote193 views1 answer
Excel VBA web scraping
VBA