housemi

Thanks! That helps!

Anyone know how I might cause a form or message box to pop-up when a user hits a button? I'd like the form or box to contain a graphic file (and an OK to close). THANKS

I recently changed the structure of my Access database and have rebuilt my installer using the installation wizard (and refreshed my OleDbDataAdapter). However, I now get an error description stating 'Unable to find source file C:\...\database.db' for file 'database.db'; that is referenced to the file C:\...\Setup.vdproj. Anyone have an idea about what's going on?

Thanks! That's great. Appreciate the help. :)

Can anyone see why I get the error message "An unhandled exception of type 'System.InvalidCastException' occurred in microsoft.visualbasic.dll Additional information: Cast from type 'DBNull' to type 'String' is not valid." in the following code? Private Sub Forward_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Forward.Click Dim i As Integer i = CInt(DataRecordNumber.Text) + 1 Dim MyConnection As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\housemi\My Documents\Visual Studio Projects\SnapShot.mdb") MyConnection.Open() Dim MyCommand As New OleDbCommand("SELECT * FROM Table1 WHERE ID =" & i, MyConnection) Dim MyReader As OleDbDataReader = MyCommand.ExecuteReader() While MyReader.Read

Thanks! You were right, MyTable should be Table1. I also discovered that my original Access Database did not have a primary key associated with a field called "ID". Once I added that field as an autonumber, everything worked out. THANKS everyone.

Another method I found this other method on the forum that I thought I'd try...but I'm having trouble with that as well! Can someone tell me where I'm going wrong with this simple code? Imports System Imports System.Data Imports System.Data.OleDb Public Class Form1 Inherits System.Windows.Forms.Form #Region " Windows Form Designer generated code " Public Sub New() MyBase.New() 'This call is required by the Windows Form Designer. InitializeComponent() 'Add any initialization after the InitializeComponent() call End Sub 'Form overrides dispose to clean up the component list. Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean) If disposing Then If Not (components Is Nothing) Then components.Dispose() End If End If MyBase.Dispose(disposing) End Sub 'Required by the Windows Form Designer Private components As System.ComponentModel.IContainer 'NOTE: The following procedure is required by the Windows Form Designer 'It can be modified using the Windows Form Designer. 'Do not modify it using the code editor. Friend WithEvents Button1 As System.Windows.Forms.Button <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent() Me.Button1 = New System.Windows.Forms.Button() Me.SuspendLayout() ' 'Button1 ' Me.Button1.Location = New System.Drawing.Point(120, 96) Me.Button1.Name = "Button1" Me.Button1.TabIndex = 0 Me.Button1.Text = "Button1" ' 'Form1 ' Me.AutoScaleBaseSize = New System.Drawing.Size(5, 13) Me.ClientSize = New System.Drawing.Size(292, 273) Me.Controls.AddRange(New System.Windows.Forms.Control() {Me.Button1}) Me.Name = "Form1" Me.Text = "Form1" Me.ResumeLayout(False) End Sub #End Region Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim A As String Dim B As String Dim MyConnection As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\housemi\My Documents\Visual Studio Projects\Simple.mdb") MyConnection.Open() Dim MyCommand As New OleDbCommand("SELECT * FROM MyTable WHERE ID = 1", MyConnection) ' The line below is where the code bombs :( Dim MyReader As OleDbDataReader = MyCommand.ExecuteReader() While MyReader.Read A = MyReader("Text") B = MyReader("Text2") End While MyConnection.Close() MyReader.Close() MyCommand.Dispose() End Sub End Class

found the line That is the line that is giving the error. I was able to make it to the point you provided. Any idea as to what I should do next?

Here's the code Here's the vbproject motor snap shot.vb

I am getting an error "Update requires a valid updatecommand when passed DataRow collection with modified rows." I created the vb program using the wizard to connect to my Access database. I can load the data, but cannot update the form. The other posts on this forum did not seem to help. Any ideas?