Search results

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.

https://www.pinterest.com.au/pin/581738476870726778/

Yep. Not just Google. And not just listening to you. Integrating every bit of information from you, your family, friends and everything else in the world. I was at my granddaughter's fourth birthday party and mentioned the Two Ronnies Fork Handles skit while my daughter in law was lighting the...

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

It was simply to form a constitutionally recognised body that would advise the parliament on matters of legislation that affected aboriginal people. It would have no power at all. Australia is unusual in that the government has the authority to pass legislation specifically pertaining to...

Flying in a glorified doona (quilt, duvet, whatever you want to call it) cover has to be one of the most remarkable things I've seen in my time.

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

There can be no peace ever while people continue to worship Abraham's Monster. We should remember that the common founder of Judaism, Christianity and Islam was a madman who was about to murder his son when he had a moment of sense.

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.