VB.Net and MS Access

  • Thread starter Thread starter A
  • Start date Start date
A

A

I am trying to build a VB.Net application for a MS Access database. I
have managed to create the database connection and also the data
adapter. However, when I try to create the dataset it tells me there
are errors and I must build the application. When I build the
application I get the following error: "Overload resolution failed
because no 'Item' is accessible" I get this error for all of the
columns in the MS Access table I am trying to work with. Does anyone
have any ideas on how to fix this?

A. Wem
 
* A said:
I am trying to build a VB.Net application for a MS Access database. I
have managed to create the database connection and also the data
adapter. However, when I try to create the dataset it tells me there
are errors and I must build the application. When I build the
application I get the following error: "Overload resolution failed
because no 'Item' is accessible" I get this error for all of the
columns in the MS Access table I am trying to work with. Does anyone
have any ideas on how to fix this?
Click to expand...

"Post code."

BTW: Doubleclick the error in the task list to see
the line that causes the error.
 
These are the lines of code that are refereced when I double click on
the Errors. I am new to VB.Net and I'm not sure what other parts of the
code would be needed to help figure out this error.

Friend Sub InitVars()
Me.columnAC = Me.Columns("AC")
Me.columnBA = Me.Columns("BA")
Me.columnC = Me.Columns("C")
Me.columnCENS90CD = Me.Columns("CENS90CD")
Me.columnCENS90TL = Me.Columns("CENS90TL")
Me.columnCL = Me.Columns("CL")
Me.columnCO = Me.Columns("CO")
Me.columnCOLLCODE = Me.Columns("COLLCODE")
Me.columnCR = Me.Columns("CR")
Me.columnCV = Me.Columns("CV")
Me.columnCW = Me.Columns("CW")
Me.columnDATA = Me.Columns("DATA")
Me.columnDE = Me.Columns("DE")
Me.columnDLU = Me.Columns("DLU")
Me.columnDLUX = Me.Columns("DLUX")
End Sub

A. Wem
 
* A said:
These are the lines of code that are refereced when I double click on
the Errors. I am new to VB.Net and I'm not sure what other parts of the
code would be needed to help figure out this error.

Friend Sub InitVars()
Me.columnAC = Me.Columns("AC")
Me.columnBA = Me.Columns("BA")
Me.columnC = Me.Columns("C")
Me.columnCENS90CD = Me.Columns("CENS90CD")
Me.columnCENS90TL = Me.Columns("CENS90TL")
Me.columnCL = Me.Columns("CL")
Me.columnCO = Me.Columns("CO")
Me.columnCOLLCODE = Me.Columns("COLLCODE")
Me.columnCR = Me.Columns("CR")
Me.columnCV = Me.Columns("CV")
Me.columnCW = Me.Columns("CW")
Me.columnDATA = Me.Columns("DATA")
Me.columnDE = Me.Columns("DE")
Me.columnDLU = Me.Columns("DLU")
Me.columnDLUX = Me.Columns("DLUX")
End Sub
Click to expand...

What's 'Me'? I mean, in what class do you have this code?
 
Back
Top