Recent content by tektripper

The subreport goes something like this: Uses a running sum on 2 calculated fields (Over group). A text box in a group footer makes reference to the running sums for a separate calculation. The running sum is necessary as each record in the group Lvl1 has a percentage of total (for the group)...

Thanks, Unfortunately that didn't work. I am using Access 2.0 and the running total isn't in the detail section but at group level. If you have any other ideas would appreciate it! Much thanks Adam

Hello Helpers I have a report that contains 3 different sub reports. Each sub report contains a total which is used as an argument in a function in the main report. I am having trouble getting a value from the subreport that makes use of a running total. If I run the report with out referencing...

I have a report as follows FldA FldB FldC FldD 1 10% 4 0.4 2 20% 1 0.2 3 30% 6 1.8 4 40% 7 2.8 --------------------- 10 100% 18 (?) FldB in the detail section makes reference to the sum(FldA) to calculated the percentage of the group. FldC is a calculated Field...

Thanks for your response. But just to let you know... our Datawarehouse is on a massive oracle database. I don't have the ability to create stored procedueres and if i did I believe I might lose the abaility to use my vba functions (i'm not sure of this). I do use make table queries quite...

I have a query that makes use of many vba functions (but very basic). It uses 3 tables that are all indexed on the linked fields. If I run this query as select query it takes a few seconds before the datasheet appears. If I would like to view all records (ie move to last row) it may take a...

I am writing an application in MS Excel 5 and am trying to write some code that will remove all standard toolbars upon startup and then restore them upon closing the workbook. In excel 5 there is no such thing as a command bars collection just separate 'Menubars' and 'Toolbars' collections. The...

I would like to use a function I have written inside a pivot table as a 'calculated field'. However I keep recieving an error message say item not found. Is it possible to use custom functions inside pivot tables?

I am using excel 5. I am having trouble making the 'onchange' property of a drop down box (on a dialog sheet) input text into an edit box on the sam dialogsheet. The dropdown editbox does have an input range on a worksheet in the same workbook. the code that i am using is like this.. Sub...

thanks for that. I should have mentioned that I had tried the macro recorder for the notes dialogue box. It doesn't work. The NoteText property/method only adds notes, it doesn't open the dialogue box. I am using notes to keep a running history on changes in parameters for a computer system, I...

I am using excel 5 and was wondering how I can assign macro to the close option on the file menu. Also wondering if there is something similar in excel to the autoexec macro in access. Also I want to create buttons on the worksheet that do the same action as selecting a menu option....eg...

most certainly does... you've got my vote. Cheers!

If you have a table in word that doesn't use the full page width, Is there an easy way to align the table in the centre of the page/column with out having to use rulers. I am using word 6. Any help would be greatly appreciated!

More Information.... I am trying to use a cell that contains a date to name a range. I am relatively new to excel, and am frustrated by the way it handles dates (bearing in mind i use excel 5). I understand that i cant use certain characters in the range name that is why i am trying to convert...

I have just tried to use an excel function inside some vba code i have written. The function i have used is the text() function. When I use the debugger it says "function not defined". What do i have to do to be able to use all of the built in functions of excel with in vba. Thanks