Search results for query: *

Hi All, I wonder if you can help. I had to reinstall windows 2003 server on my pdc as it would not boot. This went all fine and DNS, Active dir, and DHCP was installed. Added all my user accounts back in and this is the problem i have. I cannot write to a shared directory with all my users docs...

Below is some working part of my current sql. What i would like to do is have a date parameter in RS 2000 which will be the most current saturdays date say 14/10/06 then where i have hardcoded the dates below do some kind of dateadd - 7 thing to dynamically replace the dates in the case things...

thanks for the reply. how do i go about fixing this issue ???? Kind Regards Dave

simply question answered simply :-) Many thanks Dave

Hi All, How do i delete current rows in a excel sheet from say row 8 downwards before loading in my ADODB.Recordset from a fresh query Kind Regards Dave

Hi All, Dont know if this is a excel or sql issue so here goes Got a excel sheet pulling data from a sql table, no prob there. In the ms query i order my results by a field with a number in but it shows the numbe 1(one) below say number 10(ten) why would this be. I can get around this by...

hmmmm, using cn.execute (SQL) I get the msgbox giving back to me what looks like a good update sql statement, but i get a debug error what looks like to me as if the update is trying to update the first row of the table not the one in my where clause, like is said which looks correct in the...

Hi Geoff, I get a debug on rs.Open SQL, adOpenForwardOnly, adLockPessimistic saying runtime error "91" Object variable or With Block variable not set Errr scatching head..... Nope still errrrr Message box works nice :-) Dave

Ok spoke to soon I am doing something wrong with the call to the sql bit i think.... I think its in the rs.open bit as thats where the debugger throws a wobbler. Public Sub DataLink() Set rs = CreateObject("ADODB.Recordset") Set cn = CreateObject("ADODB.Connection") cn.Provider = "SQLOLEDB"...

Geoff your a star :-) Now that i have my two sets of data for my update sql i think i can move on to completing this task. Once again a very big thank you for your easy to understand explinations. Many kind Regards Dave

Ok below is my attempt at looping through cells in my spreadsheet. The message box is just to make sure i am picking up the right value. How do i also show the value of A5 to End of A colum. So far i only get value of D5 to end of D So my message box should output value of A5 and D5, A6 and...

So i now have my connection to SQL Server I have also added a control button that onclick triggers the module i have made. Al good so far(this is like pulling teeth) So how do i now loop through my excel records and update the relvant fields in my sql table. Kind Regards Dave

p.s i would not mind this little trick to for my spreadsheet i have to cells with the database name and server info in them. Is making these part of the connection string something like this Set Sheet.A1 = server Set sheet.A2 = database Dave

ok ive got this far without compile errors :-) Public Sub DataLink() Set rs = CreateObject("ADODB.Recordset") Set cn = CreateObject("ADODB.Connection") cn.Provider = "SQLOLEDB" cn.ConnectionString = "server=xxx.xxx.xxx.xxx;database=test;uid=me;pwd=right" cn.ConnectionTimeout = 600 cn.Open...

Got it it think Microsoft DAO Object Libary 3.6

would that be tick the box in refs for Microsoft Data Access Components Installed Version ???

Its not so much as "get around simple ADO code" its where does it go ???? I am new to MS ways of doing things, come from php/mysql/cgi background and cant work out what i am to do in as far as telling the spreadsheet to connect to sql server, and where to tell it.

Sorry i meant data. As for searching forums, i have, and cant make heads or tails of all the stuff i am finding. Let me clarify where i am at. I have pulled in records using import data in excel relevant for the update job i want to send back. One of these fields is a number colum, currently...

Hi All, Whits end, a million searches here and google :-( How do i connect to and update 1 (one) field in a sql server table with the data in 1(one) field in my spreadsheet. I have got the date from sql server into my spreadsheet and now i want to simply send changes in my one field back to...

Hi All, Sorry if this is in the wrong place. I have a excel sheet that pulls data from a sql 2000 table. I want to update 1 field and send the update back to the sql table. How do i do this ????? SO if i update my field in excel from say a number "1" to a number "2" how do i send the update...