Recent content by DickyP

The received wisdom is not setting the filter in the report itself but in the DoCd,OpenReport statement in the WhereCondition or , if a stored filter exists, the FilterName parameter. OpenReport (ReportName, View, FilterName, WhereCondition, WindowMode, OpenArgs) As written above the filter is...

In one of today's papers: Uphill struggle for GB Bobsleigh team. (My bolding) I think I see their problem.

You,re obviously not wrong to use .RecordCount but I would tend to use While Not rs.EOF - does avoid problems (on occasion). If you feel that you have to use "Name" as your field name then put it in square brackets when referring to it: eg, rs![Name.]

As usual I have given up giving things up. ;)

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.