Search results

  1. MarkK

    AI Options

    I was chatting with AI about love. It posed this question... When you imagine acting out of love in a hard situation — confrontation, departure, sacrifice — does it feel like expansion or contraction in your body? Like wtf?!?! How does a machine, in an abstract conversation, generate that?
  2. MarkK

    Fictional Stories

    Anything humans create incurs a cost to produce and distribute. This being the case, an interesting question to consider in respect to any story/claim/assertion is... • Who will profit from it? This is a 'follow the money' trope, and exposes dynamics far more nuanced than a true/false or...
  3. MarkK

    Using MS Access and Azure Doc Intelligence (or COPILOT)

    I think the scope of your question is broad, and may in many cases require book-length response. But yes, I have successfully submitted questions to AI via HTTP and received valuable responses. It's possible a PowerAutomate Flow might offer you some kind of generic wrapper for specific...
  4. MarkK

    Forms not refreshing when navigating between them

    Are you sure? This causes an 'overflow' on my machine (because 2 ^ 15 exceeds Integer).... Me.Text0.Width = 2 ^ 15 This causes 'The control or subform control is too large for this location' (because the form isn't that big) Me.Text0.Width = 2 ^ 15 - 1 What I run into most is setting...
  5. MarkK

    Solved Filtering problem

    How have you tried using DateValue()? This sounds like the result you would get if the date values in the table do not include times. What are the table values in the date_of_change field for #4/12/24#? Try this in the immediate pane... ? cdbl(#4/12/24#) Then try this... ? cdbl(#4/12/24...
  6. MarkK

    Forms not refreshing when navigating between them

    Most MS Access control location/dimension properties (Left, Top, Width, Height) are typed as Integer and represent Twips. • The max Integer is 2 ^ 15 -1, or 32767. • There are 1440 per inch. Doing the math, 32767 / 1440 = 22.755 inches. Lots of modern monitors are way bigger than that. It's...
  7. MarkK

    "DROP TABLE table" works once then fails later on.

    If you have a ProcessA that consumes a subset of rows from a larger table, and you have query qrySubsetA that correctly returns those rows... It is a make-work project to... • Drop tblSubsetA • Create tblSubsetA = qrySubsetA • Execute ProcessA with tblSubsetA It would far simpler to... •...
  8. MarkK

    Raise your hand

    I don't think you can express idealism in practical terms. In practical terms, the US is in trouble. Have you seen tape of the current head of the DOJ in front of congress? OMG! • Implementing ideals requires respect, first of all for your colleagues, and then of course, for the ideals...
  9. MarkK

    Raise your hand

    OMG! You're so... idealistic! : )
  10. MarkK

    self-referencing table with bridge

    I agree. A 'category' must be a squishy UX distinction.
  11. MarkK

    AI Options

    If you experience AI as sweet-talking you, ask harder questions. If you ask AI to validate your process, it will, even if that process has glaring deficiencies. I increasing ask AI how my process sucks, and how it's likely to fail. AI is like a mirror.
  12. MarkK

    Prompt for name

    And with a single table you can omit the table name, like.. SELECT DISTINCT Name FROM MSysObjects WHERE ParentId = -2147483645 AND Not (Name Like '*Sub*') ORDER BY Name;
  13. MarkK

    self-referencing table with bridge

    I think this is true from a purist perspective, but it's convenient to just sum a single field as opposed to summing credits, summing debits, and then summing the sums. But it is proper accounting to have debit and credit accounts, and to post debits or credits independently.
  14. MarkK

    AI Options

    I once asked an AI why it sucks so bad at VBA, and it explained that VBA is wrapped in a file type that requires opening an application, so it has (and it stressed this point) far fewer code examples to consult.
  15. MarkK

    self-referencing table with bridge

    Here are my accounting system tables. • Journal rows that are in Invoices and Bills require a linked Payee, enabling creation of a Payee statement. • AccountTypes are Asset, Expense, Revenue, Liability, Equity. • This is the simplest Journal form hosting the simplest Post subform... Maybe...
  16. MarkK

    self-referencing table with bridge

    That's why you come here. :unsure:
  17. MarkK

    self-referencing table with bridge

    Your structure would be way simpler if you abandon the idea that a category and an account are not the same thing. I think Quicken misleads in that regard. A 'Category' in Quicken, if you think about it as an accounting principle, is just another Account. Quicken does that so you can define the...
  18. MarkK

    Daily Backup of BE Database

    I should also say, most backups I make never get touched. So I can't claim it always works, only that it always has when I've needed it to.
  19. MarkK

    Daily Backup of BE Database

    • I routinely make a backup copy of our BE table at work. It is almost never in a state where zero FEs are connected to it. I have never had the experience that the copy I made is unusable. • For a while, when I was getting a lot of FE crashes during development, I wrote code that made a backup...
  20. MarkK

    self-referencing table with bridge

    Don't you need three tables in a many-to-many relationship for a proper double entry system? I would expect to see tables Transaction, Post and Account, where Post carries an Amount field and foreign keys to the two other tables, and a rule enforced that post amounts in a transaction sum to...
Back
Top Bottom