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 vote347 views2 answers
Vba find last row in range for certain criteria
VBA
1 vote323 views2 answers
Vba string length
VBA
2 votes306 views1 answer
Vba round number
VBA
0 vote312 views1 answer
Excel vba protect content
VBA
31 votes449 views1 answer
Excel vba function to convert column number to letter
VBA
0 vote300 views1 answer
Excel R1C1 mode
VBA
2 votes296 views1 answer
Date format for ms chart vb.net
VBA
0 vote305 views1 answer
Vba sort multiple columns
VBA
0 vote310 views1 answer
How to use if condition in time vba
VBA
0 vote299 views1 answer
Excel vba center userform
VBA