Search results

  1. jdraw

    Another Loss of Some Note (or Notes)

    There is a well-known anecdote about Tom Lehrer, but it's best categorized as an apocryphal or satirical story, not a verified true incident. The story you're referring to likely goes something like this: However, there is no credible evidence that this ever truly happened. It appears to be...
  2. jdraw

    CoPilot removed by recent Windows update

    Regarding "tools and toolboxes": If the only tool you have in your toolbox is a hammer (insert your AI tool du jour here), it's strange how every problem seems to be a nail. I remember this when those who knew Fortran, everything was a Fortran problem, same with Cobol, PL1, BAL..... I have...
  3. jdraw

    Access 2016 vba

    Hi Jerry! Welcome aboard AWF. Lots of retirees/semi-retirees in the group.
  4. jdraw

    Future of Access

    What is the popularity of cobol programming today? From copilot COBOL might not be the hottest language on the block, but in 2025, it's having a bit of a renaissance—especially in sectors where reliability trumps trendiness. Here's the scoop: 📊 Popularity Ranking According to the TIOBE...
  5. jdraw

    Different Format in Monaco Editor

    I think Crystal (strive4peace) has a free add-in that transforms sql into the format on the left side.
  6. jdraw

    Solved Method of selecting specific records

    What exactly is the "selection"/condition that causes the user to select a given record? Your example 1111 sal@co.com 1112 fred@co.com 1113 ann@co.com 1114 gef@co.com ===return 1112 and 1114 could be satisfied with something like: select * from your query where email like "*f*"...
  7. jdraw

    Solved Method of selecting specific records

    Perhaps a little more context will get more focused responses. What is the "selection process"? What is the "function" to act on selected records? A sample would be useful.
  8. jdraw

    want to come to an online user group meeting?

    Thanks John. I tried that several times ---kept getting Unable to accept the invite. Have gone thru a few hoops to get a new account. Finally have an account, but had to use firefox and edge to get info to supply the web prompts. Sure hope the "juice is worth all the squeeze"
  9. jdraw

    want to come to an online user group meeting?

    Whoops is on the display Unable to accept the invite. George, I'm sure I created an account when the video was produced (2024) but have never used it. Trying to create a new account...answered the form with displayName userName (said great it is available) accepted a generated password added...
  10. jdraw

    want to come to an online user group meeting?

    Interesting. I tried the link that George provided in UA. Repeated the accept but constant "Whoops"?
  11. jdraw

    New Here

    Hi Ken. Welcome. I have often referenced your materials in responding to questions.
  12. jdraw

    Jackdaw

    Welcome aboard AWF! I spent many years in Ottawa.
  13. jdraw

    Using variables as field names

    Jackdaw, Can you tell us in plain English what you are trying to achieve? Perhaps an example of some input and corresponding output/result. What do you mean by k = rdsR! ?
  14. jdraw

    Solved Runtime error 3075, missing operator error in SQL expression

    Mike, I don't think 'IS' is proper syntax. Just found a sample: w3schools SELECT * FROM Customers WHERE Country IN ('Germany', 'France', 'UK');
  15. jdraw

    Solved Filtering range of records

    Here is a quick review of your IsTransferValid function (via Chatgpt) Issue / OddityComment DocNumber parameter is never usedIf the caller supplies it, you might have planned extra validation that hasn’t been coded yet. Third check in the range logic seems counter‑intuitiveSQL ...
  16. jdraw

    Solved Filtering range of records

    "you can see record with docnumber 347 subnumber 3 says that between docnumber 348 and 349 there is next record 347 with subnumer 4 and that record exist"?? How would a reader know what subnumber 3 means? As DHookom said 'No one here can read your mind.' I suggest you leads us through a...
  17. jdraw

    Solved Extracting part of string

    So, why is the thread marked SOLVED? The solution may help someone else. I tried a few things. Major assumption--your field [transfers] can only have 1 space char between numbers eg. 34_567/45/2029 45_5687_42/3045. There can be 2, 3, or 4 number sequences in Transfer Test data...
  18. jdraw

    I need the minimum value among 5 different fields in one record

    I like the parable George. We've all been there. The other "beautiful tree" scenario is "I've got so much time and effort into this that I can't possibly stop and correct the design flaw"!
  19. jdraw

    Solved Filtering range of records

    I agree with the others---what are you talking about exactly? Give us a few examples so we understand the issue. Between in Access includes the end points.
  20. jdraw

    Can you give me a good YouTube channel link or a website where I can properly learn ms access ?

    moin555, You have been given advice based on a variety of experiences. I have a lot of older references in my signature that I consider "good sources of info", but each respondent has his/her own favourites. Steve Bishop, Allen Browne, Crystal Long(strive4peace), Daniel Pineault(devHut), Colin...
Back
Top Bottom