Search results

  1. MarkK

    The Robot Revolution

    No, if a group is cohesive, coherent, and pursues noble ideals, it cannot be assimilated. Consider the example of the history of the Jewish people. A group can only be assimilated as a result of its own internal moral decay. If you fear assimilation, renew your commitment to the ideals of...
  2. MarkK

    The Robot Revolution

    My dad's generation was destroyed by war. He could hear the British bombers at night staging over Amsterdam. He could hear the occupying army, who for effect attached steel plates to their boots, marching the cobblestone streets. • It is a measure of the relative peace, stability, and luxury...
  3. MarkK

    The Robot Revolution

    We really would be better off if there were unicorns and leprechauns. I think it's hard to calculate the costs and payoffs of social media. One interesting and not well advertised side-effect of social media is that people forming relationships now, and having children, almost 90% of the time...
  4. MarkK

    Solved Code not save when at runtime

    Tip: you can run Compile from the keyboard (and Comment and Uncomment block). • Put your IDE menus into design view • Drop a toolbar command onto the main menu • Customize the name to include an ampersand (&) character preceding the key you want as a short-cut • Return menus to normal • Hit...
  5. MarkK

    The Trump Slump

    Trump promised winning, so much winning. We were going to get tired of winning, remember? If you don't agree he has under-delivered, then talk to your doctor. You might be suffering from "Lowering The Bar Derangement Syndrome."
  6. MarkK

    The Robot Revolution

    Bill Gates predicts no one will need more than 640K.
  7. MarkK

    The Robot Revolution

    And this is somehow new? What is all of history except constant rebirth?
  8. MarkK

    The Robot Revolution

    History is rife with people confidently predicting the end of the world. If you lived in Europe in 1940 or if you were a native American and the buffalo stopped coming, you'd have had a far stronger claim than "because AI," and you would still have been incorrect. • Change is guaranteed. •...
  9. MarkK

    How to deal with locking system in MS access safely in point of sales environment

    I would more likely just open a recordset and update it directly, rather that grab the key and execute an update query against the same row as is current in control recordset. Consider code like... Public Function RecalculateLineNumbers_RunSQL(ItemSoldID As Long) Const SQL As String = _...
  10. MarkK

    Setting Recordsource when there are two or more forms open

    No prob @Gasman!
  11. MarkK

    How to send filtered transactions in the MS Access Combo box with one Click

    Private Sub CmdSubmitTaxinfor_Click() Const URL = "http://localhost:8080/XXXXXXXXXXXXXXXXXXXXXXX" Dim dcn As Dictionary ' clear out the error log table CurrentDb.Execute "DELETE FROM tLog" ' Assume QrySmartInvoiceProductsDetails works correctly With...
  12. MarkK

    How to send filtered transactions in the MS Access Combo box with one Click

    I would move the http request code into its own procedure. Then you are free to call that procedure--with parameters--at each iteration. And it is then available to other future consumers. Also, you can add OR overwrite an existing dictionary keyed value if you do... CompanyDict("itemCd") =...
  13. MarkK

    Edited record vanishes from filtered recordset

    This is where the Modified As Date/Time field shines.
  14. MarkK

    Setting Recordsource when there are two or more forms open

    Here's a minimalist sample of the general idea. This isn't MVVM though. In this sample there is one configuration object type cTitledFormConfig, and it's a bit cheesey, but you can start to see how it could be useful, and how a pattern of abstracting form construction resources outside the...
  15. MarkK

    The Robot Revolution

    The jacquard loom took the human out of weaving textiles, and did the job better, faster, cheaper. Same thing. AI will have costs and payoffs just like fire. Harnessing fire made our lives way better, but fire is also a significant hazard. Same as AI.
  16. MarkK

    Setting Recordsource when there are two or more forms open

    Borrowing from MVVM, I increasingly like to pass a "ViewModel" class to the form after it opens so the form has everything it needs as live, strongly-typed objects. So rather than re-hydrate objects, or resolve references from strings, I'll run a Property Set ViewModel(vm As IViewModel), and...
  17. MarkK

    Edited record vanishes from filtered recordset

    You could put a "Retain Edits" checkbox on the main form, a Date/Time modified field in the RecordSource, and a filter clause sensitive to checkbox state and when the form was opened. This gives the user a low friction way to control this outcome. And for extra credit, store the Retain Edits...
  18. MarkK

    The Robot Revolution

    The word sabotage originates from the early 1800's after the invention of the the jacquard loom, commonly considered to be the first programmable machine. A sabot was a wooden shoe, and newly unemployed textile workers would, apparently, throw their shoes into the new looms as a protest against...
  19. MarkK

    DLAST FOR DATE SERIAL

    I think there's also a distinction worth drawing between data storage and data presentation, input and output, which are the two tasks you might have to perform when working with data. • For purposes of input or storage, there is no advantage to show data in the current row that does not belong...
  20. MarkK

    SQL problem

    If you have a working query, there is no advantage to dump its results into a table. To any consuming process, the query itself is indistinguishable from a table and, since it queries the live data, it's guaranteed to be current. When you render it out as an actual table, you create these...
Back
Top Bottom