Search results

Just not true - I have multiple versions running!

ANY is a predicate and works perfectly well. The reason you don't see it often is that it works practically the same as the IN predicate. The latter gained prominence because a number of early implementations of SQL (pre-SQL standards) did not include ANY.

A comment in passing. Access doesn't actually lock records but pages - not usually a problem but two or more small records may be using a single page in memory.

TempVars!XLA & "The Don McNair Herbarium Data Set.docx" as formatted is not a valid hyperlink.

The real reason it's not feasible/suitable for common usage is that its not what it was designed for. My son-in-law who is a ventilation engineer uses it all the time but he has 1) the real need for its facilities and 2) all the necessary paraphernalia such as flatbed printers etc to fully use...

This is why openargs exists. I know people normally use it when opening forms but it is also part of the OpenReport parameters as well!

Must admit when I saw this thread I thought it was describing me! 👨‍🦼

As I read all these posts about 365 and Win 11 can anyone think of a real reason to 'upgrade'?

The trouble with man-splaining is that the most common cry I heard from females ( in my post retirement job doing admin in a school) was that "nobody has shown me how to do it!". An even bigger crime was to suggest that they read the manual!

In passing I am constantly amazed at just how good KitaYamas English is. Of course there will be misunderstanding on occaission - think just how easy it is for Brits and US posters to misunderstand each other and allegedly we both speak the same language!

What worries me when I talk to myself is I still don't get get a sensible answer! And I am very careful when I talk to my computer as I remember the first rule of dealing with machines - never let them know you are in a hurry.

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...