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 vote142 views1 answer
Vb streamreader
VBA
0 vote142 views1 answer
Excel vba disable copy paste
VBA
0 vote140 views1 answer
Excel vba concatenate range
VBA
1 vote101 views1 answer
How to open cmd with vbd
VBA
0 vote144 views1 answer
Do while not vb.net
VBA
0 vote144 views1 answer
Vba change named range address
VBA
5 votes166 views1 answer
Excel-vba get integer high byte
VBA
3 votes178 views2 answers
Vba date to string
VBA
0 vote154 views1 answer
Loop through all text boxes in a form vb
VBA
0 vote142 views1 answer
Loop through lines in text file vb net
VBA