Pat Hartman's latest activity

  • P
    It isn't the number of items in a table that causes work, it is the number of tables, especially tables that do the same exact thing...
  • P
    Then it is perfect to move them all into a single lookup table. Way easier to manager.
  • P
    Pat Hartman replied to the thread Clear out data.
    What you NEED is to normalize your schema so you don't have THOUSANDS of forms that do the same thing. And the best way to handle a TOC...
  • P
    Pat Hartman replied to the thread Clear out data.
    Then you actually know very little about COVID. But we've covered that in other threads so we won't go into it here. You have crippled...
  • P
    Pat Hartman replied to the thread Clear out data.
    That is also a huge mistake. Macros are significantly harder to create and logically confusing compared to code. Code (at least VBA)...
  • P
    Pat Hartman replied to the thread Clear out data.
    And do you expect them to import new objects and manually modify table descriptions when new fields are necessary? ALL useful...
  • P
    Pat Hartman replied to the thread Clear out data.
    A larger monitor is not the solution. It is not necessary to see every option for every group on a single screen as you showed with the...
  • P
    Pat Hartman replied to the thread Clear out data.
    Some research should take priority. I'm not saying that you should immediately go back and remove all your unnecessary lookup tables...
  • P
    Pat Hartman replied to the thread Clear out data.
    What planet do you live on? I can't think of a single food recall that has ever affected me personally and I've been cooking for the...
  • P
    Pat Hartman replied to the thread Clear out data.
    If you decide to add "help" that is accessible by ? buttons, Create the help in a table so if you need to describe blood pleasure in...
  • P
    Pat Hartman replied to the thread Clear out data.
    Not if you instead learn how to normalize your data so that each disease doesn't require its own table. Do you think a hospital...
  • P
    Pat Hartman replied to the thread Clear out data.
    And how many lookup tables do you have? And did you bother to look at the mini-app I provided a link to so that the maintenance of...
  • P
    Pat Hartman replied to the thread Clear out data.
    It goes well beyond this. Adding new columns to an existing table is fairly common after the app has been distributed. Say you have 5...
  • P
    Pat Hartman replied to the thread Clear out data.
    This is what documentation and validation are all about. You can add little question marks next to fields that explain the rules and...
  • P
    Pat Hartman replied to the thread Questions to God..
    My dissonance came about as I studied history and learned of the many evil things done in the name of God by the church hierarchy. It...
Back
Top Bottom