Search results

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...

I decided to try a few things, just to play around. I tried deleting the OverUnder field from the form entirely, because I was going to then try to recreate it. I removed it, but decided not to recreate it yet. Instead, I closed the form (and saved it) and reopened it. I got this prompt...

I just opened an earlier version of the db, when the sorting was working properly. Even in that one, the function was tied to OverUnder (back when the field was called "Over/Under"). So it seems the sorting should be able to work with that function in there.

Ah. Unforunately that will not always work, because sometimes there will be text in the PointsNeeded field. So I built the function to deal with those occasions. (The function would also deal with if Points was Null, though I'm not sure if it would be required.)

It does seem to work! I am at a total loss. I tried entering the code you mentioned, and it had no effect. But you put it in and it works. Did you do something else? Otherwise, I am completely baffled why the code works when you put it in but not when I did. Also, in the earlier version of...

Something I have realized since I wrote the original post is, I think I am wrong about the Record Source of the form. It appears to be its own query. I am not really sure how to tell, to be honest. Here is the SQL of that query: SELECT SignInSheets.Points, SignInSheets.OverUnder...