Search results

I have a list of a months worth of results in a workbook. One workbook / XLS file for each month. I want an ANNUAL TOTALS workbook that tabulates the totals from each month/workbook. In this top level workbook, I have links to each group of total cells from each workbook/month. I want to be...

Hi There I am analysing reams of horse-racing results data. I attach a sample copy of a sheet. Currently, I list all results and prices attained. However, I wish to filter the results I get by way of the number of runners in each race. So, I only wish to display results for say 10 runners or...

I have been using 2003 for some years now and deicde perhaps to make the move to 2007. Using 2003 I use a workgroup file which I think is giving me the following problem. In 2007, I open the DB I wish to upgrade and it states : You do not have the necessary permissions to use the _ object...

The problem persists... I can get the form working on my Windows 7 'development' machine, but when I go to client PCs on the network all exhibit an error as shown on the attachment. If on one of these networked/client PCs I edit the project , clear the MCCom Ctl checkbox and using Browse...

I am using Access 2003 SP3 (VBA vers 6.5) - I cannot upgrade Office due to performance issues on my network - (namely the PCs are too old to support the newer memory hungry versions of Office). So from what you are saying - it should make no difference where the OCX file resides on the client...

Recently I added a reference to my DB project to use the ListView control from MSCOMCTL.OCX This for whatever reason resides on my Windows 7 Development PC - in c:\windows\SysWOW64. Other users of the DB on my network do not have Windows 7, (they have either Vista or XP). Of course, all have...

I get you... yes, agreed it would be. Your suggestion is by far the simplest! Wont need to run in a seperate worksheet either as the selections I use are pasted into my 'template' workbook which will contain the lookup table. From here I run the update and then save as the selections as CSV for...

Brian Thanks for the sample sheet - just what I wanted....! Thank you very much, Regards Guy

You seem to know more about this application than I .... ! Why would this be (in your words) a 'nightmare' to upkeep...? I anticipate adding the new course names as I get them each week. 3 or 4 at a time.... that wont be too much effort....! The compilation of all names as I have mentioned...

I do not follow - and would ask that if you are able to submit a sample spreadsheet - I am not too familiar with coding in Excel at all. Presently, I am using find/Replace each day to convert the Abbr / Full names which currently takes me less than 5 minutes BUT as this is a daily operation, I...

>>It is probably quicker and easier not to bother writing a macro especially if this is a one off. Problem is - this is NOT a one off - will need to run DAILY. Plus, the list of race track names is quite extensive and will have to be added to as I go for the first few weeks at least..... Any...

I have a spreadsheet with a column containing '1...n' race meetings. These are all 4/5 letter abbreviations - but I need the full name in the column. I would like a macro/routine to iterate through the column replacing the abbreviation with its full name equivalent. I would welcome ideas on how...

??? .... the nesting would mean I need to quote loads of calls.... Private Sub ShowOrder(nPrnMode As Integer) Dim strNo As String If cboPONo.ListIndex <> -1 Then strNo = cboPONo.Column(0, cboPONo.ListIndex) Else ' user has entered value strNo = cboPONo End...

The code is fine .. having worked for the best part of 10 years.....! .... (but for what its worth) Private Sub cmdPreview_Click() Call ShowOrder(acPreview) <----(exec. stops here) End Sub

New one on me this is.... I once perhaps had a breakpoint set on a particular line of code in one of my routines behind a form. This breakpoint is now no longer set. However, in recent days I have noticed when this particular piece of code executes (it is only opening a REPORT!), operation...

Thank you Nick - pretty much what I needed .... sufficient here for me to now put a little more meat on the bones! Thanks again, great help.

OK - I have a spreadsheet for input of dimensional data for engineered parts. The right most columns in each row have formulae to do the necessary calcs on the figures that have been input. For example : I have cells C1 , C2 , C3 that require input of a number I need a button which I will...

Hi All I wish to automate a repetitve task using Macros. I am not new to Excel (Access is my area of expertise), but I am new to using Macros in Excel. The macro I require is simple - I wish the user to press a button - an inputbox or similar appears and prompt user for a cell value, on OK this...

'Flawed'? - Perhaps but the concept is that of an INSPECTION record in an engineering machine shop. Consider a machined part made to a contract. This machined part is inspected and there are 1...n errors in accordance with the drawing to which this part has been made. The design I have outlined...

I have a form with child/subform - when the form loads any child records are also loaded by virtue of the filter criteria I have stipulated for the parent form. Simply put, the sub-form (in datasheet view only), is a summary view of 'child' records that exist for this parent. Clicking on the...