Search results

Given the direction this discussion went, I'm going to preface this with a caveat: I assume this is a legitimate effort to gain access to the data. There is an open source tool called DBeaver, which is sort of a universal database management tool. Think SSMS for dozens of databases. It doesn't...

Re: Decompiling fixes random errors. "Stuff happens; it's Microsoft."

The only thing visible in that screenshot is a layout containing three controls. You can apply gridlines to the layout so that the top, bottom, left side or right side of the cells in the layout are visible. It appears that you have set the gridlines for those cells in that layout to solid. If...

Thank you. The three label controls at the top have borders around them. That's controlled in the property sheet in design view. It would appear the lines between records in the detail section are horizontal lines at the bottom of the detail section.

You know what would help me understand the problem? Attach a couple of screenshots showing your reports in Print Preview and Report View so we can see these gridlines (or the lack of them).

Can you share the data so we can try to identify potential problems? Also, the description of the fields leads to the conclusion that there is a problem in the way supervisor codes are defined. We need more detail about that. Also, storing the calculated value is a less than ideal approach and...

When the topic of censorship first popped up recently (and feel free to censor my use of the term censorship to describe what's going on 😉), I predicted what was going to happen. At the first mention of "government" actions we all start looking over our shoulders.

Having looked at the sample provided, it's clear that the problem is more complex than displaying related attachments. It's likely that the sample provided is actually not the same as the real tables in the working database either. "Tbl_A" and "Tbl_B" appear to be pseudo tables created only for...

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.