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

1 vote224 views1 answer
Vba refresh pivot table
VBA
0 vote239 views1 answer
Excel vba protect shapes
VBA
5 votes252 views1 answer
Excel vba get user selected range
VBA
1 vote221 views1 answer
Excel vba close form escape key
VBA
2 votes231 views1 answer
Excel vba check if string entirely numeric
VBA
0 vote247 views1 answer
How to mount floppy disks in vb.net
VBA
6 votes233 views1 answer
Excel vba check if a string only contains letters
VBA
0 vote249 views1 answer
Vba remove the first character of string
VBA
1 vote235 views1 answer
Extract the second word in a text in excel
VBA
0 vote248 views1 answer
Find database connection string vb
VBA