Search results for query: *

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

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

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

Can anyone tell me why I am getting Run Time error 3265 Item does not exist in this collection with the below sql. Seems to be the last line (in red) that the error falls on, any help would be greatly appreciated Clarkie db.QueryDefs("Report_Builder").SQL = "SELECT tblReports.tbl_ID...

Hi, I would be like to be able to check the date contained within a Text File before I import it into my database. Any help on this would be much appreciated, thanks in advance. Clarkie

Hi, I have a dlookup which should return integer based on a specific code. Here is my SQL SELECT Rein_Hist.Date, Rein_Hist.FMS_ID, Count(Rein_Hist.CardHolder_No) AS Sales, [Rein_Hist]![Campaign_Code] & [Rein_Hist]![Source_Code] AS Campaign_Source...

Hi, I have a field ina query in which I lookup up another table to return a number based on a project code. The issue I am getting is it will only return the same number for each row, when there are clearly more than one project number.....I can't see what the problem is. any help in this...

Hi, I have a field within a make table query which does a dlookup up on another table. The issue is, when I run the make table query, this field is returned as Text when it should be a number. This is causing issues, as I wish to use this newly created table in another link. Does anyone have...

Hi, I have the following code which works fine for what I want, but when I select another cell within the range of C1 to C8 I need the previous cells Interior to change back to xlnone. Can anyone shed any light on this?....Thanks in advance. Clarkie Private Sub...

Hi, Does anyone know how to launch a macro on a mouse event....particulary mouse click? Any help in this would be great...thanks in advance. Clarkie

Hi, I am using a Userform in excel to run the following macro. This works fine, however the issue arises when I make this available on our website for other users to view. At that point I am getting a Run-Time error 1004 Method 'Sheets'of object'_Global' failed. I dont understand why it works...

Hi, I have several macros that I use a Userform to run, this works fine when using the workbook locally. The problem begins when I publish the report online for people to access through a website on our in house intranet site. If I run the macros from the Tools>Macros menu they run fine, but...

Hi, The following code worked fine on my PC at home, but when I brought it into the work it would not place the values in the &quot;Comparison_Chart&quot; worksheet. It seems to close the form and not action anything, but when I reopen the form it just keeps going through the loop. I have no...