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

0 vote199 views1 answer
Enter into cells data grid view
VBA
2 votes208 views1 answer
Vba ado ace sql alias ignored for calculated column
VBA
0 vote216 views1 answer
Vba listbox remove all items
VBA
1 vote212 views1 answer
If inputbox cancel vba
VBA
0 vote225 views1 answer
VBA
VBA
1 vote213 views1 answer
How to INPUT text in shape with enter and spacein vba
VBA
0 vote211 views1 answer
Menus act like radio buttons vb.net
VBA
0 vote199 views1 answer
Hello world vb.net
VBA
0 vote225 views1 answer
Vba character ascii code
VBA
2 votes189 views2 answers
Constructor vb.net
VBA