Search results

Quoting anything about the story of Noah is a clear indication of insanity.

An accelerator pumping energy into a a bunch of particles is adding thermal energy to them because the kinetic energy of any particle is exactly the same as its heat. The only difference is the heated plasma is in coherence of movement due to the presence of external magnetic fields.

Though related, momentum is not the same as energy. Any kinetic energy can be considered to be thermal energy because that is exactly what thermal energy is. Nothing more, nothing less.

Cold Fusion does exist. Muon Catalysed Cold Fusion was demonstrated in the late 1940s. Interestingly the maximum efficiency of the reaction is at around 1000 Kelvin (~700 C) making it perfect for boilers. A muon is a heavy particle with a charge of -1, the same as an electron. Hence It can...

I agree. Why write a VBA function to remove double spaces when exactly the same process can be done far more efficiently in SQL?

I don't see the point of creating a Class Module just to hold some public functions. All you would be doing is making it necessary to instantiate an instance of the Class. Public functions belong in a Standard Module.

Pat's code is good way to convert connections. However the easiest way to create DSNless connections on new tables is to first create a FileDSN. Use it to link the tables and Access will configure them with a DSNless connection.

Developers should not be excessively focused on simplification of the appearance of the code. The simplest code is not always the most efficient code. Although I have not tested, I would expect Split() to have significant overheads., though it probably doesn't really matter much. The desire for...

Although they would work in this case, since it is also possible for folder and filenames to contain dots other than the extension separator, none of the suggestions so far should be considered as general solutions to removing the extension from a file name. The safest way to do this is a...

Yes. Now that this has been considered, the surprise is that it worked before. I developed the macros on an xlsx file then routinely converted it to a template, as one does with such things, without considering this factor in the code. It had been working from the template for over eighteen...

Yes same.

I immediately did exactly that when the error popped up. The Name was fine but the Path was NullString.

I'm assuming that the derived Master is no longer running de facto in the same folder as its template and the actual temporary location where it exists until saved is exempted from being returned by Workbook.Path. We have Office Administrative Templates distributed by Group Policy that control...

Ye Good lead. The Master workbook with all the macros is derived from a template. The macros generate a number of new workbooks from the data loaded automatically into the derived Master document using database connection when it opens. The path for these derived documents is created as a...

Suddenly, sometime between 5 Oct and yesterday, the Workbook path property is returning NullString. Application.Workbooks(ThisWorkbook.Name).Path Also happens on a new workbook with the expression run from Immediate Window. No updates to Windows or Office 365. What else could cause it?

The data is not being manipulated.

Holding a conspiracy theory means believing that there has been a conspiracy to hide the truth. You are claiming that Anthropogenic Climate Change is a conspiracy of thousands of scientists and politicians. You are the one indulging in conspiracy theory, though technically, at best, it would be...

That happened over a very long time. We are in the early stages of an incredibly rapid change.

Thank you for acknowledging your position. I avoid being stupid and ignorant by sourcing information from informed people and making my own critical analysis of the credibility, rather than indulging in confirmation bias.

You are welcome to hold any opinion you like. Others are entitled to point out that you are wrong. Welcome to rationalism. Holding an opinion contrary to the evidence is a fool's position.