Search results

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

AI is neither inherently good nor inherently bad. It's a tool. Used wisely, it is beneficial. Used inappropriately, it can lead to problems. Off-hand a few other tools of similar utility come to mind: Fire Motor vehicles Hammers Knives Pharmaceuticals Electrical appliances And you can add...

To me, the big threat is not to isolated professions such as bank clerks or metal workers. AI can be adapted to assist in the work of a huge variety of environments and situations. To use a catchy phrase, "it's everywhere, all the time". People who were bank clerks could find other jobs for...

I am in the process of deploying a library database for a non-profit I support. We adapted the MRU feature from Northwind Developer into it. I'm hoping to start receiving feedback from the user in the next few days. 🤞 It's probably too close to Christmas to expect much yet, though.

I would say you are pretty normal, except more honest than some about openly acknowledging mistakes.

The real problem is that you do not provide any information specific enough to interest others in looking into your techniques. Statements like this are both intriguing and frustrating. "The added value is that the database is almost complete automatically generated, independent of any...

I was able to create and use an append query today, after installing updates from yesterday. My installed version is M365 32 bit and MS365 64 bit (Current Channel) What version do you have installed?

Don't let the 1st impression dissuade you from taking seriously the good advice offered. DLast, DFirst, etc. are seldom useful when looking at historical data. In fact, it's hard to think of a situation where they are viable, although I'm sure there will be one I haven't thought of. The reason...

I've often noticed that creating diagrams in remotely hosted SQL Server or Azure SQL can be slow in SSMS, and not just in the most recent version. However, once a diagram exists, it usually loads noticeably faster. The times you mention do seem longer than I'd expect.