Search results

The dismissal of the elected federal government of Gough Whitlam by the Governor General. 11/11/1975. https://en.wikipedia.org/wiki/1975_Australian_constitutional_crisis I was in a biology class too, first class after lunch, when the teacher walked in and said, "They sacked Gough.". Another...

The information at the link makes a perfect explanation of a completely pointless use of Sequence in a seriously denormalised design. I feel embarrassed for the author.

They we all seriously delusional, mentally ill people who presumed their prejudices were given to them by a supernatural being. The real fools are those who believe in them,

There is no evidence for the existence of the biblical Jesus.

Lennon asked us to imagine a world with no religion.

Religion is is a form of mass hysteria based on holding beliefs without question. It is indistinguishable from mental illness.

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