Recent content by DickyP

True but that is based on the bizarre suggestion you are going to use it for real without testing. If you do that you deserve everything you get.

If you want to guarantee that your references to a contro lis correct you can always use the  formname.Controls("controlname") form of notation.

As a footnote to my complaints about the National Lottery making minor, unpromulgated changes to their CSV results download files i thought I'd share my latest wheeze. The problem with the changes is that the necessitate commensurate changes in the Import Specs and hence a release of the FE...

For what it is worth I've always (at least since Access 97 which formally introduced classes), had a class which I call clsAppDetails, which I instantiate as ThisApp at Start Up holding all the data items I may want during a session. It may, or may not, been a sensible solution to Access...

The_doc_man has exlained very clearly my immediate reaction to this scenario: why is Access a problem? Answer it's not. Mind you I was thrown to start with by the use of the abbreviation PIV, as to me it refers to ventilation engineering!

I've never tried explaining to a cross-dresser, so I don't know :)

I'm assuming this is thread specific, because as a general statement it is far, far to sweeping.

Dunno - as far as I know I haven't yet been accused, at least not to my face, of mansplaining. I would say that I haven't noticed that men explain things differently to women than they do to men.

Mansplaining - a simple, normal explanation that annoys a female because she has to acknowledge that you know more than her on a particular topic.

My solution has been to save the historic data in the tables to XML, which is easily retrievable, when required.

I actually solved my need for the problem, not exporting to Word but creating Word documents in VBA code. Having done it once I have subsequently used it a number of times. I expect you wouldn 't like it as I have a template for about a dozen Avery labels. And a table of Label details - such...

I have several books both in English and in German. The latter are gerally longer, but not because of more words but because of longer words. My favourite is duplicator which in German is Vervielfältigungsapparat - it's no wonder they're adopting English words!

I am for ever grateful that I did Latin for 5 years. It's where I learned my grammar, and it's so useful working out what unknown words mean. Also did Greek which was less useful. Best thing about Latin was, for a teenage boy, the original material was full of blood, sex and adventures...

Agreed - the only real 'killer' is 'ü' which most English ears can't hear as it just like another regional variant of 'u'.

CROSS APPLY in SQL Server specific, not standard SQL. Not to say it isn't useful though! Of course, arguably, the uses for it are for badly non normalised data (which happens in the real world, unfortunately for we purists).