Search results

From time to time we hear about legacy apps running on Access 97/2003/2007 etc. The defining characteristics of such apps generally include isolation from integration with other applications and a business model that hasn't changed since dirt was invented. That's fine where it works. Until it...

There are very, very few black and white decisions. I well recall the contretemps surrounding Kaspersky. For a while I used other Anti-virus tools, but eventually, it seemed that Microsoft's Defender became good enough and easy enough and ubiquitous enough to decide maintaining a separate tool...

Good point. 👍

Further to what has been suggested, you need a table called something like "tblLogin". It will need fields like "Login" and "LoginDateTime". In an AuthoExec macro, call a function that captures the UserID of the person starting the application and the date and time of that login. Store that in...

There is a commercial application that is really good at comparing accdb versions. https://kellermansoftware.com/products/accessdiff When I was active as a consultant, taking over "rescue" projects, I found it well worth the cost of a license.

Who better to ask that one of the AI's? This is from Claude. Based on recent research and reporting, here are the key locations where AI data centers are being constructed with significant power and water constraints: Major Constrained Locations Northern Virginia (Loudoun & Fairfax Counties)...

Isn't this thread supposed to be about performance of SQL Server Management Studio version 21 versus SQL Server Management Studio version 22? Why are we even talking about Access in this context?

I think it's a grey area and most such reseller offers probably do skirt the edges of their licensing agreements with Microsoft. On a different, but related topic. I am now party to two different class action lawsuits against AI companies for downloading books from pirated online libraries...

The key is that you will be buying an LTSC licensed copy, with all the rights and restrictions that entails. Specifically, it is my understanding that LTSC licenses are NOT intended to be resold at retail. They are sold to an organization, to be used within that organization...

Muddying the waters ever so slightly. The current plight of technology-centric forums like AWF is clearly related to the use of AI. It's a case where I believe the correlation between increasing availability and usability of AI and decreasing activity at such forums does indicate a high...

Correlation doesn't prove causation. I'm not going to argue whether the increase in number and size of Data Centers in New Jersey has or has not contributed to increases in electricity prices there. It may well be a contributing factor. I am going to suggest that it doesn't necessarily follow...

"For ~£30 it's a steal. Is it?" And why would you think that? 😉 Is it because the full retail is $179.00 (US), or ~ £133? https://www.microsoft.com/en-us/microsoft-365/p/access/CFQ7TTC0PD0B Perhaps, when a deal seems like a steal, it really is just that.

The moral of stories like this is that risk management is a complex calculation between competing priorities and costs. A cost-benefit analysis is appropriate in this context. I'll go down memory lane a bit and try to recollect the major outlines. Basically, one can construct a four quadrant...

In addition to clarifying what you need to Group By, please explain what it means to "clear the filtered Data". Delete it? Remove it from a displayed result? Something else?

I'm partly guessing based on the use of the const in the VBA and the presence of the talley table. I've been wrong before, though.

I think the goal is to create 26 lines on the report per group, regardless of how many records are in each group.

Help us understand the request by specifying the sort order you want to apply.

What you describe as a table with multiple fields that each contain values of the same thing, "dinnertimes" (18:00, 18:15, 18:30, 18:45, etc.), is commonly referred to as "repeating columns" or "spreadsheet design". It's actually a fairly common mistake among newcomers to Access who have...

Actually, we'd be happy with a work in progress that actually allowed others to review and examine the processes. Failing that, as I suggested previously, a narrative description consisting of a step by step of a typical implementation you've deployed to a client. What the process involved, how...

Without specific examples of the behavior, we have no way to comment. Each new version of Access (and all other software, so far as I am aware), introduces new features and can, potentially, alter previously existing behavior. That's expected behavior. In fact, one could argue that it is...