Search results

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

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...

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

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.

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

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...

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...

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

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...

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...

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

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

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...

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...

This one goes back decades, but I had occasion to use it recently and it still worked.

The video is now available on YouTube.

In your original post: "How do we historicize all documents dated before 2025 in the DOCUMENTS table and then physically move them to another database," One or the other is true. Either you do want to "physically move them" or you don't.

Over the years, a number of discussions here have included methods of implementing unique, sequential numbering. https://www.access-programmers.co.uk/forums/search/6036910/?q=unique+sequential+number&t=post&o=relevance

An append query, followed by a delete query, both with appropriate parameters, would do the job. You can retain access to the archived data by linking it to the production database. I am not sure, though, what you mean by "historicize" them. How is that different from moving them to the...

100 fields? Let's step aside from the discussion of layout and ask what kind of process involves up 100 separate fields? If that represents fields in a single table, it throws a red flag up. If it represents fields from different tables, it throws a different red flag. If it represents fields...