Search results

  1. G

    Titanic sub

    Because the equipment with the capacity to descend 4000 metres hadn't yet arrived. The only probable scenario involving the passengers' survival was that it had automatically surfaced and was able to be found before the oxygen ran out. Hence the urgent search of the surface. Moreover, most...
  2. G

    Becoming Free

    Another belief held in the absence of evidence. They surrendered to the will of their religion's oligarchy and led many to misery.
  3. G

    Becoming Free

    Such is the nature of religious beliefs.
  4. G

    Daniel Pineault - Devhut

    He is right. Tableau is part of the SalesForce suite which is on a a massive global uptake curve. SalesForce is what Daniel means by 'For anyone contemplating going into Microsoft Access Consulting, I say to you DON'T! Look towards the future and use a technology that is properly supported and...
  5. G

    Daniel Pineault - Devhut

    Try googling: daniel pinault tableau
  6. G

    Closing Forms

    Some developers hide the Application window completely and just show the forms and reports. That way users don't actually realise anything is missing.
  7. G

    Daniel Pineault - Devhut

    It looks like he is working with Tableau and likely does not want to encourage competition from Access.
  8. G

    How to get some fields directly from windows DLL (dynamic link library) into Ms Access Project

    DLLs are compiled so it doesn't really much matter so much what language they are written in. They have "entry points" which expose their functions to other applications. Their performance can be far superior to functions written in VBA because they are compiled. Register the DLL using regsvr32...
  9. G

    Becoming Free

    The canary in the cage rejoicing at the lifting of the cover is an excellent analogy for religion. Things look better but in fact you are still in a cage...
  10. G

    Becoming Free

    In fact the only place in the Bible where homosexuality is criticised is in Leviticus. Anyone who reads the rest of Leviticus will realise he was a complete nutjob. The passages where he goes on and on about how his sons must get the best cuts of meat should make it obvious he was self obsessed...
  11. G

    Closing Forms

    You could disable the Application Window Close button. There is code on this site to show how it is done with an API call.
  12. G

    What can you do in a CLR ?

    The process of implementing CLR in SQL Server is trivial. The crux of it is learning to code in a dot NET language. The big advantage of CLR is speed because the code is compiled. Written well, it will outperform anything procedural (as opposed to set based tasks where the engine excels) that...
  13. G

    What can you do in a CLR ?

    For just moving files or other interacting with the files system I would use the Powershell integration with SQL Server. For experienced VBA developers, it is easy to get started with CLR using VB.NET
  14. G

    Buying a Digital Photo Frame

    My wife is waiting for delivery of one our kids ordered that has an email address the family can send photos to.
  15. G

    Solved OrderBy in Union Query

    I believe your source has misunderstood. The order by applied to the whole, not "the last member-query of the set of queries in the union". UNION precedes ORDER BY in order of execution, so the ORDER BY is applied to the already unioned data. A subquery is not necessary.
  16. G

    Building a JSON Request Body in VBA

    Thus trading an underscore for a heap of extra typing that distracts from the actual code.
  17. G

    MySQL

    Yes but the same principle applies. A MySQL database engine is required to read the files. I assumed the links in posts 3 & 4 covered that back in 2021. Pat raised a related discussion. The BTW parts of threads can be quite interesting.
  18. G

    MySQL

    As it is with any Windows file. The extension is just a convenient way to associate the file with a program. For example, MS Word files don't need the docx extension to be able to be opened by Word. Information about the nature of files (other than simple text files) is stored in the first line...
  19. G

    MySQL

    The backup file extensions are bak. The actual database files are mdf with the log are ldf. The bak file contains the data plus some of the logs, depending on the type of backup used. The default location of the mdf, ldf and bak files can be configured. The tables and other objects don't live...
  20. G

    Exploring possibilities

    That "append" is exactly the clumsy process that the technique in my sample database avoids entirely. However Pat's suggestion is a solution frequently used by many developers. Unfortunately 561414 has totally derailed the thread with their obsession of trying to justify their extremely...
Back
Top Bottom