Recent content by DickyP

Not me! Firstly you need to have hair (for me distant memory) and I'll need to live that long!😄

Use the file system object.

If you are using Access as your data there in point whatsoever in converting. ADO is slower and less flexible.

The real problem with using Switch() (especially in a query) is that it is highly inefficient. Unlike Select Case EVERY condition is evaluated EVERY time it is used, plus it returns Null (often thus generating errors) if no criteria are matched.

Unlikely since MS deliberately removed perfectly good, reliable integration with Source Code Management when it abandoned VSS!

As The_doc_man says - it all depends. My two 26" monitors attached to my desktop cost less together than half the price of my my TV and they are permanently attached in my study/office so there would be no sense in using a TV. However, as you can see that choice is based on the fact that I...

My worry is when an AI, Robot etc reaches the equivalent of a being a teenager and thinks it knows everything ....

Your English is great but you clearly don't understand the word analogue! It is a picture of the real world.

I would argue that if they can't read an analogue watch they can't actually tell the time! To teach analogue tme is a matter of minutes - it's , by definition, a picture of reality. A digital watch / clock is just numbers. After your original post I didn't reply immediately but first did a...

I just agree with Terry Pratchett in 'Hogfather'. "Real stupidity beats artificial intelligence every time."

Given your age (youngster compared to lot of us here) I have real sympathy. Having programmed in at least 12 languages for more than 40 years, I forget how confusing how something that is natural to many of us can be. My advice is to start slowly with a simple printed book and practice. Most...

While we are on domain functions don't forget the niggle of DCount where zero is returned both for a result of zero, for Null (which kinda makes sense although strictly mathematically wrong), AND for any other error!

Just not true -1 (Byte value Hex FF) , with 0 Byte value Hex 00) had been the standard since the 1970s when single signed bytes were used to represent Boolean in systems, which had no intrinsic Boolean data types. Access just followed the norm when it was being created in the late 1980s, and VB...

Let's face it the only reason for Trump's behaviour in effectively supporting Putin is to give legitimacy to his intentions to invade neighbouring countries (Greenland and Panama).

Absolutely correct reply as far as it goes. However, if you go to 'This PC' in Explorer it shows all attached drives