Search results

K, here's two pictures of my set up. The "detail form" png shows the field asking if they are a deacon or not. If this bubble is filled in, then (looking at the "deacon tab" png) this subreport will be filled out with all the members assigned to this specific deacon and the "Deacon's ID" field...

K, last question! I've got a subreport kinda set up...but I don't know how to get it to show all members assigned to that specific deacon. It's in my member detail form and I have a tab for the deacon families, there is a field that will show the deacon's number. I want the subreport to pull...

Ok, so I played around with the code a bit, but I can't get it to work. Can someone take a look and let me know what's wrong? Please? Private Sub MemberInfoTabs_Change() If MemberInfoTabs.Value = 7 Then If Forms![Member Details]![Deacon] = True Then...

Oh ok, thanks for explaining that plog! I thought everything had to be connected. As for the connection between Deacon and Members, it's really how you look at it. So there maybe a deacon with DeaconID "1" and his name is Tom Smith, Tom may have many families with many members to look after...

So I know this question goes somewhere, but not sure where the best place is, so I posted here. I have three tables (for this question) Members, Family, Deacon. Member is linked to Family (many to one); Family is linked to Deacon (many to one); and (currently) Deacon and Member are not linked...

Ok so I want to generate a subreport for my deacons that show what families have been assigned to them. I kind of know how to set this up, but I'm missing one piece. Using the wizard I created a subreport that pulls the name & phone number(s) for each member with the same family ID, and...

If you don't mind, can you explain it to me a bit? I get some of it...just a little lost on other parts. I italicized my thoughts for each part. Here's the code: Private Sub TabCtl0_Change() 'MsgBox "Changed Tab ... " & TabCtl0.Value What is this for? Dim strInput As String If...

I have a form "Member's Details" that has a few tabs. One tab is titled "Deacon Families" and I want to be able to either lock it, or grey it out, or something along those lines base on if the member is a deacon or not (I do have a yes/no field asking if they're a deacon). If they are NOT a...

My top faves! 1) There was a big fat fluffy cat that passed away and went to the gates of Heaven. There St. Peter greets him asking what he would like in Heaven. Stretching, he replies "A biiiig fluffy pillow in a nice warm sunny spot." St. Peter tells him where to find his wish and he runs...

The record to record thing sounds about right. It would only show when the user is looking at the Member Detail form. It's just a little something to show what type of member they are. Thanks for the help!

Hello, Just out of curiosity, can you have a form that will make a cosmetic change base on the value of a field? So I have a Member's Detail form and I would like the form to look a little different (say header background a different color) based on the member type. Is this possible?

I was having the same problem, and since I don't have any VBA code, I just went to Database Tools > Compact & Repair Database. (Thought I'd share in case anyone else is having a similar issue)

Thank you! This database is my practice db, I've got one that I'm slowly adding things to (only once I learn the proper way to implement them). The new one, I believe, is structured better. I started that one after someone shared a tutorial on Entity Relationships Structures (I think that's...

Finally got it to work! (Had to delete over half the members and a ton of the fields, but all the required info is there.) Thank you so much for your help! **Update: I'm going home for the day, so if I don't reply right away, that's why. Thanks again for all your help and for taking a look...

Ok, I tried your steps, twice, and it's still not working. Tells me a security token is missing (not sure if I previously stated that). I'm going to try to remove all the other data and just leave what pertains to this question; I'm wondering if the real issue is it's too big? It's currently...

Oh ok. Thanks! I'll look into a proper way to do this.

Ok so I finally got a chance ( and remembered) to check this answer out. It works perfectly now!! Thank you so very much!!

I know this is old, but I just realized I forgot to mention the important reason why I need locks and what not. This database will have financial information (like tithing) and I want to be able to keep those who don't need the access out. (realized this when looking for a reply from someone)

Oh well don't I feel dumb!? lol I'm trying to upload it, but it's taking forever. It stopped once and said a security cert was missing. Trying again hoping it won't say the same. Thank you so very much for helping me! **Update** I keep getting an error about a missing security token. I...

I'm sorry I don't understand what a "cut-down version" is. Thank you so much for the help. **Update** I am heading home right now, but will be back here tm. If you let me know exactly what it is you want I will send that to you tomorrow. Thank you again for all your help.