Recent content by Clarkie001

Vragabond, Yes, thanks... I have just realised I don't need the absolute whilst using display:none... These were previously hidden DIVs, which was the root of the issue, but I hadn't realised it was resolved by using display: none. Thanks for the detail online inline also. Clarkie

Hi, On one of my pages I have created 5 seperate DIVs and positioned them Absolute - Display: none. I am then using javascript to display the data contained therein seperately and in the same position (hence the need for the absolute positioning). The issue I have, is when javascript sets the...

Hi, On one of my pages I have created 5 seperate DIVs and positioned them Absolute - Display: none. I am then using javascript to display the data contained therein seperately and in the same position. The issue I have, is when javascript sets the hidden DIVs Display:Inline, my footer does...

Hi, I am looking for some help regarding the code below. In the first snippet, I am creating an XML file based on a database recordset. This works great. but! On the second snippet I am trying to create a OWC graph based on the newly created XML file. It works fine on the first selection...

I am receiving a runtime error 'Invalid Procedure on the MID functions in the following code. Please shed some light on this.. Thanks Clarkie <% dim conn, rs, sql set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0"...

Hi, I am using the below code to create a OWC spreadsheet on my page: <object classid="clsid:0002E551-0000-0000-C000-000000000046" id="profiledata"> <param name="XMLURL" value = "http://localhost/ltfp/XMLSS.asp"> </object> The code for XMLSS.asp is: <% Language=VBScript %> <%...

Sorry, I am getting the error on: set objCSpace = Server.CreateObject("OWC.Chart")

Hi, I am using IIS on XP to create a corporate intranet site, before it is loaded onto the corporate servers. I am having issues getting OWC to run... see below code. - I am getting "ASP 0177 Invalid Class String" error. I do not have Office XP installed, I have only installed the seperate OWC...

Hi, I am using IIS on XP to create a corporate intranet site, before it is loaded onto the corporate servers. I am having issues getting OWC to run... see below code. - I am getting "ASP 0177 Invalid Class String" error. I do not have Office XP installed, I have only installed the seperate OWC...

Hi, I have an Excel document where I have created two collections. I want to add one collection as an object in the second collection, but I am unsure how to do this. Any help in this would be much appreciated. Regards, Clarkie

Set rs = db.OpenRecordset("SELECT " & strDate & " FROM " & _ Table & " INNER JOIN Temp ON " & Table & "." & CDate(Format(strDate, "dd/mm/yy")) & " = " & CDate(Format("Temp." & strDate, "dd/mm/yy")) & "") I am using a function to run the above sql. strDate and Table are being returned...

Yes, gave them full privileges

Hi, I am running code through VB which changes the sql of a query and then opens a report based on the changed query. When I run this a the db administrator it runs no problem, but when I try and run this as a data user it throughs up the above error. I have went into the security setting and...

PHV, No, that was the issue, noticed it about 10mins after posting...should have been qryReport_Builder. Thanks for you help. Clarkie

Yeah, tbl_ID is a numeric field. I have tested this sql in a query window and it runs fine, but when I try and execute the change through VB it gives this error??? Nightmare