This MIGHT help:

The FSO model is contained in the Scripting type library, which is located in the file Scrrun.dll. If you don't already have a reference to it, you can create one.

To create a reference to the Scripting type library (Scrrun.dll)

1. On the Project menu, click Add Reference, and then click the COM tab.
2. Choose Microsoft Scripting Runtime from the Component Name list, and then click Select.

You can now use the Object Browser to view the FSO model's objects, collections, properties, methods, events, and constants.

My goal in life is to be the kind of person my dog thinks I am.

I am trying to write a simple procedure to update a record in a data base using the following:

Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
If m_dtEmployees.Rows.Count <> 0 Then
m_dtEmployees.Rows(m_rowPosition)("Employee") = txtEmployeeName.Text
m_dtEmployees.Rows(m_rowPosition)("Password") = txtPassword.Text
m_daDataAdapter.Update(m_dtEmployees)
End If
End Sub
End Class

If I make a change to the txtEmployeeName textbox and hit save it works fine. If I make a change in the txtPassword text box I get a Syntax error in UPDATE statement error. I used the m_dtEmployees.Columns.Contains method to check to make sure it saw "Password" as a column and it does... Any thoughts?

My goal in life is to be the kind of person my dog thinks I am.

Excellent,thanks.

My goal in life is to be the kind of person my dog thinks I am.

I am working on a project trying to get my DB and VB.NET skills up to speed. I have established a connection to my database and linked a combobox to the database thusly:

ComboBox1.DataSource = techDataSet.Tables("tblEmployee")
ComboBox1.DisplayMember = "EmployeeName"

However this puts the first record into the "textbox" portion of the ComboBox. I would prefer the ComboBox "textbox" portion to be empty and all the database information be in the dropdown... Any help would be appreciated.

My goal in life is to be the kind of person my dog thinks I am.