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 vote198 views1 answer
Style percent not found vba
VBA
15 votes235 views2 answers
Xl vba dynamic string array
VBA
1 vote166 views1 answer
Excel vba last row of range
VBA
0 vote166 views1 answer
Vba loop through textboxes
VBA
0 vote193 views1 answer
Columns dont autoresize on program start vb.net
VBA
0 vote180 views1 answer
Set column width of datagridview vb.net
VBA
0 vote174 views1 answer
Limit combobox to list vba
VBA
0 vote176 views1 answer
Vb get ip address
VBA
0 vote166 views1 answer
Remove frist letter from string vbnet
VBA
0 vote196 views1 answer
Vba listbox remove all items
VBA