Recent content by MarkK

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

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

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

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

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

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

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

No prob @Gasman!

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

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") =...

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

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

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.

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

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