Search results

I predict democrats will oppose anything the president does now that we have one that actually gets things done. The former president is in the past now and his legacy will become one of the most corrupt in our history. He will be remembered for open borders and baggies of cocaine in the White...

Pretty sure the full path has to be used. So that would normally be "C:\Users\[USER_NAME]\Documents\Backups" If you use OneDrive on Win11, then it would be: "C:\Users\[USER_NAME]\OneDrive\Documents\Backups"

What do you mean "put the unit price in the inventory item"? If you copied it there, of course it won't change. Your price table should always show the current unit price and your invoices should always show the price at the time of the sale (copied).

Except for what democrats do behind closed doors.

Well those are just rules programmed in by humans. Self preservation doesn't emerge, it's simply programmed in. The programmer can't think of every possible scenario either. There are just too many possibilities. It is way more complicated for a programmed set of rules to prevent a human from...

That's not really possible no matter how much knowledge is contained in the AI model. It has no real enforceable interface with the world that it can itself control at all. It only responds to prompts or does what it is told to do by humans. It doesn't make decisions that are not already pre...

OP must have gone golfing for the day. As long as the form is a bound form, the solutions provided should work. Will just have to wait for a response.

You made clear both field types are Short Text field types. If that is true, then the where clause part of dlookup must be enclosed in single quotes. My guess is you are not using a variable in the where clause as shown below. Please confirm yes/no. In post #1, you said this works and that's...

Sounds like a table structure problem to me. All the languages should be stacked vertically, not accross in columns. I would assign each language a simple number based on another lookup table. Then in your languageTable, the structure would be ID, control name, controlType, caption, LangID...

Yes, and since it works for you, then there isn't anything you need help with. You got it all figured out.

I'm a horse according to the zodiac, my wife is Japanese and she is a dragon.

You got the table and field reversed. I don't think this is a PK. =DMax("RecordNum","tblDemoTrans")+1

I should have said position of the sun. But I'm pretty sure that's the most basic clock there is (looking up at the sun). Notice, in darkness there is no reference like there is in the day. This is what drove us to make such things as mechanical and eventually digital clocks. I do understand how...

It's time to get rid of the bad laws and make some common sense laws that benefit the people, and not politicians or political activists. If you work for the federal government and provide a needed service, good for you, but there is no law that says the government must employ you forever. If...

@KitaYama You forgot one. There is the simple counting of days thanks to the sun. Kind of like the North Korean people have to do. It would be really hard to tell time without light or movement of the planets and stars.

Watches might make a comeback in all the schools that are banning the use of cell phones during school hours. Ain't it great? Invest in watches and learning Access. I'm glad I jumped onto the Access learning train yeas ago, but I would still learn it all over again if I had to.

Knowing how you approach this exact issue Pat is very helpful. Thank you.

That makes sense Pat. I just never seen the code for this logic before. The thought of using a flag like variable crossed my mind, but I just wanted to see what my options were.

That's what I was looking for @MajP. I see that checking for all the validations in a separate function and only if everything passes, then close the form. I think Josef P.'s idea would work as well.

No, that's not what I'm looking for as I am aware of that solution. I will have many more complicated validations to contend with.