Search results

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

If it needs sending when the form closes, why not use the forms close or unload event? (I may be missing something....)

@nector Have a read of this for a balanced comparison, rather than an badly formed opinion. https://blog.devart.com/mysql-vs-sql-server.html

It's not MySQL being a god send, it's the way it was connected, and being used. After a ton of rewrites the MySQL was better than the initial attempt to use SQL Server.

I think that's untrue. If it's coded correctly I'm pretty certain I have distributed Runtime applications that use CDO successfully?

That will be why no one uses SQL server then. What a stupid generalised statement. I'd like it backed up with some actual evidence. Preferably using the same hardware and similarly enabled software package.