Search results

  1. GPGeorge

    Skip Rewriting the Same Code — Standard Code, Abstraction, and a Root Interface

    Interesting alternative viewpoint. I wish you'd had the opportunity to participate in the after-presentation discussion.
  2. GPGeorge

    Skip Rewriting the Same Code — Standard Code, Abstraction, and a Root Interface

    The video from Eric Blomquist's April 2nd presentation of his Access Root Interface and Object Superclass Framework for the Pacific chapter of Access User Groups is now available on YouTube. Links to articles further describing them are in the video description. Eric Blomquist walked us...
  3. GPGeorge

    Global variable resets to zero ???

    No, because that does not seem useful to me since the resulting tempvar would still be a untyped. I'm willing to be corrected, though, if I'm wrong.
  4. GPGeorge

    Global variable resets to zero ???

    At least that's the theory. :unsure:
  5. GPGeorge

    Global variable resets to zero ???

    Basically, the wrapper returns the value extracted from the tempvar, appropriately typed.
  6. GPGeorge

    Global variable resets to zero ???

    Partly for this reason I have wrapper functions for tempvars. Option Compare Database Option Explicit Public Function TempVarsBoolean(ByRef VarName As String) As Boolean TempVarsBoolean = Nz(TempVars(VarName), False) End Function Public Function TempVarsDouble(ByRef VarName As String) As...
  7. GPGeorge

    Date handling

    Screenshots are less useful than copying and pasting the actual SQL. Thanks.
  8. GPGeorge

    The trouble with getting old ...

    Most of this rings a bell for me, with the exception of using a tablet or smart phone for mobile apps. I have several PowerApps apps that must be usable "while walking around." For example, one is a shopping list that goes to Walmart with me. I designed it specifically for a smart phone. I have...
  9. GPGeorge

    Solved How to migrate MS Access forms or recreating forms to the web based forms

    It occurred to me to follow up with a comparison. Browser on top, iPhone on bottom.
  10. GPGeorge

    Solved How to migrate MS Access forms or recreating forms to the web based forms

    Brilliant strategy. Once people actually see what a phone screen can accommodate, they can begin to consider realistic options. Another idea might be to ask them how many screens would they willing to navigate through to complete a multi-step process.
  11. GPGeorge

    Solved How to migrate MS Access forms or recreating forms to the web based forms

    I've been thinking. https://www.gpcdata.com/blog/242
  12. GPGeorge

    Solved How to migrate MS Access forms or recreating forms to the web based forms

    I think that you've made a pretty good case for the traditional saying, "Look before you leap." And that was, in a way, the thrust of my questions. I can't answer your questions in the abstract either. That's the crux of the matter, as I see it. It's relatively easy to talk about how...
  13. GPGeorge

    Solved How to migrate MS Access forms or recreating forms to the web based forms

    Can you elaborate on the costs and resources required for a small to medium sized organization if they elect to create, say an Android app, or an iOS app, for their own internal users. How do they deploy and manage the app? How do they determine which users are "licensed" by that organization to...
  14. GPGeorge

    Solved How to migrate MS Access forms or recreating forms to the web based forms

    Hybrid apps, with multiple interface formats, are totally viable. They do require careful thought about the strengths and weaknesses of each environment.
  15. GPGeorge

    Solved How to migrate MS Access forms or recreating forms to the web based forms

    One option is indeed a browser-based interface, which is quite doable with an AI assistant even if you have little to no experience. Another is to use Microsoft PowerApps to create the mobile interface. One advantage is that the same app runs on virtually any device, even the Windows desktop...
  16. GPGeorge

    Using AI to speed up development

    Using Claude Code, I created a very basic MCP server to interact with a database and pull out specific, pre-defined data that can be emailed to another person requesting that data. I did it as a proof of concept. Maybe 2 hours of interacting with Claude Code to accomplish that starting from 0...
  17. GPGeorge

    Using AI to speed up development

    Sounds great in theory. In practice, are you saying that the MCP directly modifies the accdb itself?
  18. GPGeorge

    Using AI to speed up development

    Perhaps it would help to have a brief summary of the concept of an MCP and what it does. Thanks.
  19. GPGeorge

    Update a column in table

    I don't think you can count on universal uniqueness among place names, even within a region. It's probably more or less true in general, but building a solution around that assumption is subject to clashes with reality. Like most database design decisions, I'd come down on the side of requiring...
  20. GPGeorge

    Update a column in table

    There is a small town in western Wyoming/eastern Idaho which is in two counties and two states. Main Street is right on the state line. Going north in Wyoming you pass cars going south in Idaho, assuming someone else actually happens to be out dragging main at the same time. The name of the town...
Back
Top Bottom