Recent content by VRIT

Do you have a web addy for these alternative Datagrids Thanks VRIT

Thanks, I have seen this website before and can only find ansers in C++, which is not what I want. VRIT

Hi, I seem to be having alot of trouble with DataGrids since I moved to VB .Net. I have included the code I have written, be it good or not. What I a have is an unbound grid that can should be sorted via various radio buttons. I also dont want the user to be able to alter the column widths...

Gentlemen, Thanks for your help. I recreated the Engineer table and instead of having 'Engineer Name' as a field I used 'Engineer_Name', that seemed to solve it, so it was something to do with the way [Engineer Name] was entered into the statement. Thanks anyway. VRIT

Thats for that but it still does not work. I am sure it is to do with the field Engineer Name. It is the only one I have trouble with and its the only one which has a double name(ie Engineer Name) all the others are single names (i.e Location). Any further ideas welcome. Thanks VRIT

Dear all, I am having a problem with a DELETE statement: The Table is called EngineerName The Column\Field I want to delete from is called Engineer Name The statement which has a problem is: ED = "DELETE EngineerName WHERE [Engineer Name] = '" & LstEngineers.Text & "'" I...

Hello again, I still seem to be having a problem, can someone review the code below (dont laugh) and let me know what is wrong and why it does not update the SQL db, thanks: Dim cnConn As ADODB.Connection Dim CatagoryRS As ADODB.Recordset Dim AlreadyExists As Boolean Set...

Thank you.

Ah that sounds better, please excuse my lack of ability but could you give me an example. The last time I did any coding was with VB3 and Access!! I take it I need to give the SQL statement back to the database..... Thanks for your help and patience VRIT

Dear all, Im sure this is so simple and I am just missing the point. I have created a form that contains a list of items in a listbox. I have been able to write the code to add new items to the listbox and update the list box - Simple. However Im having trouble deleting the item from the SQL...

BrianLW, Thank you for your help. VRIT

Thank you BrianLW, One last question: The rs contains 3 entries, how to I extract these into say a combo box... I tried to use the rs.getstring command but that seems to produce one string with returns in it Thanks in advance, Dave

Wow that was quick. Do I need to worry about closing the Db at all? If so is it as simpple as: .Close Thanks

Hi, Im sure this is mightly easy, but it just escapes me. I can do this with Access in my sleep, but I need to do it in SQL instead. Can anyone explain to me how to connect to a SQL Db and manipulate the records, be it from reading them into a list or combo, to saving changes back to the Db...

Excellent, As Always I knew I could count on someone. Thank you for your time and assistance