Search results for query: *

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

...= ADODB.CursorLocationEnum.adUseClient .ConnectionTimeout = 0 .Open() End With UserSQL = "SELECT * FROM UserDetails ORDER BY '" & SortGridBy & "'" UserRS.Open(UserSQL, cnConn, ADODB.CursorTypeEnum.adOpenStatic...

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...

....ConnectionTimeout = 0 .Open End With If TxtCatagory.Text <> &quot;&quot; Then CatagorySQL = &quot;SELECT * FROM Catagory&quot; CatagoryRS.Open CatagorySQL, cnConn, adOpenStatic, adLockPessimistic CatagoryRS.MoveFirst AlreadyExists = False...

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

Afternoon, After a long spell of not doing any programming I am now getting back into it. However the last time I did any coding was with VB3 and alot of things seem to have erm changed. I have a main form and a simple menu. Once a new form is displayed after clicking on a menu option I want...

Hi, Oo for the first time this year I need your help. We are in the process of deploying Windows Messaging. We have a Windows 2k server which has the WM components installed. We also have a ISA server which controls the Internet access for all users. WM workings fine internally, no issues...

How about this: Under the User Properties select the Terminal Services Profile tab. On this page at the bottom is a tick box, Allow logon to Terminal Server - is it ticked? VRIT

Thanks, Not exactly what I was looking for, let me explain: I want to stop any user other than Supervisor/Admin logging onto any given server. We have a problem with users logging into the server. I have looked at the local security policies and thought that this was the way to do it, though...

Dear all, I want to know how to disable logons to a server. So that only users within the Dom Admins group or specific users can login. I know how to do this for NT4 but I am at a loss for 2k. Any info welcome. Thanks VRIT