Recent content by DickyP

I agree with the sentiment: I'm on 2021 but even normal changes are problematical. MS is becoming a bit bit like Boeing when changes are rushed out without proper testing. The mantra a good friend of mine who ran our testing group was that no matter how small the change you test the whole...

You have my sympathy - as I said I turned it off.

The only thing I've tried with Co-pilot before I switched it off was MS Word where it tried to replace good English with gibberish!

Just for the record to put things in a slight perspective, I still have 2003 (and 2010) on my old Win 7 laptop working quite happily. On my main PC I'm running 2021 on Win 10 which I moved to when my old HDD (Win 8.1) gave up the ghost. The transition/conversion from 2003 to 2021 databases...

Couldn't agree more!!

A warning - learned the hard way - make sure that Back-Ups being taken by the 'system' include everything you think they do IT departments are selective about what they think is, and isn't, important. Also get a back-up and see if it actually works.

Never had to do it since but 'just in case' we had code which stopped people logging in at BU time (0200). Can't actually say if it was ever invoked as we had no feedback one way or the other.

One warning here: DSUM and DCOUNT return 0 (zero) both for the actual value of zero and if an error is thrown (including a null value). Always considered this really 'helpful'!

However rational one might try and be about gold, it is a simple fact that it is valuable simple because it has always been valuable and its value is ingrained into most cultures. Wedding rings, anniversaries, everyday expressions like 'gold-plated' .... It's a simple truism that it's...

I used to do this sort of task, albeit on a generation basis, rather than weekdays not using Access at all. I just used Windows Task scheduler to run a a Windows Script Host script which did the copy and replacing. This was, however, in the days before VBScript was denigrated, but it could...

Concurrent sentencing is the norm in UK to the extent that I can't ever remember hearing of the award of consecutive sentences. However, concurrent does mean that every sentence has to treated individually when parole/release is considered.

Solar panels do not depend on bright sunlight to work. All daylight works - just not quite so well if it it isn't bright sunlight. a bit like remembering you can get sun burned when it's dull and overcast..

I too do not dislike the view of wind power turbines, but the the sad fact is that, given that they can't be recycled, it takes about 27 years to achieve a carbon saving from a turbine whilst at present the average life of a turbine is 17½ years.

OK - guilty as charged - should have read the code better.

Just a suggestion and may not be appropriate if SloMo wants his existing logic but the iteration and renaming would be far easier if SloMo were to use the FileSystemObject for this - ie, the correct tool for the job.