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

0 vote219 views1 answer
Reference to a non-shared member requires an object reference
VBA
0 vote219 views1 answer
Search combobox items vb.net
VBA
2 votes225 views1 answer
Vba file from path
VBA
0 vote184 views1 answer
Vbnet make a string to unicode converter
VBA
0 vote198 views1 answer
Vba first cell in range
VBA
0 vote147 views1 answer
Vba select file in folder
VBA
0 vote227 views1 answer
Filesystemobject vba reference
VBA
0 vote252 views1 answer
Vba userform textbox wrap text
VBA
0 vote245 views1 answer
Vba cell all borders
VBA
0 vote213 views1 answer
Telephon call in vba
VBA