Search results

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

This is indeed a potential problem and one I've encountered recently. The solution is to NOT continue uninterrupted coding over an extensive period without regular, frequent saves. If you are actually working many hours between saves, maybe a different approach would be in order. Start...

One of the basic ideas in table design is that each field in a table is an attribute of the entity which is the subject of that table. Looking only at tblEmployeeList we need to clarify what is, and what isn't an attribute of an Employee, i.e. a person who works for your organization. Several...