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 vote166 views1 answer
Change form background image vb
VBA
0 vote156 views1 answer
How to format a textbox as date vb net
VBA
0 vote156 views1 answer
Loop through lines in text file vb net
VBA
0 vote170 views2 answers
Do until loop vba
VBA
0 vote165 views4 answers
How to continue formula in below line in vba code
VBA
0 vote164 views1 answer
VBA Sleep Snippet
VBA
0 vote164 views1 answer
Vbscript check if string is empty
VBA
0 vote105 views1 answer
Excel autofilter vba
VBA
1 vote148 views2 answers
Vba remove first 2 characters from string
VBA
18 votes307 views3 answers
Excel-vba make integer
VBA