Search results

It all works! Thank you so much! Still stumped on why it decided to stop working all of a sudden...c'est la vie! :-) thanks again!

So since I have "InDirectory" field pulling from the Family table I wanted to try something...I removed the "DeaconID" from the form query source and then replaced the Family ID row source with your SQL above and the error is gone. So my conclusion is that it was having a problem trying to save...

That sounds like a good idea, but the family table does not record the deacon's name, just their number. The Deacon's are in their own table so that I can generate a report for them that will list all the families (and family members) that are assigned to them. **EDIT** Also, I just noticed...

That makes sense. But I did find that it was pulling the Deacon ID from the family table and pulling the Deacon's name from the Deacon table. How do I get this to continue to show with out having those two tables? Thank you so much for your help!

Yes it has been mentioned, but I don't know how to improve it further. It's a huge-giant improvement on the original one I was working on, but now when I'm told I need more work, I'm just directed to the tutorials (which I do appreciate, but it's not getting me that last bit that I'm apparently...

Oh sorry. Little scatter brained today. So when creating a new member (or even updating an old member), if you try to assign a family ID you will receive the error. (Note: you will have to assign a SSClass (on sunday school tab) before you can save the member.) You said to try saving the...

Hello, I have a report that I will print and use as a Sunday School attendance sheet. Currently the roster is generated and filtered based on a tempvars. I was wondering if it's possible (and how) to set the title based on the same tempvars. Ex: TempVars = 1 Title = Steve's Adult One Class...

Here's the db. There are some extra tables & forms because it pops up a warning that they're missing if I don't include them, and just in case one of them is causing the problem. I did leave a family ID in the family table, but there's no special information. Sorry for the late reply. I only...

Has anyone been able to figure this out? I did look around and found some that had the issue, but they said once they removed the attachment field from the form it worked again. I tried that and no such luck. Desperately need this fixed, please!

Yes they are unbound. The member detail form is based mostly on the Members table, but needs the foreign key from the Family table, which requires a foreign key from the Deacon Table. When assigning the family to a new member, I know all the primary keys are created and ready to pass on as a...

Nope, checked the tables, all foreign keys are set to "Number". Thank you for the try!

Hello, I have a member detail form and just starting today, it's been giving me an error (picture attached). I've checked to make sure both tables are assigning a primary key. I don't really know why I'm getting this nor can I understand what it's trying to tell me. This happens when I try to...

I couldn't figure out where to put the code (from CJ), but it is currently sitting on "On Current" for the main form. I did find out, however, if I press F5 it refreshes the list. Not sure if the two have anything in common, but it works. Once I learn more about coding I'll work with the...

That's what I needed! Thank you! I had it sorted by last name because at first I wanted to be able to look up someone by first and last name via one drop down, but found out it's better to just have one box for each search. Thank you again!

It's not doing that for me...I attached a picture to show what it is doing.

Sorry my brain is a little slow today. When you say "That's what it's supposed to do", are you saying it's suppose to show everyone in the list or it's suppose to filter like my example? It currently shows everyone (even if their name does not match what is being typed); I want it to only show...

Thank you both! I'm going to go with CJ_London with this one, it seems a bit easier for me to do (major noob to VBA). **Edit** Sorry forgot to ask a quick question. Would I put this code on the form with the drop down button, or could I put it on the form that adds the new family? (Could I...

It is set at "yes", but it still shows everyone on the list, not the ones that match what is being typed. i.e. I type "S" - List only shows names that start with "S" I type "Su" - List only shows names that start with "Su" etc.

Hello, I have a form for our church members and each member is assigned to a family ID. I had already put in most of the family ID's and I have a button to add a new family, but after I add the new family the drop down list doesn't show to new family, not unless I close the form and reopen it...

Sorry, I have another question. How can I make it filter when I start typing? So that if I type "Susie" it only shows and/all "Susie"?