Recent content by eja5866

You are correct, my original question only involved querying one id_number. Where the aggregate of a number of runs for that id_number would result, and I'd only be interested in the highest AREASUM. But I really wanted to apply that query to a group of Id_numbers where id_number = v_id. And...

Yes Thanks! - The Select * from (...... option worked best for when I had just one id_number. But what if I have a whole set of ID numbers coming from the same table (where id_number whould be constantly changing)? Right now I have a cursor set up, but I'm experiencing problems. Perhaps a...

T - Thanks! That did the trick!

Hello All, I have a query aggregating a result set and grouping by 3 particular identifiers. I'm only interested in the first result where the aggregate (sum) is greatest. I cannot use rownum since I am using aggregate functions grouping about 50 rows per set. Does anyone know how to limit...

Hello All, I have a query aggregating a result set and grouping by 3 particular identifiers. I'm only interested in the first result where the aggregate (sum) is greatest. I cannot use rownum since I am using aggregate functions grouping about 50 rows per set. Does anyone know how to limit...

Skip, Thanks! PHV, - What do you mean by "End instruction"?

Hello, I'm trying to set up a default when Excel opens up so that when the user starts, 'CTRL-F' default option is within 'workbook'. (The default is within 'sheet'). I know that it's some .Find property I can set up as a Workbook_Open function under "ThisWorkbook" module. But I have been...

I am calling a stored package which has the procedure: Create or Replace Package P1 as created_by varchar2(30); created_date date; modified_by varchar2(30); modified_date date; End; / -- This procedure sets package values since procedures -- can be called from front end -- but packages...

How to pass a procedure for PRE-COMMIT using OO4O Hello. I'm sending over a bunch of Insert statements from Excel straight into Oracle using OO4O. Normally on the database side, I have before-insert and before-update triggers firing which populate modified_by and modified_date columns for...

bump Kind Regards, Edward Apacible International Flavors & Fragrances Ph: 732-264-4500 Ext. 3469 Fax: 732-335-2350

Hello. I'm sending over a bunch of Insert statements from Excel straight into Oracle using OO4O. Normally on the database side, I have before-insert and before-update triggers firing which populate modified_by and modified_date columns for auditing purposes. In Forms, I would populate a...

Here is My Change Event Code: Private Sub Worksheet_Change(ByVal Sheet1 As Range) ' Macro created 11/17/2005 by Ed Range("A43").Select Selection.Font.ColorIndex = 8 Application.Run "DoseResponse_dB_Template_ROUGH.xls!Regression_Analysis" End Sub

Okay, I tried Change Event, Sheet Calculate Event, and Calculate Event. None of them seem to Work. I still have to manually run the macro I made for Regression Analysis. DiD I code swrong? Any other suggestions? Here's my most recent code: Private Sub Workbook_SheetCalculate(ByVal Report As...

Hi, I'm looking for a way to do Automatic updating of Regression Analysis which I have on a spreadsheet. This is unlinke having a chart or cells linked where that is merely an option which is clicked off in calculations tab. Presently I've created a Macro to run the Data Analysis section which...

Thanks guys for both of your help. I used a little of Both types you guys mentioned as such: LoadSheet = Application.GetOpenFilename(&quot;Workbooks (*.xls),*.xls&quot;, 1, &quot;Please find new batch file to Load&quot;) If LoadSheet <> &quot;False&quot; Then Set BatchSheet =...