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

3 votes134 views1 answer
Excel vba get the workbook full filename with path
VBA
0 vote108 views1 answer
Quit excel with save changes dialog vb.net
VBA
1 vote123 views1 answer
Textbox find and replace vb
VBA
0 vote121 views1 answer
Excel last used row
VBA
0 vote132 views1 answer
Excel filter by date not working vba
VBA
0 vote129 views1 answer
Enable macros on opening workbook vba
VBA
0 vote121 views1 answer
Find days in month vba
VBA
0 vote159 views1 answer
Vbnet check if string is only letters
VBA
0 vote126 views1 answer
Vba loop through table
VBA
8 votes130 views1 answer
Excel vba make integer
VBA