Search results

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.

For starters, could you post a sample database illustrating the technique? Start with something simple. Show us how it works to get a conversation started. Thank you.

I'm sorry to hear you have trouble installing the AccessDiff 15 day trial. I've had the product installed since around 2007 and found it very useful for comparing versions of mdbs and accdbs for clients whose applications I worked on. On my computer, the latest version I have is the 2013...

Doxxing is a term for the practice of publishing personal documents about someone in order to cause harm in some way. It's used by political activists a lot, for example.

I'm sure someone with deeper mathematical knowledge will be along soon. I'll just reiterate that running both versions on a representative data sample, and comparing the resultsets could be helpful. Create both functions in SQL Server, with names that clarify how rounding is applied. I think...

It depends a lot on how precise your calculations need to be. I'm no mathematician, but I do know that rounding your inputs prior to operating on them mathmatically is going to yield different results than rounding the output at the end. I'd try it out on a good sample of your existing data...

Along those same lines, I recall an installation at a client site where the "network guy" had actually draped the Cat5 network cables over the top of a fluorescent light fixture instead of going to the bother of putting it above the ceiling tiles. When the lights were turned on or off in that...

Now that "email address" sounds a lot like someone we have all known for a long time, doesn't it?