Search results

  1. 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>>
  2. 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...
  3. 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...
  4. 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...
  5. GPGeorge

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

    Re: Decompiling fixes random errors. "Stuff happens; it's Microsoft."
  6. 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...
  7. 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.
  8. 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).
  9. 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...
  10. 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.
  11. GPGeorge

    Solved view attachments from many tables

    Having looked at the sample provided, it's clear that the problem is more complex than displaying related attachments. It's likely that the sample provided is actually not the same as the real tables in the working database either. "Tbl_A" and "Tbl_B" appear to be pseudo tables created only for...
  12. GPGeorge

    Solved Email current record for form

    As Gasman says, you need a report that formats the work order exactly as you want to send it to the contractor. It can be similar to the appearance of the form, but will probably be quite different -- based on your description of the problem. For the report, create a query with a WHERE clause...
  13. GPGeorge

    How do I create an Access/Excel add-in AI powered, to recommend/optimize vba code?

    This would be a good question for ChatGPT, would it not? 😉
  14. GPGeorge

    Local file in new webbrowser control

    Okay. In both M365 Access 32 bit and 64 bit, the local html pages load without the leading = in the controlsource, so I wondered if that was a factor in your problem. Regarding the code, have you inserted a break point and walked it to see if that shows you something useful in diagnosing the...
  15. GPGeorge

    Local file in new webbrowser control

    Please show us the code that doesn't work, then. It sounds like you are setting the control source at runtime.
  16. GPGeorge

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

    Please join us for our Monthly Chapter Presentation November 6, 2025, at 6:30PM Pacific (UTC -8) With an assist from my team of personal assistants, Claude and Chatty, I created a three step process to add lightweight auditing to an Access database application. It’s built on Data Macros to...
  17. GPGeorge

    UK Online Safety Laws - I, and therefore the site, are at risk

    You have hit the nail on the head.
  18. GPGeorge

    How to give a fancied DBA read only version of the tables.

    Are we talking accdb back end?
  19. GPGeorge

    UK Online Safety Laws - I, and therefore the site, are at risk

    1. I personally wouldn't miss the Politics or Water Cooler Forums. I have them on "Ignore" now anyway. Simple, clean, effective, by the way, for those who keep whinging about them. It's all about exercising your freedom to choose. Shutting them down would reduce the risk to the site itself...
  20. GPGeorge

    UK Online Safety Laws - I, and therefore the site, are at risk

    That's the one I mentioned.
Back
Top Bottom