Search results

The GPS/sound system for my car goes for $4,000 installed by the dealer. A similar after market solution is closer to $500. It's like those cost accounting systems we were talking about in a different thread where the hospital tries to bill you $5,000 or each CatScan when the local imaging...

Reports are easily bound to Crosstabs. Any method that requires that the programmer know a list of values ahead of time and create separate counts for hardcoded values is a bad method and should be discouraged. It isn't a matter of whether there are 5 variations of potential values or 5,000...

It is collusion because they ban together to discredit/cancel everyone who disagrees with them. That isn't how the scientific method is supposed to work. We should always be willing to challenge our assumptions as new facts come into play. Ask yourself, did anyone ever apologize for scaring...

TVs didn't used to have the resolution that purpose built monitors do. TVs are getting better but why pay for a tuner and all the other "smart" crap when a monitor will be much cheaper. Using an all-in-one means you get mediocre performance rather than excellence where you need it. If you're...

The normal reason this happens is because you are using a bound form and you dirtied the form so that forced Access to save the record you dirtied and the record you inserted. This is really poor design. The solution is always - VALIDATION. Add your validation code to the form's BeforeUpdate...

You didn't provide a link so I did a google search. The document I got was all about the VA even though it had a generic title.

There are only four decision points in my sample - BeforeUpudate, BeforeInsert, Current, BeforeDeleteConfirm. If you want to control functionality within a form so that user A can update fields a,b,c and user B can update b,f,d - that is WAY more complicated and not at all what I suggested...

Not when you consider how they misused their clearance. I wouldn't have banned them from government buildings though. That was petulant. Security clearance is not an entitlement. It should be revoked immediately if you violate the trust of the people and lying about the President's actions...

You're welcome. Glad to help.

That is a unique attitude for a non-professional. Most novices are reluctant to ever get rid of code they've written whether it does what they want or not;)

That is the least efficient method. PLUS, it GUARANTEES program maintenance will be required if some value in that column changes. The list method displayed in subform is the least likely method to require future maintenance. Even the Crosstab is likely to require form maintenance if the...

Trump was repeating what Congress told him they would do. McCain f***** us. That is quite different from Obama's lies about the ACA. He knew for a fact because the GAO told him that no one could be guaranteed to keep his doctor since all the plans would be reissued AND they also told Obama...

You needed to work this out a long time ago and you should have already been testing in this environment even if you were the only tester. One-drive or other cloud file system is a non-starter. Access CANNOT work in this environment PERIOD. As the others have said, you can do unit testing...

The government ITSELF, before DOGE got on the case said the fraud was far more than that. I think the number was ~72 billion. Except that international law says that asylum seekers must claim asylum in the first safe country. They don't get to break into your house and tell you that YOU have...

If you're thinking of doing x queries, one for each value in the field, don't. Use a totals query if you can live with the results returned as one per row. Or use a crosstab if you want one row returned with x columns.

Always strive to build a query to solve your problem and only use a VBA loop as a last resort.

When you have no idea what you want, you make a lot of false starts and that means rework. If you are willing to toss something you spent 3 days building because you had a better idea, then your plan will be fine. But, if you get attached to things you built which don't support your goal, you...

Nothing there regarding procedures to fire someone.

Makes sense if you need history. Overkill if you don't.

Is this one of those polls where they poll only people with TDS so they get the answer they're looking for;)