Search results

T I have a similar, even more egregious story regarding common names and birthdates. My wife took my pre-teen daughter to our doctor for a routine checkup. The doctor began asking my daughter questions that were obviously inappropriate for her age. My wife objected immediately. It turned out...

I think you might be able to accomplish this by binding the main form to a query that has 3 fields for the shifts. You can hide the fields, but use them as the "Link Master Fields" values. That should filter the subreports accordingly. Not tried, but seems to be possible.

Although Colin's tool should give you the answer you are looking for, the question remains the one Dave asked, "Why does this matter?" I would add, what problem will you solve by identifying the size of each table in an accdb, whether it's a back end or a front end? If the concern, for example...

Sorry, sometimes I can be too subtle. I was implying that the market for broad searches is pretty well saturated by the big players in search, e.g. Google, and by the AI LLMs, e.g. ChatGPT. A site like this one trying to transition into a "Me Too" site is not a guarantee of relevance. With...

Like, oh, say, Google.com and ChatGPT? :unsure:

I cast a suspicious eye on Chatty and Claude and their LLM siblings.

Some people see a glass and say, "It's half-full." Some people see a glass and say, "It's half-empty." Some people see a glass and say, "Microsoft stole half my water."

We can tie ourselves into knots trying to finesse a malformed field. This is a good example of that. Several ways to deal with the posted question, but all of them subject to further modification as circumstances, and the data you need to store, change. The underlying problem is, as Plog...

Another argument for starting with Access, learning the principles of good table design, building a properly normalized set of tables, and a rudimentary interface to begin. That will take much less than 6 months, even allowing for plenty of time to learn good table design principles BEFORE you...

Thanks for going into such depth. I think it's a fascinating concept. Worth looking into for anyone who has an idea they want to try to share.

Cool, thanks. Fiction? Non-fiction? Other categories?

You might kick off the conversation by explaining what Amazon's "KDP" program is. I take it that it has something to do with books.

The VBA project can be named anything you want. It defaults to the name of the Access database originally. To change it, you can right-click on it in the VBE and enter the name of your choice. I prefer a modest name, usually.

Sometimes, though, sharing a solution can be of benefit to someone else having a similar problem down the road. That's the reason we often request more than simply, "I fixed it." Thank you.

All of that stuff! Often, when trying to trouble-shoot a specific problem, Claude or Chatty start offering additional components beyond the one I'm working on. And at some point, I get lost in a series of responses, some of which are on topic, some of which are looking down the road. It gets...

This illustrates very well my experience with most AI LLMs. Going in, we assume a certain level of context and tend to think that the LLM will share that context. Sometimes yes, sometimes no. The thing is, LLMs lack contextual experience. To explain the problem as I see it, I resort to...

My first reaction would be a shrug of the shoulders. Unless you are critically short of space on the drive where the SQL Server instance is installed, it should not matter. It's not like Access where we have a hard 2GB file size limit. Even if you are using SQL Server Express, it's not that...

I decided to see what Chatty and Claude, a couple of my AI buddies, have to say about benchmarking performance for various database platforms. I figure they should have access to a lot of that kind of research which I don't have without hours of crawling the web. Unfortunately, it turned out...

In Post # 1 you indicated, "We dumped MS SQL Server for MYSQL as relational database due to speed we have been using this MYSQL databases with MS Access as front end and has proved to be reliable and our users like the speed compared to MS SQL Server which makes the speed horrible even if you do...

The inquiry at hand isn't about the names of tables or fields. The inquiry is about datatypes, e.g. like the one in your error message regarding a multi-value field. So, while you resolved your problem by switching from the wildcard to specifying field names, it's still ambiguous about why...