Search results

Trump is doing everything he promised to do on the campaign trail and actually succeeding with lots of it. This is so unusual for a politician that some people simply can't get their heads around it. The normal modus operandi for politicians is to promise whatever will garner votes but then do...

I'm happy that anyone who is that stupid is fleeing the country. It is a huge disappointment that all those people who threatened to leave the country if Trump won haven't left yet. It increases the average IQ of the remaining population. Encouraging the Senate to vote to pull tariffs is...

Here's some code from a database I built to document databases. I took the code out of context so I hope nothing is missing. The app needs references to the current db which is called ThisDB and the database being documented is referenced as simply db. The argument "vSourceDBID" is used...

Apparently time moves slowly in the OP's world. Did anything I said make sense? It's not easy guessing what your app is trying to do and what the table schema is.

I think it is one monolithic database shared among multiple users.

@The_Doc_Man Colin and I are done. He apologized. In private of course.

He's jerking your chain. It would take an amendment to allow Trump to serve a third term. Too much TDS for that to ever happen. Plus, Trump is rapidly aging. He'll probably still be going strong in his 80's unlike the members of the Senate who can't remember their names and should have been...

I've never tried it in the grocery store. I rarely have more than a couple of items when I use self checkout. I was thinking about big box stores where I generally have a bunch of things.

No. The db is monolithic. The tables are currently embedded so the single database is what is shared.

But THAT is what the function does! Functions are not all things to all people. You can't use functionA to perform actionB. functionA does something unique. They perform specific actions and if those actions reference specific form fields, THAT IS WHAT THE CODE DOES. The lock/unlock...

Make as many discrete fields as you need. Typically, I use: Prefix (Mr, Dr, Mrs, etc) FName MName LName Suffix (Jr, Sr, Exq, etc) This gives you all the flexibility you need to make nicely addressed snail mail and letters as well as providing sorting ability.

@Shimon You need to add PKs to all the tables. If there is a natural key, you can use that. Otherwise add an autonumber. Do NOT add autonumbers to tables that have existing natural keys. At this point, adding relationships will require you to fix up all the bad data and I can assure you that...

Occasionally, when building a database for myself, I violate rules like this one and I am ALWAYS sorry. It is no more difficult to separate the name parts than it is to mush them together and once you mush them together, separating the components is a bitch and will always result in data...

I always use autonumbers as PK's so Cascade Update has no meaning because of the way Combo and List boxes work. If I have a multi-field unique identifier (more frequent with junction tables), I never want to create a compound PK so I create a multi-field unique index and an autonumber as the PK...

I think you need to change your handle to "MrKnowItAll" because you can never raise specific objections. You simply dismiss out of hand anything I say. You agreed with Colin's misogyny rant. I'll give you the benefit of the doubt and apologize because you honestly thought he didn't actually...

Don't get me started on this one. It is infuriating that the bagging area won't let me add my bag so I can bag directly. I have to scan the item. put it on the scale and later take the items and bag them. Extra bending and lifting.

Hi, I include export to text code in most of my apps as a way to create backups. I discovered long ago, when a database corrupted that the backups were usually useless also. So, I create two kinds of backups for my FE's. One makes a full file copy and the other exports all objects as separate...

I devote a lot of time to helping people learn how to use Access. Sometimes I have helpful examples I can post to illustrate concepts. Sometimes I can write snippets of code. But, when you're intent on creating a non-normalized solution which I would never do, I can only offer high level...

That means that the users don't have delete permission to the folder holding the file being opened. If this is happening to the FE, then you are not distributing the application correctly. Each user MUST have his own physical copy of the FE. The FE is NEVER shared. Only the BE is shared...

Creating dozens of lookup tables is a lot of work and creates a maintenance burden unless you create forms to manage each separate lookup table. I use a mini-app that gets added to all new applications to avoid the issues. The lookups are essentially used to populate the RowSource for combos...