Search results

OK -thanks.. it was duplicated.. presumably the Temporary attribute was set to FALSE..

Thanks all for your input... although I had changed the form Recordset type, I had overlooked the subform... having changed this to Dynaset (inconsistent updates) - all works as it did before....

Upgraded my aging database application from 2007 to Office 365 and most of the database appl. works fine - apart from this form which errors as shown... Has anyone any ideas why only now this is 'making noises' after several years of running flawlessly.....? (I have noticed that none of the...

So given what I have advised , any ideas how I can get this working please.? (The Addins dialog comes up blank... but if that is specific to menu and tool bars thats not what I need anyway ) ...

Will check out Add-ins... Same name... no, have checked all code throughout the project. This var name is unique to this subroutine...

As objects in code.. (not sure how you mean specifically context menu - do you mean when only activated by right mouse click...?) not so. At least I cant get them to work.... even using MicrosoftOffice 15.0 Lib reference... throws a compiler error... RunTime Error 5 - : Invalid Procedure Call or...

Hi - I have upgraded my database to the latest flavour of Office 365.... I note CommandBars are no longer inevidence and so have elected to use a Macro in order to create a shortcut menu to mimic the way the display worked before. However, the form that displays has a command button that has...

Sheet 2 of the worksheet could have two variables... One var would be an identifier for the column that represents the first value to compare the others against... ie. ColD/E/F... in my setup F would alwyas be the first value. The second var. would be an integer to represent Asc/Desc That...

.. thanks, but I wish to paste a table of values into the spreadsheet and have this filtering applied automatically....

.. good question.. but in this case, its not of interest ie. void

I am after some VBA code to run or (conditional formatting if that is easier / also possible), where the same three adjacent cells per row are compared to one another..... Each cell has a numerical value - but I wish to only highlight those rows where the cell values are in Ascending (or...

Sir, you are a genius, thank you for taking the time. It appears I wasnt 'miles off' with my efforts : having tried the RANKING query from the suggested thread myself, looking at yours ... it seems I was missing the crucial .... WHERE (((RankingQuery.CategoryRank)<=5)) Works a treat, thanks...

Thanks but having tried various things most of which either wont run or crash Access, am having no luck at all. I dont usually get despondent but this is bugging me. (The database isnt massive either.....so its isnt the sheer number of records causing the crash) Any Access gurus able to work...

Yes, I had found this myself previously but although I got it to work with NWIND.MDB, could not get it to work with my DB.... See pic attached.. When I run it.... it 'timesout'.. appears to be in a permanent loop... I have to Ctrl+Break to quit out of processing...

I have the following SQL query... SELECT TOP 5 SumOfTotal, Year, Customer FROM Reporting_MonthlyTotalSales GROUP BY Reporting_MonthlyTotalSales.SumOfTotal, Reporting_MonthlyTotalSales.Year, Reporting_MonthlyTotalSales.Customer ORDER BY Reporting_MonthlyTotalSales.SumOfTotal DESC This returns...

Hi All I have two columns. Column A shows the placing : 1,2 or 3....this repeats with every set of 3 rows.... 1,2,3,1,2,3,1,2,3,1,2,3 etc. Column D is a TRUE /FALSE Value.... for each 'placed set' of 1/2/3 above, only one of these will be TRUE.... Essentially, I would like a formula to be able...

According to Access help... >>If you pass an array to a procedure by reference, you can't redimension the array within the procedure. So the Subroutine that I had for (ReDim)ing the array is now a function - returning a Variant() array. This now works as hoped...thanks all for your input!

Thank you both for your suggestions, nearly midnight here.. so will try this tomorrow.

Hi, please see attached... any ideas why I have this error? Answers on a postcard.... or by Reply...thanks!

Great - thank you.