Search results

Just do a Dcount

Must admit I have used the Word spell-checker for years similar to the suggested use of Excel above. Works well.

Very rose tinted view of the Railways pre-privatisation - to everyday users they appeared to be run by the unions for the benefit of the unions. Service was abysmal, customer care something you looked up in a dictionary, punctuality non-existent and when closures happened there was no such...

And even then wreaths are only Christmassy in passing - I associate them with funerals! :)

The problem with privatization is the same as with outsourcing. You are eating your seed corn for short term gain. Privatization for resources which are required for the function of government seem to me to be something that should never be outsourced -eg, armed forces (especially pay)...

Just don't plug in your ethernet cable - not all of us use Wi-fi to connect!

Agreed but version 8.1 worked well. The worst version was Windows Millennium!

I will continue to use older versions of windows - the only reason I upgraded to Win 10 was I couldn't find a replacement copy of 8.1 to mount on my PC when I had to have a new hard drive. I now keep a clone of my SSD, updating it monthly or when I mount a new applicatio (seldom). For me the...

Given that my laptop is still running Windows 7 and Office 2003 there is normally no need to upgrade just because MS tells you to! It actually smacks of MS realising that they actually could make Win 11 run on earlier hardware, when a boss invited the programmers to an 'interview without...

Interesting as the descriptions of mice are I'm just as interested in keyboards. I actually use a German QWERTZ keyboard though I seldom type much in German these days. What I like is the flexibility of easy access to various accents in most European languages, especially it is much better for...

My mouse is Logitech which I had for a couple (exact number not known) of years before I retired 2008. And still going strong! The thread reminded me of the arguments over serial or PS2 mice and cleaning the ball on mechanical mice before laser mice.

I agree with getting both for testing. My choice is CSV because with Access import specs you have a good chance of getting the data the way you want it. HOWEVER (and it's a big however) find out how the CSV files are generated. If they are being generated in Excel adds are you are getting...

I know this post may seem a little dismissive or rude but it's not meant to be so please don't be offended. There are ideas above which will help solve your problem in the short term, but the nub of the problem depends on having a decent data structure to start with as suggested by the The Doc...

Has anyone who has provided the solutions which I am about to use (thanks) used the code to also apply formatting as well as the colours? eg, underlines and italics etc which I use when pre-applying CFs at design stage. I'll obviously find out when I try it but was just interested. *** IGNORE...

As an aside one wonders if the three limit is the bug, or the redesign of the conditional formatting dialog to allow more than three to be defined?

The answer is no it doesn't mean that BUT you'll need some way of preventing them selecting more than three conditions. I generally only pre-set CFs and as (by choice) my ribbons are hidden to users so I'd need some way of invoking a method of selection, but I can't see me doing it so I can't...

As I said I agree with you that the utilities are the answer: my recommendation (which is no more than a couple of hours work) would be a first indication to give an idea if any real work is necessity. My experience is that any inherited database is far more work than one expects even if it...

Agreed but this needs nothing except a text editor!

Just been looking at previous threads on the subject where it is suggested that it is a bug. (And work rounds using VBA). I then checked on my old laptop running 2003 where you cannot actually add more than three, and since in 2021 I can add lots of CFs I assume the bug explanation has credence.

First question is which version of Access? In Access 2003 / 2007 the built in limit was three. Certainly in Ver 2021 I've used 4 (I think they all worked but I'm not certain) but never bothered with the finding out the limit. You'll need to look it up for your version.