Vba createparameter null

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

6 votes161 views1 answer
Excel vba check if a string only contains letters
VBA
0 vote151 views1 answer
How to get the value of optionbutton in vba
VBA
0 vote178 views2 answers
Get unique random number in vb.net
VBA
0 vote149 views2 answers
How to concatenate more than 40 lines in vba
VBA
0 vote163 views4 answers
Jwt token vb.net validation
VBA
1 vote162 views1 answer
Find and replace textbox
VBA
0 vote141 views1 answer
Vba word pdf table to excel
VBA
0 vote162 views1 answer
Vba remove the first character of string
VBA
0 vote163 views1 answer
VBA Sort RossetaCode
VBA
0 vote136 views1 answer
Style percent not found vba
VBA