Search results

The quote I cling to is from the Burial Service in the book of common prayer (Psalm 90). " The days of our age are threescore years and ten; and though men be so strong that they come to fourscore years, yet is their strength then but labour and sorrow; so soon passeth it away, and we are...

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

Two points. It's not narrow as it is the only applicable law. Secondly the answer to your question is yes (unfortunately). A Gender Recognition Certificate costs £6 .

Just another example of (mainly by uneducated media) of the corruption of perfectly good words from ignorance or malice - like the word gender itself. Other example which irks me are that things in UK are regularly described as 'iconic' when the word itself really refers to resembling a...

Just to nit-pick the law isn't new - just the existing one clarified, so it's already in effect.

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'?

Because it's old it doesn't mean it doesn't work and isn't the best tool for the job. I regularly use DOS commands. Recently used .ini files as the simplest way to do multi user look-ups.

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.