Search results

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

I'm sure you'd feel the just as magnanimous if it was your material being plagiarised, whether it took you 2 minutes or several years ? No point in having any new ideas or thoughts at all on that basis.

If the table where these inserts are occurring has a Autonumber ID, you could simply record the Max ID at time x (load open, no idea which event is suitable) and compare it to the current MaxID via a timer event on the form. If it's greater than the last time you checked then you now know the...

You need to know the specific name of the printer the labelling reports are set up to print to . Once you have connected the printers in windows, you need to rename them on the new machine to match the expected name saved with the report. The original machine that this all worked on should...