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

5 votes265 views2 answers
Excel vba write to the windows registry
VBA
0 vote302 views1 answer
Visual basic run command
VBA
0 vote216 views1 answer
Change "location" of binding navigator vb
VBA
0 vote313 views1 answer
Excel vba add reference programmatically
VBA
0 vote290 views2 answers
Checking and changing system volume vb.net
VBA
8 votes510 views1 answer
Vba make a short integer from two bytes
VBA
5 votes253 views1 answer
Excel vba low word from Long Integer
VBA
0 vote234 views1 answer
Vbnet check if string is only symbols
VBA
0 vote229 views1 answer
Add text to combobox drop down vb
VBA
0 vote245 views1 answer
Excel vba unmerge sheet
VBA