Search results

  1. JonXL

    Solved Format Number Field in Select Statement

    Seems like the real issue is you have something that isn't a number stored in a numeric data type.
  2. JonXL

    Disable Window Close Button

    I've never disabled the close operation (which I think might need more than just hiding the X - to handle shortcuts), but I do use a method in line with the nav/hidden form approach mentioned by several here to present users an "are you sure?" so they don't accidentally close and get frustrated...
  3. JonXL

    Array - Collection - Dictionaries?

    This is in the Excel forum...
  4. JonXL

    Array - Collection - Dictionaries?

    See the link in @Isaac's post for why I don't use integer for anything.
  5. JonXL

    Update a Field based off of another Field in the same Table

    I guess I read "can be overridden" to mean at the invoice level. So that would just take the one field. When users want to override the due date, they directly or indirectly update days due to get the date they want. I am not sure I follow the idea of a separate table for this one attribute...
  6. JonXL

    Update a Field based off of another Field in the same Table

    In line with above if you are going to store some additional value related to this, I'd make it the days allowed instead of the due date itself.
  7. JonXL

    Love the snow!

    I was seeing the snow before. I just use Brave.
  8. JonXL

    Love the snow!

    I don't see any snow or storm. :(
  9. JonXL

    Array - Collection - Dictionaries?

    Why use a collection when there are dictionaries? I haven't been able to see the purpose of the former in a world containing the latter. Is that like folks who still declare variables as integers? Or am I missing something?
  10. JonXL

    Merry Christmas and a Happy New Year in 2023

    Thank you for the site. Really one of the best out there. Merry Christmas. 🎅
  11. JonXL

    Estimating the age of the Universe, and getting it all wrong

    Interesting stuff there. If understanding your explanation of Oppenheimer correctly, it's not really that causality is a property of space-time but that it's a property of how we interpret space-time. So the question of First Cause isn't just irrelevant outside of (='before') space-time, but...
  12. JonXL

    Estimating the age of the Universe, and getting it all wrong

    That assumes something outside the system. When concepts such as cause and effect are understood as properties of space-time itself, it becomes unnecessary and even meaningless to ask the question of what 'caused' the existence of our space-time.
  13. JonXL

    ChatGPT: The Future of AI is Here!

    My brother and I were chatting about Wheel of Fortune. He commented that if you could figure out how to program putting the puzzles together, you could make your own game. I noted that the programming would be relatively easy and that the real work is coming up with the puzzles - not slotting...
  14. JonXL

    ChatGPT: The Future of AI is Here!

    Well let's simplify a bit - a good requirement is a requirement that is useful for one thing and one thing only. Which is why there are so many different types of requirements depending on the intended audience, as you note in your second point #1.
  15. JonXL

    ChatGPT: The Future of AI is Here!

    I don't know if I can answer "as soon as" but I'll try to respond in a reasonable time frame.
  16. JonXL

    ChatGPT: The Future of AI is Here!

    @Isaac How do you define "good requirements"?
  17. JonXL

    ChatGPT: The Future of AI is Here!

    What you describe there is a business analyst. A smaller company may have the programmers handle both roles, but for those programmers who are just programmers, this could completely do away with their job. Even the ones doing double duty as BAs would find their roles drastically shrunken to...
  18. JonXL

    Autonumber Primary Key Dupes

    I was thinking in similar terms to @ebs17 that the table possibly doesn't have the validation OP thinks it does and that the query process is responsible for the duplicates. It could be getting run multiple times or possibly the underlying query has some JOIN statements that are causing records...
  19. JonXL

    Office 365 record selector bar is partly hidden.

    It sounds like you were somewhat able to reproduce this(?) But just to add clarity because I don't recognize the screenprint you have with the 150% on it (being not familiar with W11), this is the setting I am referring to in W10: I believe there are several places where you can change...
Back
Top Bottom