Search results

  1. GPGeorge

    Solved Confused on what Form event(s) to use that display form with only statis text before VBA code executes

    I gave up on that free tier after the first day, for exactly this reason. The only value it has, IMO, would be as a testing environment for non-production applications. "The function doesn't exit until it gets a connection or the number of tries is exhausted (say up to 75 secs)." Making users...
  2. GPGeorge

    Win 11 Word spell checker

    Also, it might make a difference to know which version and build of Word you have installed.
  3. GPGeorge

    Win 11 Word spell checker

    What symptoms are exhibited? Obviously incorrect spelling not identified? Correct spelling flagged? Nothing at all?
  4. GPGeorge

    long text scrollbar issues

    That looks to me like it might be related to monitor size and resolution, then. Check out Colin's Form Resizer.
  5. GPGeorge

    Future of Access

    My goodness. We've been begging for better ODBC connection handling for 10 years now.
  6. GPGeorge

    AI Code - 10 years out of date

    https://en.wikipedia.org/wiki/Vibe_coding
  7. GPGeorge

    Solved Stub method is giving me issues

    Technically correct, but beside the point. As noted, "The differences are the behavior and nature of the objects being referenced. " The point is to provide sufficient context to the prompt so that answers will should be pertinent to the task at hand. In this case, the context is an Access...
  8. GPGeorge

    Solved Stub method is giving me issues

    Another prompt I've heard about, but not yet had a chance to try is along the lines of. "You've been hired as the senior developer on an Access VBA project. Use your most advanced VBA skills to solve the following problems/address the following requirements/create the following solution."
  9. GPGeorge

    Future of Access

    I agree. The obsession of running in a browser is, in my opinion, somewhat of a side issue. That focus remains on an either/or choice and that is a false choice. Back in 2008 or 2009, I was part of a development team. We were a couple of Access developers and a web developer. I created the...
  10. GPGeorge

    2 queries in one form

    Please clarify. Is it the case that you actually have two different "Codes"? That is what this paragraph suggests. "...the item code is a hardcode[d] id from the factory itself..." "...the serial unique id case comes up only when stock is added to the shelve.." Please confirm: Is there a...
  11. GPGeorge

    Future of Access

    In the past, I've tried to make the point that adding a web-based component to an Access solution is not the same as replacing the Access solution with a web-based solution. One of the many reasons Access has never been recreated for the Web is precisely that. You don't need to duplicate the...
  12. GPGeorge

    Future of Access

    10 years too late, I'm afraid. And, to be very blunt, a project that is quite unlikely to blossom due to lack of a coherent guiding plan and leader. I'm not being critical of anyone at all. To the contrary, I admire the ambition. What I'm suggesting is that Wayne Phillips' TwinBasic is the...
  13. GPGeorge

    Future of Access

    While I was being tongue in cheek, I'm pretty well convinced that PowerApps simply can't compete on an equal footing with Access. You note that I resorted to SQL Server Stored procedures to get the functionality needed to replicate Northwind Developer. There's a good reason for that. The basic...
  14. GPGeorge

    Future of Access

    Fixed it for you.
  15. GPGeorge

    Cannot update Sharepoint list

    I feel the need to muddy the waters. It appears to be that Access DOES rely on the Display Name, rather than the internal name. SELECT * FROM tblAlbum WHERE AlbumID > 2 By the way, note the plethora of meta-data fields in the linked SP lists shown in the Access Relationship window.
  16. GPGeorge

    Cannot update Sharepoint list

    I have used Chatty. I like Chatty. Chatty is not never wrong. But wrong less often than I am, probably. What Chatty has that I don't have is a great memory for things that happened 5 years ago.
  17. GPGeorge

    2 queries in one form

    The Northwind Developer template in Access handles inventory on a binary basis, which is similar to what you describe. You either ship 100% of the items on an order, or none. While this is probably not the predominant approach, it is valid. You can download the Northwind Developer template...
  18. GPGeorge

    Cannot update Sharepoint list

    Sorry, I was wrong. It is shown in the PowerApps environment as "ID", even when it's display name is changed.
  19. GPGeorge

    Cannot update Sharepoint list

    I have to disagree on the renaming. I think you really did rename that field. I think the "internal" name is probably something else. However, I don't know that for sure. I can check, but it'll take a while to ferret out an example to test.
  20. GPGeorge

    Cannot update Sharepoint list

    I would very much like to see the results as well. Thanks.
Back
Top Bottom