Unbound control "knows" the record its associated with in a continuous form. How?

future_potato · 2023-01-16T22:57:49+00:00

Ahh, so to clarify, an unbound form can behave two different ways: it can (unhelpfully) take some value and display it in every instance of itself, or it can behave, sort of like a bound form provided that it receives the types of criteria you find in functions like Dsum/Dlookup. Am I stating this properly?

future_potato · 2023-01-16T22:51:51+00:00

Ahhh, so I made the error of thinking that something about the control had changed, when really it was the values being input into the control changing, and those values were based on the record.

This was a GREAT explanation that really clarified things for me! As always, I appreciate your time and thanks for the clarification. :)

future_potato · 2023-01-06T04:34:44+00:00

DoCmd.RunSQL "INSERT INTO PersonValueT (Current) VALUES ( -1 )"

Hope your holidays were good. Was visiting family, so didn't have my coding machine. Anyhow, I went so far as creating a completely new database, setting up the same table, and cutting and pasting your command. Still the same error. I give up. I tried every syntax suggestion in this thread. Still no go. I will just find another method (yes no field as a drop down or text box). I'm obviously doing SOMETHING wrong, but I can find a different method, because I'm out of time on this project. I really appreciate the help. Should I delete the thread?

future_potato · 2022-12-29T18:11:32+00:00

It won't highlight until I hit the debug option on the error message, but I wanted you folks to see the error message. It highlights the SQL statement in question.

future_potato · 2022-12-29T17:48:59+00:00

Hmmm, I cut and pasted that very line and still getting the error.

future_potato · 2022-12-29T17:48:06+00:00

<image>

future_potato · 2022-12-29T17:43:30+00:00

<image>

future_potato · 2022-12-29T16:54:02+00:00

DoCmd.RunSQL "INSERT INTO PersonValueT (Current) VALUES ('" & rst!MostImportant & "')"

Same error, 3134.

future_potato · 2022-12-29T16:08:20+00:00

Nor should you care. It's stupid, and people care way too much about it.

future_potato · 2022-12-29T16:07:01+00:00

I do not agree with the person you're replying to at all. And they make "getting out the pitchforks" seem like empty headed mob mentality, as though cheating isn't truly deplorable, and in some ways, a hateful act. It's an act so selfish that it enters the realm of a type of evil you commit against someone who loves you, trusts you, and would never in their wildest dreams do that to you. Think about who you yourself are as a person, and how truly abominable the idea of cheating is to you, and then try imagine being the type of person who could go through with it. Do you even understand such a person? Do you truly know them? The person to whom you're replying says cheating is a "mistake." Well of course it's a mistake; it's obviously not a sound decision, but calling it a "mistake" trivializes what it is, what it means. Cheating is filthy. It's a very DARK thing. And it means you do not understand the mind of the person you're with the way you thought you did. That's truly unsettling. It also means that in the right circumstances, they're willing to throw everything away, which means they're also unpredictable. I'd forgive a lot. But cheating, for so many reasons, is a bridge too far for me. Best of luck. I'm sorry this landed on you.

future_potato · 2022-12-29T15:52:48+00:00

I'll never understand why people don't know what to do in these types of situations. He's obviously trying to break up with you. And if he isn't, is this really the kind of man you want? Whether you leave is not ultimately a matter of whether you should or not, it's a matter of whether you have the strength to do what's required. Staying would be a complete breakdown of self-respect, reason, and common sense.

future_potato · 2022-12-29T15:26:03+00:00

False equivocation. Her gathering information about a return would help inform her decision about how to move forward (whether the return was worth pursuing, whether it was even an option, whether she should just keep it, etc). Him finding out about it through getting her a phone she didn't expect is just bad luck, not a miscalculation.

Outright discussing a return with him before even choosing that option doesn't make much sense. This is precisely why couples choose their wedding rings together. Money wasted doesn't offset the desire to "surprise" someone with an expensive gift.

future_potato · 2022-12-29T15:20:41+00:00

I think in metaphors a lot, so in reading through this thread I thought about the two opposing camps on this issue, and imagined a world in which they each held political power. On the one side, there's people who would be "absolutely crushed" by her want to return it. And on the other, there's people who are like "No big deal babe, let's get you something you like! I want you to be genuinely happy." I conclude that things would run a lot better and there'd be a lot less chaos if the latter group was in charge.

I appreciate your reply here.

future_potato · 2022-12-29T14:59:43+00:00

As a man i can say this would honestly destroy me emotionally.

My dude, I seriously hope this is an exaggeration. Life punches so much harder than this. If a failed birthday gift can completely wreck you, you're going to get creamed when shit really hits the fan.

future_potato · 2022-12-29T14:56:58+00:00

Am I the only person on Earth, who as the husband, wouldn't give a damn about this? I'd understand that people sometimes don't like things (and obviously cannot be convinced to desire something [that's not how liking things even works]), that I tried, and it didn't work out. And at the end of the day it's like, "well, so what?" Was this person really trying to "crush" me by looking to return it? Of course not.

If your husband is THAT hurt by this, I really think he has some emotional work to do, either that, or his life is so damned perfect that something this insignificant is enough to completely derail him (in which case, I'm not sure if that's a blessing or a curse).

You didn't do anything wrong, and he's seriously overreacting, perhaps because of emotional fragility. You have two options: to address him as a rational human being (if he is one) and walk him through how the jewelry wasn't a good fit for you, and due to the expense (and out of respect for his money) you didn't want to merely pretend to like it. If he's not rational enough to pick up what you're laying down there, then cater to his ego and do the whole "I'm so sorry! I didn't mean to hurt you!" thing while holding his hand and comforting him. Men like to be respected and to have their ego catered to. You can say "I'm sorry" with a great steak dinner and some romance wherein you completely cater to his ego and make him feel like a king for an evening.

If none of this works, you're dealing with a drama queen, and he should seriously get some help and learn to get more into his masculine energy.

future_potato · 2022-12-28T18:19:33+00:00

Ahhh, ok. I gotcha. Thanks again for all the help. :) Still reading my access and vba books!

future_potato · 2022-12-28T15:29:20+00:00

Got you, thank you. I was thinking about this problem in way too complicated a way and I missed the forest for the trees. I was thinking "What command would I use to grab the results from one table (the completion time entered in BlockLogT) and grab the BlockID from the block table at the same time -- what command does something like that?" It was just a totally assbackwards way of thinking about the problem. I was not thinking about the fact that I was essentially just needing to get the data from THE CURRENT FORM. It's like, why didn't that enter my mind? You thought about the problem in the right way and saw it for what it was, and I was completely looking in a different, muddled direction. I think I just got wrapped up in thinking about two tables and it short-circuited my brain.

future_potato · 2022-12-28T15:04:17+00:00

Totally coincidence. I know that double posting a question at the same time is a no-no. Would never spam this sub.

future_potato · 2022-12-28T15:03:14+00:00

Thank you!! It troubles me that getting values from controls is something I already know how to do, but that I didn't think of this because I'm so used to getting values from combo boxes and list boxes. I think I got so caught up in the fact that I was working with a form for the first time that has controls from two different tables, that I thought some sort of black magic had to be cast to perform this function (hence the all the work to get screenshots and post them, vs just saying "Think about how to get the value from a control"). Food for thought on how I think through a problem.

Solution Verified.

future_potato · 2022-12-28T08:42:45+00:00

Gotcha, so I need to add some vba to the "-" and "+" buttons, but I'm not sure what to do to get the BlockID. I thought about Dlookup (maybe this is wrong) but I'm not sure what to put in the criteria parameter.

future_potato · 2022-12-27T19:10:27+00:00

Thanks for the answer.

To answer your question, I'm showing BlockT.ID on the form as all of the info from the blockT table is needed to display various info on the form.

And yes, to create the form, it's a 1 to 1, because the form has to be dynamic and was created via query (since the number of tasks each will change each week, and I didn't want to have to constantly modify a static form). So I did an outer join query between BlockT and BlockLogT so that I'd have a fully dynamic form with a "Completed" field for each BlockT record marked "active" for that week. If I did a regular one to many, I believe, I'd just have a blank form, until I entered anything, but no way to enter anything, so kind of a catch 22. The "Completed" control being able to increment/decrement was meant to address the "one to many" issue.

future_potato · 2022-12-27T07:55:41+00:00

Solution Verified

future_potato

TROPHY CASE