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 vote230 views1 answer
Visual basic cmd
VBA
1 vote178 views1 answer
How to put a gridpain in a vbox
VBA
-1 vote213 views1 answer
How save excel through visual basic
VBA
0 vote205 views1 answer
Vba dictionary clear
VBA
0 vote168 views1 answer
How to set location and size of new from vb
VBA
12 votes330 views1 answer
Excel vba write string to text file
VBA
0 vote181 views1 answer
Windows Presentation Foundation dark title bar
VBA
0 vote175 views1 answer
Limit combobox to list vba
VBA
0 vote193 views1 answer
Group controls programmatically vb
VBA
0 vote190 views1 answer
Excel vba open browser
VBA