Search results

:unsure: 😉 (y) And hence my question.

Probably, but in the real world "Startup"<>"Default". Sorry, but ambiguity always sets my teeth on edge. Maybe today is just the right day to let it out.

What do you mean by "default form"?

How about a supporting screenshot showing us the tables involved and the fields involved.

RIP Jack. A true Gentleman and wise friend.

GP George: That link doesn't work for me - HTTP 404.0 not found. Wow. I don't know how that folder got deleted. Thanks for the heads up. I'm rebuilding it now, but it will take a few minutes

I give up. Best of luck in the venture.

I have a sample database which illustrates the concept Duane described. https://www.gpcdata.com/Downloads/MainFormFilterSubform.ZIP

As I've stated ad naseum. SSMS -- SQL Server MANAGEMENT Studio -- is used by developers and DBAs to Create, alter and delete databases in SQL Server instances or in SQL Azure Create, alter and delete tables in databases in SQL Server Create, alter and delete views in databases in SQL Server...

Much clearer and more precise than my long-winded offerings. Thank you.

No, I do not envision someone who purchases a license to use an Access/SQL Azure database application needing to be a DBA to use it. That is precisely the point of purchasing a licensed product from you. They do not need, or want, to be a DBA and trouble-shooter. They are paying you for that as...

SSMS is required ONLY for YOU, the developer, who creates and manages the databases, and for any DBAs maintaining the SQL Server database on behalf of the user. SSMS is NOT required by users who will license your Access application for their use. In fact, you should hope that your end users do...

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