Recent content by GPGeorge

  1. GPGeorge

    Code library database

    I learned the hard way what Tom warns about. I have used an accdb as a library reference for many years. It includes my error handler. The last time I decided to modify it, I ended up chasing down dozens, if not hundreds, of instances in nearly a dozen databases I use. Never again. Instead, if...
  2. GPGeorge

    Blazor - replacement for MS Access?

    I created a website using Blazor with assistance from Claude. I found it to be a bit confusing for a while, to be honest. But once we got the hang of it, we did pretty well. You're showing the html, which is the interface component. I wrote the code in C#, or rather, Claude wrote my code in C#...
  3. GPGeorge

    Pat Hartman has left the building

    It does occur to me that a significant aspect of this discussion originated in the emergence of the UK's new Online Safety Act as a weapon against unapproved speech.
  4. GPGeorge

    Access Pacific User Group -- Create Auditing in an Access Database with 3 Mouse Clicks

    Join me tonight for a demo of what I like to call "Light-weight Audit Logging" for an Access database application. Using the code co-created with my Claude AI assistant, you can create the objects and code with 3 mouse clicks plus a bit of copy/paste. If you want to try your hand at automating...
  5. GPGeorge

    Kicking the Habit

    Point One: I find that Claude is very good a very high percentage of the time, but every once in a while I get into one of those loops where it recycles variations on a wrong answer. I often break out by asking Grok to analyze and clarify the results I'm getting from Claude. It has been...
  6. GPGeorge

    Access File Recovery

    <<The most well known app, which begins with S ,is, in my opinion as well, probably not going going to be worth the cost>>
  7. GPGeorge

    Solved conditional formatting

    Hi, there might be a slight language problem. We do not need to see a screenshot of just the result. We also need to see a screenshot of the form in design view showing us the actual rule you wrote for the conditional formatting. That's where the problem lies and where we can help you find an...
  8. GPGeorge

    Multiple member List

    In my own family tracking database, I've wrestled with the appropriate terminology for roles and relationships for the people involved in households and families. Traditionally, we have talked about marriages consisting of husband and wife and families consisting of spouses and children...
  9. GPGeorge

    Convert old DB

    Given the direction this discussion went, I'm going to preface this with a caveat: I assume this is a legitimate effort to gain access to the data. There is an open source tool called DBeaver, which is sort of a universal database management tool. Think SSMS for dozens of databases. It doesn't...
  10. GPGeorge

    Solved Tips To Ascertain 'User-Defined Type Not Defined' Error

    Re: Decompiling fixes random errors. "Stuff happens; it's Microsoft."
  11. GPGeorge

    Solved Gridlines

    The only thing visible in that screenshot is a layout containing three controls. You can apply gridlines to the layout so that the top, bottom, left side or right side of the cells in the layout are visible. It appears that you have set the gridlines for those cells in that layout to solid. If...
  12. GPGeorge

    Solved Gridlines

    Thank you. The three label controls at the top have borders around them. That's controlled in the property sheet in design view. It would appear the lines between records in the detail section are horizontal lines at the bottom of the detail section.
  13. GPGeorge

    Solved Gridlines

    You know what would help me understand the problem? Attach a couple of screenshots showing your reports in Print Preview and Report View so we can see these gridlines (or the lack of them).
  14. GPGeorge

    Strange query behavior

    Can you share the data so we can try to identify potential problems? Also, the description of the fields leads to the conclusion that there is a problem in the way supervisor codes are defined. We need more detail about that. Also, storing the calculated value is a less than ideal approach and...
  15. GPGeorge

    Today's Environmentalists Are Really Luddites

    When the topic of censorship first popped up recently (and feel free to censor my use of the term censorship to describe what's going on 😉), I predicted what was going to happen. At the first mention of "government" actions we all start looking over our shoulders.
Back
Top Bottom