Search results

As Gasman says, you need a report that formats the work order exactly as you want to send it to the contractor. It can be similar to the appearance of the form, but will probably be quite different -- based on your description of the problem. For the report, create a query with a WHERE clause...

This would be a good question for ChatGPT, would it not? 😉

Okay. In both M365 Access 32 bit and 64 bit, the local html pages load without the leading = in the controlsource, so I wondered if that was a factor in your problem. Regarding the code, have you inserted a break point and walked it to see if that shows you something useful in diagnosing the...

Please show us the code that doesn't work, then. It sounds like you are setting the control source at runtime.

Please join us for our Monthly Chapter Presentation November 6, 2025, at 6:30PM Pacific (UTC -8) With an assist from my team of personal assistants, Claude and Chatty, I created a three step process to add lightweight auditing to an Access database application. It’s built on Data Macros to...

You have hit the nail on the head.

Are we talking accdb back end?

1. I personally wouldn't miss the Politics or Water Cooler Forums. I have them on "Ignore" now anyway. Simple, clean, effective, by the way, for those who keep whinging about them. It's all about exercising your freedom to choose. Shutting them down would reduce the risk to the site itself...

That's the one I mentioned.

This is true. I read an article a day or two ago. Ofcom are trying to control content on a US owned, US hosted site. I would use a different word than "control", but under the current climate, that might trigger another action. Unbelievably, the UK Ofcom thinks that because someone in the UK...

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.