Filling list boxes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Michael D. Reed - 07 Nov 2007 23:16 GMT

I am trying to use a table value function in a SQL server to fill a list box.
I keep getting the following error message “Microsoft OLE DB Provider for
SQL Server --> The parameter is incorrect.” When I the objCmd.Execute is
Executed the statement in the code snipe below.
Dim objConn As New ADODB.Connection
Dim objCmd As New ADODB.Command
Dim objParm1 As New ADODB.Parameter

' Set CommandText equal to the stored procedure name.
objCmd.CommandText = "GetByModelUnassignedOptions"
objCmd.CommandType = adCmdStoredProc

' Connect to the data source.
Set objConn = Application.CurrentProject.Connection

objCmd.ActiveConnection = objConn

' Automatically fill in parameter info from stored procedure.
objCmd.Parameters.Refresh

' Set the param value.
objCmd.Parameters(1) = Me.Model_ID

' Get the data
Dim objRS As Object
Set objRS = objCmd.Execute
I am using Access 2003 and SQL Server 2005.
Where can I get a code example to fill a list box when ever the parent form
record changes?

Signature

Mike Reed

Reply to this Message

Peter Yang[MSFT] - 08 Nov 2007 05:56 GMT

Hello Mike,

You may try the following code:

objCmd.Parameters(1).value = Me.Model_ID

or

objCmd.Parameters("@parametername")= Me.Model_ID

If the issue persists, you may try to add the parameter manually to isolate
the issue:

cmd.Parameters.Append cmd.CreateParameter("RetVal", 3, adParamReturnValue)

Please let's know if you have any update. Thank you.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Reply to this Message