Search results for query: *

Good point, school boy error. Thanks. It could be due to the default setting for ODBC direct connections is readonly. Thanks for your advise Geoff i'll have to play around with it.

Using the below: With rs .Edit If blnbook = True Then !REMAINING = !REMAINING - (lngBookMins / 60) !Selected = !Selected + (lngBookMins / 60) Else: !REMAINING = !REMAINING + (lngBookMins / 60) !Selected = !Selected - (lngBookMins / 60) .Update...

Hi Geoff, For some reason it still doesnt work and tghe permissions are set. If I conect to an access db and then update via a linked table it updates fine. Cheers Dan

Hi, I'm trying to connect to an SQl recordset and update some columns I can connect to the server and return a recordset but I can't update it as its read only any ideas on how to get it read write? Heres my code: To connect: Set wrkODBC = CreateWorkspace("NewODBCWorkspace", "admin", ""...

Hi, Could nayone help. I'm trying to query our sever for data based on a date/range but I cannot get it to work I get an ODBC call failed which usually means the SQL is wrong. I know the date should be the number of days since 31/12/1899 date-1 = 38593. Can anyone help?? Code attached. Dim...

Hi, You could use If Len(Dir(strPath & strFile))>0 then 'Do somthing End if This would tell you if a file exists Or you could use Dim wbk As Workbook For Each wbk In Application.Workbooks If wbk.Name = ("Q:\elogs\newformat\" & Me.ComboBox1.Value & "\" & _ "elog_" &...

Spot on cheers matey.

Hi, Would any know a way to check how many workbooks are open in an excel session?? Any help would be appreciated. Cheers Dan