Search results for query: *

I'm having real problems with Firefox and the onKeyPress / onKeyDown event handlers. Just for a change, both work fine in IE! <script language="Javascript"> function capLock(divID,e){ kc = e.keyCode; if (kc == 0) kc = e.charCode; if(kc >= 65 && kc <= 90) {...

Does anyone out there know what version of the Calendar Control is included with Office 2003? I've got 2007 and Calendar 12.0, but it doesn't seem to be compatible with 2003...

I have checkbox controls embedded (InlineShape) in a word document. Depending on values in these and other controls, sections of the document gets deleted. My problem is, is that once sections are deleted, then the controls embedded in those sections no longer exist, so I can't use the control...

Has anyone meet this before I have this Javascript function that is supposed to change a value before submitting the form. The form name is dynamic, so is the value function SubmitForm(What,DoWhat) { var f=document.getElementById(What); f.Task.value = DoWhat; // <<<<<< FireFox fails on...

Has anyone successfully used the WorksheetFunction AVERAGEIFS? I'm having real trouble figuring out the syntax for the function in VBA. strLowerDate = Format(dblRunDate + TimeSerial(0, 0, 1), "dd/mm/yyyy hh:mm:ss") strUpperDate = Format(dblRunDate + TimeSerial(23, 59, 59), "dd/mm/yyyy...

don't know whether this is even possible. I have a data set that is not possible to achieve using a native SELECT statement. I've written what I need into a FUNCTION (or PACKAGE function) that returns a record. How do I get the data row returned by the FUNCTION in the "Data Model" SELECT *...

I have a problem I can't resolve I have a parameter that can be either contain '%' or 'VALUE' or 'VALUE,VALUE,VALUE' I need to code the select statement to cater for all of these possibilities I currently have the following AND NVL(SGBSTDN_RATE_CODE, '%') IN -- (lv_rate_code_list)...

Run-time error '5097' There is insufficient memory. Save the document now. 'OK' is the only option This error happens at Dim oDoc As Word.Document Set oDoc = oWord.Documents.Add(Template:=strTemplateSpec) Word fires up using the template and then this error pops up. All the Microsoft and...

Has anyone out there ever succeeded in using OlSecurityManager to turn off the Outlook security warnings? I found the following suggestion Dim OlSecurityManager As Outlook.SecurityManager Dim oApp As Outlook.Application Set oApp = CreateObject("Outlook.Application")...

Is there a specific Oracle Forms forum or do we use this one?

I'm having a real problem using a REF CURSOR type Here's the DECLARE and the start of the BEGIN I've so far developed. DECLARE TYPE r1 IS RECORD ( szvcapc_pidm szvcapc.szvcapc_pidm%TYPE, szvcapc_term_code szvcapc.szvcapc_term_code%TYPE, szvcapc_request_no...

I'm having a real problem using a REF CURSOR type Here's the DECLARE and the start of the BEGIN I've so far developed. DECLARE TYPE r1 IS RECORD ( szvcapc_pidm szvcapc.szvcapc_pidm%TYPE, szvcapc_term_code szvcapc.szvcapc_term_code%TYPE, szvcapc_request_no...

I've been directed to ask this question in here. Question: How do I get the MouseOver to work at RunTime - I hover the mouse pointer over a value and ....... nothing. Is there an option that I need to switch on to get this working? - it's becoming a REAL pain to have to keep adding a Watch to...

Excel 2000 Visual Basic 6.3 This is not technically VBA. How do I get the MouseOver to work at RunTime - I hover the mouse pointer over a value and ....... nothing. Is there an option that I need to switch on to get this working? - it's becoming a REAL pain to have to keep adding a Watch to...

HELP!! Const cMATNR = 1 'Set myRange = .Range(.Cells(cDataStartRow, cDataStartCol), Cells(GetLastRow(ws), GetLastCol(ws))) Set myRange = .Range("A2:AD1541") ' locate MATNR in range varValue = Application.WorksheetFunction.VLookup(MATNR, myRange, cMATNR, False) I get the error Unable to...

I'm having a problem updating a table using a query to select the correct number of records. When I used a second table to perform the INNER JOIN, the query ran and upated the table, but unfortunately it updated more records (50) than it should have done. UPDATE XREF_MATNR_TO_PART INNER...

Does anyone know if it is possible to generate a dynamic dropdown-list in a cell by calling a VBA function passing the contents of another cell Something along the lines of:- =GenerateList(C4) Function GenerateList(Byval strClass As String) As [DropDownList] Dim lbxDropDownList As...

I'm trying to use a Query to create a table so that when the fields change, as they are doing regularly right now, I can just modify the script and re-execute. I have a problem though. CREATE TABLE [Table_Name] (Field1 TEXT(18) NULL, (Field2 TEXT(255) NULL); Does not set the "Allow Zero...

I'm trying to execute a query but it keeps coming up with:- 'qappLT_MM_Bulk_-_Basic_Data_from_MM' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long I have other queries with the same naming convention and they run fine, for...

I'm trying to perform an inner join on two text fields, the contents of the field are mixed case values. Is there any way I can perform the equivalent of INNER JOIN ON UPPER(csid_det.csid_part) = UPPER(qryPt_mstr.pt_part); which of course Access will not allow! An alternative would be to be...