Recent content by Pat Hartman

Don't know where that number came from Colin. I didn't review the file in detail. It was dated 2011 and so has been around for a while --- I did mention SPECIFICALLY that the OP would need to change the Access version to whatever he was using. Thanks for the heads up though.

The Original Equipment models cost at least four times as much as one you can purchase on line or from Best Buy and have installed yourself.

According to CBS, that is incorrect. They did not turn down a jury trial. They were not given the option. The judge told them he would turn down the request. https://www.cbsnews.com/news/trump-trial-no-jury-fraud-new-york-judge-arthur-engoron/ Now we're waiting for the conviction to be...

I have a good friend who has worked as an import broker for batteries (mostly) from China for at least 40 years. He has a gazillion frequent flyer miles. He has branched out and now has a factory making other stuff using Chinese components here in the US so now, he is importing for himself and...

That would be the clear answer;)

It seems that I cannot explain it so you understand the problem.

I explained how to do it. I just found a very old example. You will need to update it for your version of Access. You need to set this one to allow a network location: [HKEY_CURRENT_USER\Software\Microsoft\Office\17.0\Access\Security\Trusted Locations] "AllowNetworkLocations"=dword:00000001...

It isn't necessarily that the relationship is "wrong", it is that there is already data in the table that violates the relationship.

All bad data must be removed before RI can be enforced.

That isn't true. list boxes can go on main forms also but they are not bound when they are multi-select

I agree but usually the bad module doesn't affect other parts of the application as it can with Access. Having source control is excellent, especially when working with a team. Since I generally work alone, I am religious about backups and I use export to text to prevent backing up corrupted...

I do that for neatness and also just in case the user has a full version of Access installed. If you open the .accde with full Access, you get to the Nav pain and you can change, tables, queries, and macros. The only things you cannot change are forms, reports, and modules. So the extra step...

If you tell me what you want for a result, I can choose my population to give you your "answer". Don't believe any statistics unless you totally understand the data they were based on.

That's just the wizard. Once the query is created, you can add other columns.

That is true for ALL queries that take arguments, not just Crosstab queries.