mrdutchie

Still doesn't work.. I am getting Object reference not set to an instance of an object with mycmd.CommandText and mycmd.ExecuteNonQuery() so something else must be wrong too.

I'm stuck with my update statement for a access2000 file. I have a table called email with 2 fields. (name and email) I can Add to it just fine, but I can't update. This is what I have in my access table I have Name Email perry perry@hotmail.com peter peter@hotmail.com value1 = "newname" Dim mycn As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "C:/donation.mdb") Dim mycmd As OleDbCommand = New OleDbCommand mycmd.Connection = mycn mycmd.CommandText = "UPDATE email SET name=value1 WHERE name='perry' AND email='perry@hotmail.com')" mycn.Open() mycmd.ExecuteNonQuery() mycn.Close() it will fail on mycmd.ExecuteNonQuery() What am I doing wrong?

nm forgot a line

For some reason this part is always failing on me When I look at the report that comes when it's done. Everything is failded. Did you have that problem before'l

hmm think I got that part to work... not sure. I need to have VS.NET 2003 open so I can see the SQL server then I can use the sql-icon in the systray using \\dutchie\VBDOTNET Also I can past that screen from Access 2000 and I add all the tables that I want to convert... a few minutes later it failed with every table from that database. So that's part is still not working. I am using the integrated sec. cause other then that won't work. Now I created some tables within VB.NET / Server Explorer.. now let's see how I can show that within VB.NEt

Well, that didn't work either :( can you use MSDE with NO SQL server at all? Cause I don't have a SQL server.

Well, installed it and rebooted it, but not I am trying to do the example from the MS site, but doesn't work. When I look in my systray I have the sqlicoon and tried to select (local) but that doesn't work. for Access2000 i am doing the northwind database, but it's asking for username password.... well.... I don't know what?? I gave a password during install MSDE... but what is that username?

Thanks..... I'm downloading the 70Mb :cool:

I have VB.NET 2003 Architect and want to start using MSDE cause you can distibute that with you application. Now I know that this comes with SQL2000 Standard Edition, but I don't have that one. In VB.NET In the server Explorer, my PC is in it but no SQL server. so how can I create a SQL Database then? I heard it is possible with MSDE but I don't have that. Where to get the download version, since it's free (according to the other posts in this forum) Thanks so much

Seems like this part is not working right Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click Dim strConnection As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "C:/dbtest.mdb" Dim strCommand As String = "SELECT * FROM binFrm"''''''''''''''''' OpenAccess(strConnection, strCommand) End Sub Public Function OpenAccess(ByVal strConn As String, ByVal strComm As String) Dim i As Integer, x As Integer Dim DBCon As New OleDbConnection(strConn) DBCon.Open() Dim DBCommand As New OleDbCommand(strComm, DBCon) Dim DBAdapt(2) As OleDbDataAdapter '/// make an array of each table in your database. DBAdapt(1) = New OleDbDataAdapter(DBCommand) DBAdapt(2) = New OleDbDataAdapter(DBCommand) Dim DBset As New DataSet DBAdapt(1).Fill(DBset, "binFrm") DBAdapt(2).Fill(DBset, "Addresses") For i = 0 To DBset.Tables.Count - 1 Where you have Dim strCommand As String = "SELECT * FROM binFrm it fails on DBAdapt(1).Fill(DBset, "binFrm") DBAdapt(2).Fill(DBset, "Addresses") both are showing the same information If I change it to Dim strCommand As String = "SELECT * FROM binFrm,addresses then it will show for every table ALL the tables from both items how to make it seperate?

First give me a can of coffee and a 12-pack....

ok found it.... This is how I am doing it at this moment. PRoblem is that when I have to make a change to a form it's hard to get there. so multiple xxxx.vb forms would be easier

hmm still don't see where it loads a form within in panel on the other form.

euh don't see much on that link you gave me. Getting a Apache page ;-)

Yep, SpreeK nederlands... ben sinds me 30e verhuisd naar de USA :-) Voorheen woonde ik in Rotterdam....

I don't really want that. Just want to have a form showing within that panel... But I'll take a look... Bedankt...

Hi, I was wondering if this is possible. I have 2 forms frmmenu and frmbook frmmenu has 2 panels 1 with a menu on the left site and on the right site another panel Now I want to show the frmbook form into the second panel on the right, by pressing a button on the left. is it possible to load and show that form in that second panel? Thanks so much.

Got that part to work now. I did a copy and paste of the same event and changed the name of it, but forgot the last word at the end of the procedure name.. duh....

No they don't I used splitters so it has a "outlook" like interface.

For some reason I am not getting the mousemove event to work. I have a frmmain with panel1 panel2 and panel3 now I am using private Sub Panel1_MouseMove private Sub Panel2_MouseMove private Sub Panel3_MouseMove private Sub frmmain_MouseMove events with just a End in it so I can check if it's working. But it's not working :confused: :confused: :confused: All events are like this Private Sub Panel1_MouseMove(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles Panel1.MouseMove End End Sub What am I doing wrong?

I was afraid for that :(

Hello, I have a imagelist that contains a few icons,and they are all set to imagesize 32,32 Now I want to have a few icons smaller from that library like 10,10 I tried imagelist.ImageSize.Height.parse("10") and some other OutlookIcons.ImageSize.Height.xxx combinations, but I am not getting it to work. Please advise. Many Thanks

Fixed it... Thanks so much

[PLAIN]Reading Color values from registry won't work? Help! [resolved][/PLAIN] Hello, I created some entries in the registry where I want to save my colors. It saves it in the registry as Name: Background Type: REG_DWORD Data: ff400000 When I try to read it with regKey = Registry.LocalMachine.OpenSubKey("Software\testprogram\colors", True) msgbox(regKey.GetValue("background")) I am getting a value of -12345902 I can't figure out how to get the "ff400000" value then the other problem is how can I put it back as a background color Me.BackColor = "ff400000" won't work.. Can someone help me with these 2 little problems. Thanks so much.

This is what I am using Private Sub OutlookBar_ButtonClick(ByVal sender As Object, ByVal e As OutlookBar.OutlookBarButtonClickEventArgs) Handles OutlookBar.ButtonClick If e.Button.Text = "System Info" Then hds.StartSysInfo() If e.Button.Text = "Company Info" Then compinfo.ShowDialog() End Sub So just a lookup and matching the Text Labels.