Search results

Two things leap out at me. "I am trying to make it as difficult as possible to use my Access FE at a reasonable price." I think that is a typo or misstatment, is it not? Do you REALLY want to make using your application difficult? "...running SSMS locally using SQL Server 25." No, your...

Ha. Garbage in, Garbage out. Asking AI to rank HI is bound to be ridiculous.

I settled on Claude months ago, but primarily because I was more comfortable with its typical manner of interacting. ("...Claude does not do the smarmy false encouragement cr#p that Chat does.") I've heard others say recently, though, that Claude, and especially Claude Code, works much better...

Is there a specific error message regarding being blocked? If so, please share it.

I'm pretty sure you have the diagnosis right here: It looks like Azure SQL has spun down and there is a pause while it spins up. Once connected, re-connecting works flawlessly, but symptoms occur again if there is no activity against the database and the user tries to log in again after closing...

Here's the logout code for my site. It calls two helper functions that pertain to page load delays. The rest is pretty obvious, I think. ' ============================================================================ ' LogoutSite - Navigate back to login page to end the session '...

Thanks. I am mostly interested in figuring out where and when using an AI assistant or an AI buddy can speed things up. Case in point was a recent decision to replace an IE web browser control in an Access form with an Edge web browser control. I had no idea how to create the javascript to...

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