Recent content by Pat Hartman

You're welcome. Simple is usually better. Let Access do as much of the work as possible. That is the only rational way to use a RAD (Rapid Application Development) tool like Access.

I too question the way you are doing this but here's a sample of how to create a sequence number, which is what I think you are looking for. https://www.access-programmers.co.uk/forums/threads/custom-sequence-numbers.324147/

I could get behind this idea but I don't like hard coding anything that is changeable. If you upgrade your system or you have to install on multiple PCs with different versions installed, it would be far better to have the GUIDs or file names stored in a table so they can be easily changed...

I came late to this party but rather than have two separate tables, use a single table. That simplifies EVERYTHING else since you have only one table to link every other table to. You can have a flag to indicate whether the entity is an organization or an individual. You can use LastName to...

Deflection as usual. CT is a totally blue state. They are very in favor of illegal immigrants and even of having them vote. That is why you don't need ID to vote. At least they're not stupid enough to be pushing 100% mailin voting. The clerks ask for one and most people show one. It is...

So you actually think that Trump thought that Kemp could fake a recount? OK. You see what you want to see. You hear what you want to hear. The world was a safer place with DJT as President and the fact that Jordan and Saudi Arabia helped to shoot down the missiles and drones that Hezbollah...

They have no shame.

Where is the threat? Where is the coercion? Why do you think that Trump thinks that Governor Kemp can just change the vote count because Trump asked him to? Do you really think that Trump is so stupid that he actually thought that the Governor could just change the vote count???????? Do you...

Why are you not simply using a bound subform? If you want to validate the data and ensure all fields are filled in, use the subform's BeforeUpdate event. Just ask if you don't understand how to ensure all fields are filled and have valid values.

I can tell you don't have an open mind because you only "see" one type of bias. You do not see the lies told to you by the left. You do not see the pressure exerted by the FBI and the WH on the social media companies as a violation of the first amendment rights of Conservatives. Somehow...

Earlier in Access' history, MS set the default for numeric fields to null. Currently it is set to 0. So, make sure for ALL your FK's to remove the 0 so that FK's ALWAYS default to null. When an FK is required, the null will cause an error and not allow the record to be saved when the FK is...

Where (somefield LIKE "*" & Forms!yourform!somefield & "*" OR Forms!yourform!somefield Is Null)

Here is Ron Rubin's podcast from Monday. He comments on several things Bill Maher talked about on Friday. One rather shocking statement was that Bill Maher believes abortion is murder and he's OK with it. At some level, most Americans do believe Abortion is murder. The question is, since...

Illegals Instructed to vote for Biden to keep border open. Illegals Instructed to Vote Biden for Border NGO to 'Stay Open' (dailysignal.com) So, the plan becomes clear. The Dems are losing votes by the droves from their typical "victim" class and the ignorant children so the 2024 plan is to...

But you've only just started. You need to watch a few very basic videos. Crystal (@strive4peace ) has some good beginner videos on her youtube channel. https://www.youtube.com/user/LearnAccessByCrystal Look at the Learning Access section.