Search results for query: *

Problem Solved Hi, I've managed at long last to solve the problem, it was as simple as realising that I should use 1 OleDbAdapter per table, not trying to use one to deal with all the tables... :S Program itself is looking great now, bluetooth barcode reader working and all! Thanks again...

Hi, just got back from England last night, so I haven't had time to look again at this problem, but I'll do so later this afternoon, and I'll doubtless have more questions. Thanks for the continuing support! :D

Ah this looks brilliant, thank you both for all the help so far! Unfortunately it's a bit late in the evening for me to work at this, but I'll take a look tomorrow, and I'll let you know how I got on! Thank you very much again! P.

This is the code with some of the crap removed, like the timers to make the form expand in a sliding manner :D Dim TableInt As Int16 Dim Table AsString Dim SQLString AsString Dim dtViewTable AsNew DataTable Dim Adapter As OleDbDataAdapter Dim ConnectString AsString = "Provider =...

I'm totally flummoxed by this now... This is the error I get, and where the error occurs.

Everything there is copied from a VB.Net book... Unfortunately working with databases is one of my weakest areas in computing... I'll try this stuff now though.

Dim TableInt As Int16 Dim Table AsString Dim SQLString AsString Dim dtViewTable AsNew DataTable Dim Adapter As OleDbDataAdapter Dim ConnectString AsString = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source = LibDB.mdb" PrivateSub btnLoad_Click(ByVal sender As System.Object, ByVal e As_...

That line was my attempt at trying to solve the problem the exception was talking about. Perhaps if I post all the code from that form, will that be able to clear a few things up?

Okay, I've had a stab at the second part of it, but I'm stuck on the first part. My code is as follows: Private Sub btnUpdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUpdate.Click dtViewTable.NewRow() Dim cmd As New OleDbCommand cmd.Connection =...

Awesome! Thank you, I'll give it a shot this evening after school! P

Okay, I've taken a look at the examples, but I still don't see anything about using the changes made to the datagrid. The way I'm seeing this is that the datagrid is a vehicle for representing the data in the way that MS Access itself does. Sure enough, I'm able to fill the grid with the...

Nice, thank you I'll take a look this evening and get back to you! P

I'd read about that somewhere... I'll check the tutorials when I've got a bit more time on my hands, but can I safely ask for some example code here? Thanks again P

Hi people! I've had a look at the existing threads, but either they don't quite match my question or I'm being way too blind and n00b like to understand. My task: Creating a library system using VB.Net and MS Access. My problem: I can't figure out what I have to do in order to update...