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

1 vote242 views1 answer
Vba login website
VBA
0 vote271 views1 answer
How to mount floppy disks in vb.net
VBA
0 vote239 views2 answers
Get excel file from email attachment in vba
VBA
1 vote233 views1 answer
Vba delete file
VBA
0 vote229 views1 answer
Quit excel with save changes dialog vb.net
VBA
2 votes241 views1 answer
Excel vba check if string entirely alpha
VBA
1 vote256 views1 answer
Vba loop through files in folder
VBA
0 vote238 views1 answer
Windows Presentation Foundation dark title bar
VBA
0 vote257 views1 answer
Method showalldata of object _worksheet failed vba
VBA
0 vote240 views1 answer
Excel vba automatic calculation
VBA