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 vote161 views1 answer
Dlete rows with blanks and space " " vba
VBA
0 vote178 views2 answers
Get unique random number in vb.net
VBA
5 votes160 views1 answer
Excel vba left word from Long Integer
VBA
0 vote150 views1 answer
Freeze panes vba
VBA
0 vote156 views1 answer
Vbnet find highest value in chart
VBA
0 vote183 views1 answer
Excel vba unlock sheet without password
VBA
1 vote155 views1 answer
Set font for ms chart vb.net
VBA
0 vote142 views1 answer
Excel vba milliseconds
VBA
0 vote160 views1 answer
Arq linux
VBA
0 vote144 views1 answer
Excel vba formatconditions positive
VBA