Advertisement

06.22.2008 at 12:05AM PDT, ID: 23505411
[x]
Attachment Details

Item cannot be found in the collection corresponding to the requested name or ordinal

Asked by awolarczuk in .NET

Tags: Item cannot be found in the collection corresponding to the requested name or ordinal.

Ok guys i cant work out why i keepp getting this message, i have check the debug.print out putin access and it works with no problems, and i have checked to make sure that this information is in the database and all the spelling is correct and it is, i guess  if it wasnt it wouldnt be working in access the out put i am getting in the debug windows is

 select * from [Student_Outcomes] where [OutcomeDate]  = #10/09/2007# And [StudentID] = 60

and then a message

A first chance exception of type 'System.Runtime.InteropServices.COMException' occurred in adodb.dll

Thanks in advance guys
Start Free Trial 
1:
2:
3:
4:
5:
6:
7:

Dim rs As New ADODB.Recordset
        Dim sql As String
        sql = "select * from [Student_Outcomes] where [OutcomeDate]  = #" & ListView2.SelectedItems.Item(0).SubItems(1).Text & "# And [StudentID] = " & TextBox7.Text
        Debug.Print(sql)
        studentnotes.Text = ""
        studentnotes.Text = (rs.Fields("OutcomeNotes").Value)
        rs.Close()
[+][-]06.22.2008 at 01:07AM PDT, ID: 21840017

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.22.2008 at 01:09AM PDT, ID: 21840019

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.22.2008 at 02:07AM PDT, ID: 21840093

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.22.2008 at 02:09AM PDT, ID: 21840096

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.22.2008 at 03:21AM PDT, ID: 21840189

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.22.2008 at 03:22AM PDT, ID: 21840191

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.22.2008 at 03:26AM PDT, ID: 21840200

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.22.2008 at 03:31AM PDT, ID: 21840209

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.22.2008 at 03:58AM PDT, ID: 21840253

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.22.2008 at 04:06AM PDT, ID: 21840272

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: .NET
Tags: Item cannot be found in the collection corresponding to the requested name or ordinal.
Sign Up Now!
Solution Provided By: angelIII
Participating Experts: 2
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628