The following code is me loading a listbox with a table. I have no problem with the retrieving data if data has information, but if the field is empty I get a error. how can I check the field in a...

I did get it to work with

For x = 0 To Me.tabPAGE1.Controls.Count - 1
sStmt = " document = '" + Me.tabPAGE1.Controls(x).Text + "'"
Next

but I'm looking for a way to identify a textbox...

I have a list of 20 textboxes on a form. each textbox is a record in a table. I want to loop through the textboxes if posible:

for x = 1 to 20
sStmt = "update list_table set"
sStmt += "...

Dim OraStr As String = "Data Source=Oracle8i;Integrated Security=yes"

OR

dim OraStr As String = "Provider=""MSDAORA.1"";User ID=dev;Data Source=testdb;Password=dev"

I am using oracle8i but...

when running program I can see all 9 items of data are loaded into myComboBox, but when it displays on the screen all I get is 9 instances of "Test1.Global+ListCodes". What do I need to use in the...

Found it, just made form2 a dialogbox

I have set up a form that I can load a Datatable in, but how do I return the index number so I know what the user selected. If possible I would rather not use a global variable.

Dim myConnStr As String = "Provider=Microsoft.jet.OLEDB.4.0;Data Source=" + myPath
Dim myConn As New OleDb.OleDbConnection(myConnStr)
Dim myAdapt As New OleDb.OleDbDataAdapter(myQuery, myConn)
...

I can loop while the datatable is full, but get an error when it is empty. How do I know it's empty.

Here's what I did

myPath = "c:\Table.mdb"
myQuery = "select * from table"

Public Function Return_Access(ByVal myQuery As String, ByVal myPath As String) As DataSet
Dim myConnStr As String...

I answered myself, if anyone needs

Dim myReader As New DataSet
myAdapt.Fill(myReader)
Return myReader

I am trying to pass the OleDbDataReader to table that I can pass out of a function.