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 vote163 views1 answer
Search combobox items vb.net
VBA
8 votes177 views1 answer
Excel vba make integer
VBA
0 vote149 views1 answer
Excel vba ternary
VBA
6 votes170 views1 answer
Excel vba get the path of current workbook
VBA
0 vote146 views1 answer
Vba test optional argument
VBA
0 vote186 views1 answer
Vba foreach 2d array
VBA
0 vote155 views1 answer
Returns an array from function vba
VBA
1 vote152 views1 answer
VBA Loop through recordset
VBA
4 votes154 views1 answer
Vba create directory
VBA
2 votes158 views1 answer
Vba ado ace sql alias ignored for calculated column
VBA