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 vote164 views1 answer
Change the first item in a queue vb.net
VBA
0 vote199 views2 answers
Get unique random number in vb.net
VBA
8 votes189 views1 answer
Run command pormpt in background windows
VBA
5 votes185 views2 answers
Excel vba write to the windows registry
VBA
0 vote165 views1 answer
Vba get workbook name
VBA
4 votes177 views1 answer
Excel vba how to programmatically remove the marching ants after range copy
VBA
1 vote159 views1 answer
Vba declare api 64 bit 32 bit
VBA
1 vote165 views1 answer
Excel vba last column in range
VBA
1 vote111 views1 answer
Ms access open form to new record
VBA
3 votes192 views1 answer
Extract word in a text in excel
VBA