Search results for query: *

I have installed the Premium add on on my Exchange server, but when i run a document level back up it runs in about 3 seconds, backs up no data and returns no errors. I have the ArcServe 11.5 installed on the same machine as Exchange. Can anyone suggest where i may be going wrong? and is it ok...

I am a newbie to VB 2008 Express and trying to get a simple application working with SQL Server. I have a form which i use to insert new records and that is working fine. The table has an IDENTITY column in it. However when i do an insert into the table the data is there but the form does not...

I am a newbie to VB 2008 Express and trying to get a simple application working with SQL Server. I have a form which i use to insert new records and that is working fine. The table has an IDENTITY column in it. However when i do an insert into the table the data is there but the form does not...

Thanks for all this guy's, sorry i have been away from my desk for a while in meetings! Let me try and digest what you have said and give it try. Will probably not be untill tomorrow now. Again thanks for all you help and suggestions.

anotherhiggins, Have tried what you suggested and after running the formula in the cells reads =SUM(R[-1]C[217]:R[-1]C[235])

Thanks for that, I will try this as well.

Thanks for that. It always seems to be the simplest of things that cause the biggest problems! IanPikeBioquell

Great, thanks very much ck1999 that worked a treat. I will now try and work out what you have done. Again may thanks for your help much appreciated.

Count at this point = 20 I was trying to see if formular1c1 would cure the problem. Again I was using CStr to see if that was the problem. Having run the code the formula in the cells reads' =SUM(R[-1]C[217]:R[-1]C[235]) If i debug.print formula in VBA after it has been set it returns...

Complete SUB as requested. Sorry notice i typed 22 instead of 2 for the row reference in my original post. Public Sub DoGraph() Dim MySQL As String Dim MyCon As New Connection Dim MyRec As New Recordset Dim Count As Integer Dim ufindate As Date wks3.Activate...

The code is not in a loop, it is after a loop that has been incrementing, i use the count value so as i know what is the last column inserted into. One thing i have noticed is if i put a break point in my code at formular = "=sum(RC[-" & CStr(Count - 1) & "]:RC[-1])" Then use F8 to step...

Can anybody please help, I have a script that reads data in from an SQL database. At the end of a row of data I want to enter a formula that sums that row. (the row will not always have the same number of columns in it) I genearate the formular as follows formular = "=sum(RC[-" & Count - 1 &...