Recent content by Pat Hartman

Not any more. The form just stays open. Can't close it. Also tried right clicking the form header and choosing close all. The form will not close. The error stops it. You'd think the children would test when they make a change like this.

I don't care that it errors during testing. What I discovered is that THERE IS NOW NO WAY TO CLOSE THE FORM PERIOD!!!!! I don't need a solution. I am reporting an ISSUE. But thank you. This is the entirety of the code in the form's class module. Option Compare Database Option Explicit...

Sorry. I'm on the bleeding edge

That isn't the way I read the question.

No. Now they act the same. The change to forms is recent. They now act like reports. You cannot reference a column from the RecordSource unless it is bound to a control. But again, you don't see the issue immediately. You only see it once Access has rewritten the query and you open the...

This feature/bug has been in Access as far back as A97. It is the same feature/bug that forces you to use the report settings to control the report sorting rather than using the RecordSource query. Access rewrites the query to remove any fields not bound to controls. You don't see it...

If you want to use certain special characters such as the & in a label, you need to double it up. Use && and that will just show the &. Which probably means that you can't make the & underlined as Tom's example shows. This isn't a bug. It is a "feature".

This has been the case since the early days of Access for reports. This stupid "feature" now exists also for forms. In any event, you can do the calc in the query as June suggested OR, you can bind the ResultPromote field to a control in the detail section of the report and make it invisible...

Then that is what you should have said from the beginning. Ask the question you want answered. Don't make me guess. It's pretty easy to identify them. They say they are not proud to be an American. They think that it is better to burn the American flag than to fly it but think that burning...

New bug forces you to use task manager to close Access when you have a form bug. I opened a form directly because I was testing and hadn't yet added it to the login form but that form wasn't open and hidden as it normally would be. When I closed the form I was testing, it tried to return...

What part of "people who hate this country" is unclear? Are you trying to make this into some kind of racist statement?

@bmaccess Instead of hardcoding all those sums. Create a subform based on a simple query that uses NO hard coding. Select ResultPromo, Count(*) AS ResultCount From SomeTable group by ResultPromo order by ResultPromo Also take the advice regarding using arguments instead of hard coding and...

Yes but largely because the parliamentarian took many of the spending cuts out of the bill. Things like removing illegal aliens and other freeloaders from Medicaid.

No. That isn't how forms work. You can make something that looks like the image if you make it a report.

That is certainly a problem and it should never have been approved. It was the Supremes making law again. A worse problem though is the lack of term limits. The Dems make great use of this ruling. NGO's funnel my tax dollars to entities that make multiple donations in the names of people...