ukjock

Thanks for your help guys, it is much appreciated. I have read through all the postings and I now have it sorted. Thanks again Chris

Thanks for the reply but when I insert that line I seem to get the following error: An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll

Hello me again! lol I need some help, would you epect anything different :rolleyes: I am trying to insert some data in to a Access 2000 file with the following code: Dim line_string As String Dim sex_string As String Dim tel_number_string As String Dim callers_name_String As String Dim callers_location_string As String Dim topic1_string As String Dim topic2_string As String Dim graphic1_string As String Dim time_called_string As String line_string = ComboBox1.Text sex_string = ComboBox2.Text tel_number_string = TextBox1.Text callers_name_String = TextBox2.Text callers_location_string = TextBox3.Text topic1_string = TextBox4.Text topic2_string = TextBox5.Text graphic1_string = ComboBox3.Text time_called_string = Date.Now.ToString("T") Dim MyConnection As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & database) MyConnection.Open() Dim MyCommand As New OleDbCommand("INSERT INTO Callers_View (ID, Line_Number, Sex, Tel_Number, Callers_Name, Callers_Location, Topic1, Topic2, Graphic1, Time_Called) VALUES ( '2' , 'line_string' , 'sex_string' , 'tel_number_string' , 'callers_name_String' , 'callers_location_string' , 'topic1_string' , 'topic2_string' , 'graphic1_string' , 'time_called_string')", MyConnection) MyConnection.Close() MyCommand.Dispose() database is already declared as a string for the form. I check the properties of the access file and it has not been accessed nor is anything being stored in it. What am i doing wrong? ID is set to be Autonumber and a PrimaryKey. I have attached a copy of the database to let you see what I mean. Thanks for your help again guys and gals. It is much appreciated. Chris psDOTnet.zip

I have put some icons in to my statuspanel of my statusbar. I want to call them though from an imagelist but I am not having much success I am trying the following code: If StatusBar1.Panels(2).Text >= "12:00:00" Then StatusBar1.Panels(2).Icon = time.Images.Item(0) But I get the error can not convert system.drawing.image can not be converted system.drawing.icon. Any ideas on how I can get around this. Any help appreciated Regards Chris

Darn it! Your right, I must have overlooked that little blighter. Thanks for your help c

Hi everyone I have a small problem with my database creation. I am trying to create a database in a direcotry as specified by the user, but I want to title the database myself. So I have the following code: Dim database As String database = TextBox1.Text & "\mydb.mdb" Dim cat As Catalog = New Catalog cat.Create("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & (database) & "Jet OLEDB:Engine Type=5") cat = Nothing problem is that it names the database "mydb.mdbJet OLEDB". I can see how and why it is doing this but I can not rectify how to stop it. Any help appreciated. Thanks Chris

did you have any luck with this!? I am in the same boat and can not find anything for mouse buttons 4+5. chris

Hey guys and gals I have some questions regarding da mouse cursor. Firstly i have copied a couple of mouse cursors from the windows folder and embedded them in to my solution. When I call the cursors they then appear black & white and not color, has anybody any ideas why? When i check them out they are all in color. Secondly when I change the mouse cursor and try to drag and drop, it changes the cursor to unavailable. How do i keep it to my assigned cursor? Any help on the above much appreciated. Regards Chris

You could do this: Dim S As New settings S.ShowDialog(Me) Regards Chris

One word for you DameonBlack... GENIUS!!!

Superb Derek Stone... worked a treat Thanks for your help guys! It is much appreciated. chris

I did this in vb6 and I can not remember for the life of me how, now I want to do it in vb.net I read the first 2 characters of a textbox as the user inputted their data. And then I displayed a certain image if the dpending on what the first 2 characters of the box are. Can anyone please help me out! Thanks in advance Chris

Can somebody please help me on how to make text flash using a timer. Is using a timer the ideal way or is there an easier way!? I wanted to use: If Label2.ForeColor.Red Then Label2.ForeColor.Empty() Else Label2.ForeColor.Red() but i get system.color can not converted to Boolean. Can somebody please help me... I am pulling my hair out! Regards Chris

Show & Hide.

I have finished my forst vb program and have now decided to improve it, and I decided to go back to the drawing board. In order to make everything I want to fit on to my Windows form I am having to use Tabcontrol I am allowing the user to select which tabs are active via Checked box's: I watch for the checked status to change then run this code: If CheckBox2.Checked = True Then TabControl1.Controls.Add(TabPage3) Else TabControl1.Controls.Remove(TabPage3) End If problem being that this automatically adds another Tabpage3 on run. Does anybody have any other advice on a way to hide a tabpage? Mucho Respecto chris