pells

I need some help on how to do this. I have a need to show 4 columns of data, the first 3 are definable widths. The 4 column is for notes, and notes can be long. Any one have a way of showing this. Datagrid would be perfect if it allowed multiline, but I have spent days looking and do not have the cash to purchase a custom one right now. I will also state I am new to .net, but have a lot of experience with VB. Thanks for any ideas!!

Let me see if I can explain a little more, it is very weird to me. I have a form (I have tried mdi and windows) with a tab control on it. (I did change the tab control to have the tabs on the bottom). Now all I want to do is add a menu at the top of either the form or tab control. The problem is I add the menu and everything looks great, but as soon as I click off the menu it disapears. I still have the icon at the bottom of the screen, and when I click on the menuicon, the menu comes back. But again as soon as I click it goes away.

I am having a problem adding a menu to the top of my form with a tab control. I can add it and set it up, but as soon as I click anywhere else the menu disapears. Is there a way to make it always on top? Thanks

Is is possible to use the tab control and have the tabs accross the bottom of the page and not the top? If not I am thinking of just using identical forms with buttons, and hide and show the different forms? Thanks in advance

Nope, just the error box and the error I listed above. If I break it goes right to that line. If I mouse over that line in break mode it says Public overridable nonoverrideable Function Exectuenonquerry () as integer. I also notice that the insert statement is in red in the auto's window. Thanks for any ideas, I am really stuck.

I tried creating a new table with just one field in it. I still get the same error. I tried using the wizzard with a new database, same error. Is there a security setting or soemthing I am missing?

Still get the same error. It looks like the sql is fine, it just does not like the executenonquery statement. Could it be a setting in access, or maybe I am missing a reference (I know this was big with VB6, but I am just learning the .net stuff). I have a delete query that has the same statement, and it works fine. I just can not add anything new to the db.

I get the following error on the executenonquery command. An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll

I must be missing something real easy here, but I can not seem to insert data into access using .net. Here is my code. Thanks, Dim MyConnection As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\AJS Contact Management.mdb") MyConnection.Open() Dim strCommand As String = "Select * from Companies where company = '" & Replace(cmbcompany.Text, "'", "''") & "'and Contact = '" & Replace(cmbcontact.Text, "'", "''") & "'" Dim mycommand As New OleDbCommand(strCommand, myconnection) Dim myreader As OleDbDataReader = mycommand.ExecuteReader If Not myreader.HasRows Then myreader.Close() mycommand.Dispose() strCommand = "INSERT INTO Companies (company, address, city, state, zip, contact, sal, phone, ext, fax, email, customertype, discount VALUES ('" & cmbcompany.Text & "', '" & txtaddress.Text & "', '" & txtcity.Text & "', '" & cmbstate.Text & "', '" & txtzip.Text & "', '" & cmbcontact.Text & "', '" & cmbsalutation.Text & "', '" & txtphone.Text & "', '" & txtext.Text & "', '" & txtfax.Text & "', '" & txtemail.Text & "', '" & cmbcusttype.Text & "', '" & txtdiscount.Text & "'" mycommand = New OleDbCommand(strCommand, myconnection) mycommand.ExecuteNonQuery() Else MessageBox.Show("NAME ALREADY EXISTS!") End If myconnection.Close() myreader.Close() mycommand.Dispose()

Realtime data is very critical for this. My salesman use this system to get a quote number and log the info for the quote. So if it is not realtime they end up with the same number. I think I will investigate this mysql. Since I will not have to worry about really high volume work.

I used access in the past, and would like to stay with that initially. The user base is very small at this time (20 or so people) and they do not tend to use it at the same time. In the past the only issue I had was when two people tried to update a record at the exact same time, but I found a way to handle that. I do have a WAN/LAN and it is decent speed. My problem (and maybe I am doing something wrong) is the speed it takes to open the database. When I try and connect accross the network it is very slow (the access file is about 6meg, I have a bunch of reports inside the access database, because it was easier than writting reports in VB6). I know SQL Server is a much better way to go, but funding is very tight right now so I am limited to what I have. Thanks so much for the info so far.

First I have a great deal of experience in VB6, but just starting to learn the world of .net. What I need to do is create basically a customer relations database. It has a lot of custom features that we need so we do not want a canned one. I developed one using VB a few years ago and it worked fine, except we have multiple locations and I ended up with different databases for each facility (not a major problem then, but it is now). So I want to update the system to work off of one database and not sure what direction to write it in. Here are a list of some of the major features that we need to incorporate to help define the direction. -- Based on a zip code it defines the salesman -- Ability to create word documents -- Create realtime reports So nothing major and I could do it as a windows application. Which is what I would like to do, but then I have issues with the central database. Thanks for reading this and any ideas you might have.