Search results

Trump and Vance demonstrated a total lack of understanding about the situation both politically and the wide international perspective. Vance makes Trump almost look intelligent. Which might be why he is there. This sums it up about a well as anything.

I suspect Colins excellent application can assist you: https://isladogs.co.uk/email-tester/index.html

The removal of statues has happened recently in the UK. Most famously by a mob in Bristol, because the statue was of a man who had profited from the slave trade. History should not be re-written. Trump changed the local name of the Gulf of Mexico, not for any altruistic reasons, but because he...

I think in most of the cases mentioned above there has been a public debate about the prospective change and a consensus of opinion. You know, like adults...

This is all based from the perspective of someone far far away but, I'm not to sure any Country would be happy with a third party not inviting them to talks on a war, they didn't start, and don't want to surrender in, even if they had been assisting you previously. Renaming something like the...

My view is that our super efficient, money and resource rich government, won't have anything like the time or inclination to actually police this act except in really extreme cases. I'm a member of a forum that has some very interesting points of view expressed by a number of participants...

You would use a CCurr() , CLng(), CDbl() type of expression to force it to a specific data type. I think Access is quite lose with data type conversions. You can easily do "text" & 1 and it will work. "text" + 1 won't however.

Actually, having written the above, I have found a more trustworthy source from Microsoft - you just have to hunt around for it: https://support.microsoft.com/en-us/office/introduction-to-data-types-and-field-properties-30ad644f-946c-442e-8bd2-be067361987c#bkmk_refnumber Scroll down to the...

A single has a large range, but not large accuracy. This can support 7 significant figures with 6 decimal places. As such I understand why it exists but in this day and age of cheap storage, personally I really don't see any use for it. A double can support 15 significant figures with 28 decimal...

If Arnelgp's function works then that's good. I would put suitable comments in to it now whist you understand it, as when you revisit it in 6 months time to adjust it you won't know what to change or why.

You can handle that in the Case Statement with a Case Else at the end. Select Case stops checking the other conditions as soon as one is true, or uses the Case Else - it's much cleaner to read and more obvious what is happening.

As previously stated you are missing End If's - I'm surprised it compiles. I often use select case statements for this type of thing: Public Function ReturnUMS01(strText As String) As String If strText Like "IBAN*" Then SELECT CASE strText CASE...

Just doing a migration from a legacy Access app to SQL and a surprising number of 19/01/201 type dates are causing some issues. It won't be the last time...

I think with all these things you need to have a hard rule. Similar to being a good auction bidder. You have a pre-set limit. You stick to it. So you invest £100. Your cut off "get out" is set to £350. If it never makes it you pull when your patience runs out and/or you've lost your gamble...

I think that a majority of people that are in the LBGT+ type of minorities, don't want it either, they are simply pulled into the arena by snowflakes virtue signalling on their behalf. It's the "get offended on someone else's behalf" brigade that are the real cause of the DEI type of policies...

You can use a temp table in a function but it has to be declared as a table variable @tablename More here : https://stackoverflow.com/questions/9844854/is-it-possible-to-have-temp-tables-in-a-function I don't think you can use any index on it though. If it's that complex maybe a stored...

I would strongly suspect he had no idea the Tower was understaffed at that point he made those comments. It was his usual babbling incoherent rhetoric when it was completely uncalled for.

Thank you Pat, the OP is actually based in the US, so I'm not a very local solution, but I'll have a quick go.

I've sent you a direct message.

The DEI policy is a good one to get rid of. It's gone way too far trying to accommodate every minority and their dog. We have the same pandering culture gone mad in the UK. But the press conference should have been about the crash, not deranged rambling politicised guesses as to the cause with...