Recent content by mcomp72

My continuous form doesn't allow new records to be created. So I don't think there is a worry of an empty record being saved. Unless I am not properly understanding what you mean. If you go to :17 of the video I posted in the first post, you'll see the form. The only way the user can create...

When they click that checkbox, it will trigger some code to make a change to another YES/NO field on the Member table called "CurrentOnDues". If they have checked the "Board Member" checkbox, "CurrentOnDues" should change to True. If they have unchecked the "Board Member" check box, it should...

I did some digging around the internet and found the code. If I put the below code in the AfterUpdate sub, it solves the issue. If Me.Dirty Then Me.Dirty = False Thank you for the help!

Ah... yes, that was it. When I clicked into another record on the form, that fixed it. Is there a way to have Access update the record immediately after the user clicks into a checkbox? I am guessing I could put some VBA code into the AfterUpdate sub, but I'm not sure what code I would put in.

I have a continuous form, but when I make a change to it, it doesn't update the table that is tied to it. I decided it was easiest to make a video showing what was happening. I'm new to Access & databases, so I'm guessing the fix is something really basic that I don't know about yet.

@Pat Hartman - ahhhh, that is very good to know. Thank you. @MajP - that worked! I implemented it and now it is sorting correctly. Many thanks!! :cool:

The way I would like it to sort when clicking that text label is this order: 1. Numbers, highest to lowest 2. Non-numbers (doesn't matter the order) 3. Null or empty string (doesn't matter the order)

Yes, when the user changes what is in the Date combo box, I want the form to be sorted by Last Name. After that, they can choose to click the Over/Under text label to sort by that column. When I do that in my testing, it is not always sorting that column correctly. It does a sort, but I don't...

Sorry, but I don't understand the question. Can you rephrase?

Sure, here you go.

Thanks, Bob. Unfortunately, your solution won't work for me. You may have missed it in my post, but the UDF will sometimes need to return a string. That is why I have it return a variant. Sometimes the value in the Points Needed column will be a string, and thus a straight math calculation...

Here you go. https://www.dropbox.com/scl/fi/p9or9d3hukjndj8euo8fr/Test-db-WIP-6.accdb?rlkey=76ufs4dw7vvd2b1j5ejohpbf2&dl=0 Open the Sign-in Sheet form. If the date is not already 7/4/23, select that one. Clicking Over/Under should work. Then change the date to 7/27/23. Clicking Over/Under...

I have a continuous form where the user can change what is displayed on it by selecting a date in a combo box in the header area. Then, they can sort the records by clicking a couple of the text labels in the header section. One of the ones they can click is called Over/Under. Here's the code...

Ah... got it. This definitely pointed me in the right direction. It took me a couple of attempts, but I now have the form working the way it should! Many thanks!!! :cool:

Sorry, but I have never done that before, so I don't know how to go about it. Are you talking about making the OverUnder field on the table be of type Calculated, and then somehow tell it to calculate based on the function I wrote? If so, I am not sure how to do that. I know how to set a...