Recent content by DickyP

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.

You'd often hear the cry - 'change or die'. This has always been meaningless, as 'change and die' is equally likely: a diferrent platitude - 'hang in there ' - is as often just as valid. As doc man says, you need to know what needs changing.

Hence my complaints on the changed message box thread. Change for the sake of change instead of fixing the bits that need fixing.

Had an even better one today - Went to log in to one of my credit card's web site and they had swapped the position of the 'Continue' and 'Go Back' buttons during the login process. Everything else appeared unchanged just the buttons. Luckily the Continue was still the default if you use the...

After almost thirty years of programming for a living and enjoying nearly all of it, I kept going with Access to 'keep-my-hand-in'. My Access lottery db I started when running a syndicate at work back in the days of Access 2 and it has been, changing, expanding (but not necessarily improving)...

I must admit I have abandoned using Edge because every time it upgrades silly thing happen. Gone back to using Chrome.