Search results for query: *

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

I am trying to include the links on my homepage within a drop down list box. The code i thought would work was something like this <select name=links> <option><a href=&quot;http://www.google.com&quot;>Google</a></option> <option><a href=&quot;http://www.yahoo.com&quot;>Yahoo</a></option>...

I havew a report that uses multiple groups. With in each group I have a subreport. Each subreport uses the same report (with different subreport groups suppressed depending on which subreport it is). When the report runs it collects the records for the main report, then collects the records for...

I am using excel 5 and am trying to use VBA to name a sheet after a range name or cell value. I keep getting the &quot;Runtime error '13' Type mismatch error. for example here is some of my code RangeName = ActiveCell.value 'say is equal to Jan' myRange.Name = RangeName in the immediate...

Is it possible to get excel to plot the mean, mode or median on histograms. If this isnt possible, i could use a boxplot. I am using excel 5. another question: is it possible to specify the height and width of charts?... so i dont have to do it manually. Thanks in advance !

MS Access is corrupting databases, the only diagnostic which is different between two computers (one which runs the database, one which doesnt) is the number of threads. The machine that wont run the database correctly has max no. of threads of 17, the one that does run the database ok has max...