Search results

Don't. OOP is out of favor. It didn't produce the expected results. There are better methods. That is evidence of a poorly normalized schema. If the reminder date is always a fixed period prior to the due date, then you calculate the reminder date in your query, you don't store it. If the...

Don't confuse the "storing a calculated value" with the "running an update query" parts. The OP said the calculated value wasn't being updated. Apparently he meant on the form. OK. Fine, cancel the unneeded lecture on normalization. That doesn't cancel the solution because poking the...

And yet Trump, in his first term, issued an EO that gave very ill patients the "right to try" unapproved treatments. Too bad Congress won't make this into law. Also, keep in mind that freezing payments is NOT the same as cancelling them. The only way to stop the money from being wasted on...

A society develops "norms". People speak a certain way. They dress a certain way. They act a certain way. Doesn't mean that we are all robots but in public, we accept that there are things that are just not done. For example, it is only in a gay rights parade where you will see nearly...

The initial fetch brings down enough data to fill the form, the rest is fetched in the background, x rows at a time. It is possible that this wasteful behavior was altered in more recent versions of Access. Select a large number of rows, wait for the Y value to fill in in the navigation bar...

Are we talking about the same program? You know, the one that tripled your out of pocket cost for insurance?

That has nothing to do with the price of tea in China. Therefore, it must be the latest form of virtue signaling. In my state, it disenfranchises you so I would NEVER register as an independent since it would keep me from voting in any primary given that to vote in a primary, you MUST declare...

You have code behind the form that is causing the problem. Use the debugger to step through the code so you can see where it is happening.

That is not a valid question. You need to distinguish between multi-select, which creates an array and so you use .itemselected and single select, which does not create an array and so you can reference the ControlSource directly either as Me.MyList or Me.MyList.Value In Access VBA, the .Value...

The others have loaded your gun and shown you how to do this the wrong way. The total price should not be stored. It is a simple calculation and both component parts are stored in the same record. Storing it is a violation of Second Normal Form. Please do some reading on database...

They can't. The government calls any after market "fix" a recall no matter how trivial or non-dangerous.

A cure provides 1 payday but treating the symptoms is a gift that keeps on giving. Also, keep in mind that Americans pay the highest drug prices of any other country in the world despite how much money we give the drug companies for R&D. Someone needs to fix this. Maybe if we provide 50% of...

#6 but if your BE is SQ!L Server, then you can use the technique of creating a filter but instead create a where clause for your query. Then update the Recordsource with the changed query.

You do it with two subforms to avoid the issue and the list subform is not updateable. The MS version handles this behind the scenes to avoid conflict probably by making the mainform unbound so there is only one recordset open. This implementation isn't using the list subform to filter the...

Your original problem seems to not be repeatable but there is a lot of work needed to fix the schema as well as the forms. In addition to and to emphasize earlier comments. 1. NO main form should EVER be bound to the same table as one of its subforms. 2. Search fields should NEVER be bound...

You seem to be a legend in your own mind. Just because you work for companies that employ slaves illegal aliens, doesn't make you smart. It makes your employers criminals.

I have to admit, the NGO scam never occurred to me.

And this is a problem, why? I actually think a lot of their proposals are what the government needs to get back to being "for the people". Currently, "of the people" is the only part that is true. "By the people" hasn't been true since politics became a career path and a college major and...

As Doc said, a pause is not a cut and yet the crazed media/Dems will always report a pause as if it were a permanent cut because that scares people and gets them upset for no reason. The media needs to create chaos and blame it on Trump. The Dems need people to ask your initial question? So...

Domain functions should always be your last option. If you are building a graph, the wizard should give you filtering and summarization options.