Search results

Thursday, March 5th, 2025 6:30PM (Pacific, UTC - 8) I am not doing much Access work these days. Instead, I'm using Claude in the Cloud and Claude Code to work on other projects that interest me. It occurred to me a couple of days ago that because I have both versions of Claude readily...

Sorry I missed this one. Looking forward to the video.

Please re-read the various comments in this thread regarding the ill-advised use of "Last" in queries. Because it is unreliable, the alternatives, based on Max() or Min() values are almost always the safer method than "last", however, you choose to define it.

Post a request as a comment on the YouTube video. I'm not sure what his position would be.

Check here for the setting David called out:

While I agree with Colin that sample data and the actual SQL from the query can be highly useful context from which a proposal can be derived, others have pointed out the real culprit in this scenario, trying to use Last in a query. I won't belabor the point made so well by others. Use a sort...

What's the principle use case here?

The gotcha with that plan is that sooner or later, someone is going to either forget that they are supposed to copy the FE from OneDrive to their own computer, or decide it's too much hassle. And then the cycle of problems begins.

In most scenarios, I believe the preferred location is a folder on the computer used by the user. A copy of the FE should be copied to those folders for each individual user.

It's dangerous to try to run Access databases from OneDrive, or any other similar location such as DropDox. Others have written extensively of the reasons for this warning, so I won't repeat it again. I urge you to search out guidance on avoiding OneDrive with Access databases. One good starting...

Maybe it's echoing a script?

I apologize. My inarticulate statement about "the last AutoNumber" poured fuel on a fire that has smoldered for years and occasional flares up. What I wanted to express was the possibility that the most recently added record in a table may, or may not, represent the "last" record in a queue of...

Are we also potentially running afoul of the mistaken assumption that "the most recently added member " will always be the one with the highest value in an AutoNumber field? There are two aspects to understanding that question. First, it is true that Access will, by design, assign the next...

That's why, in similar databases, I implement a many-to-many relationship on Books and Genres, Movies and Genres, Music (tracks) and Genres. Let everyone have their preference.

Agreed. This line suggests something other than a real "porting" of an application. "The m-Power Development Platform brings your Access databases to the web using a simple and secure method. m-Power easily converts them into database tables, and then lets you build any type of application over...

Unless there are differences between the media for an album and for each of the songs it contains, there is no need to duplicate the data. I'm being a little facetious, actually. The media is the same, so even though you want to look at the media on a song-by-song basis, you only have to look at...

Depending on your environment, writing down passwords isn't the end of the world. Nobody comes into my home office except my 3 year old granddaughter looking for scissors and paper and pencils. I have maybe 3 years before I have to worry about her stealing my passwords, I hope. She, could, on...

This is highly indicative of the problem of a lack of a persistent connection when multiple users are connecting to a back end on the network. Albert, for one, has already explained this extensively.

"The key word here is ‘format’. SQL uses the underlying value ( what it is) not the formatted value (what you see), which is why you should never format fields at the table level." I know. My bias is showing.

There is a basic example of invoicing in the Northwind Developers Edition template. Consult it for ideas on creating invoices. https://support.microsoft.com/en-us/office/featured-access-templates-e14f25e4-78b6-41de-8278-1afcfc91a9cb As a general rule, one does not need to store totals as...