Search results

(Half joking) Maybe Surname is a weird word. I have a query in SSMS where SURNAME is a column in a Temporary table. No matter what I do, SSMS is absolutely convinced it is an invalid column name when I refer to it in the main main query. It is perfectly happy with all the other columns in the...

I have had cases where I could see the reality would be that the program settings would need change in the future, despite users assuring me that it wouldn't. So built in what made sense and simply hid the extra functionality from the front end. Sure enough, before long, the request to change...

I would have expected transaction and expense to be a many to many. An expense can be paid over multiple transactions. A transaction can pay multiple expenses,

Such is the nature of delusion.

Note that ADODB wildcards are the percent (%) for up to multiple characters and underscore (_ ) for a single character.

Maybe Putin didn't pay the bills? One way or another it is definitely a bad idea to piss off a mercenary army.

That "truth" is called "illusion". The mind stops working quite so well and gets confused when it's energy supply is failing during brownouts. Some people take drugs to get the same kind of effect.

I used to think that too, and while it is mostly effectively correct, it is not technically correct and will behave unexpectedly in some rare cases if that is the expectation. I am guilty of having misled other developers so I will set the record right here. The brackets actually mean "evaluate...

Because the equipment with the capacity to descend 4000 metres hadn't yet arrived. The only probable scenario involving the passengers' survival was that it had automatically surfaced and was able to be found before the oxygen ran out. Hence the urgent search of the surface. Moreover, most...

Another belief held in the absence of evidence. They surrendered to the will of their religion's oligarchy and led many to misery.

Such is the nature of religious beliefs.

He is right. Tableau is part of the SalesForce suite which is on a a massive global uptake curve. SalesForce is what Daniel means by 'For anyone contemplating going into Microsoft Access Consulting, I say to you DON'T! Look towards the future and use a technology that is properly supported and...

Try googling: daniel pinault tableau

Some developers hide the Application window completely and just show the forms and reports. That way users don't actually realise anything is missing.

It looks like he is working with Tableau and likely does not want to encourage competition from Access.

DLLs are compiled so it doesn't really much matter so much what language they are written in. They have "entry points" which expose their functions to other applications. Their performance can be far superior to functions written in VBA because they are compiled. Register the DLL using regsvr32...

The canary in the cage rejoicing at the lifting of the cover is an excellent analogy for religion. Things look better but in fact you are still in a cage...

In fact the only place in the Bible where homosexuality is criticised is in Leviticus. Anyone who reads the rest of Leviticus will realise he was a complete nutjob. The passages where he goes on and on about how his sons must get the best cuts of meat should make it obvious he was self obsessed...

You could disable the Application Window Close button. There is code on this site to show how it is done with an API call.

The process of implementing CLR in SQL Server is trivial. The crux of it is learning to code in a dot NET language. The big advantage of CLR is speed because the code is compiled. Written well, it will outperform anything procedural (as opposed to set based tasks where the engine excels) that...