Search results

Hello, I've got a form that takes the members from my members table and allows me to take attendance. I have it set up with toggle buttons in the footer (so we can see what class we're currently looking at) and I want to apply two filters when we click on a button. The two filters are...

I was just wondering if it would be better for a large number of tables or if the relationship tool is always better, no matter how many tables you have. Thanks

I have 9 tables and I was wondering, could I make a table just to link all the tables together? In other words could I have one table that listed each of the primary keys and linked them that way? Would this cause problems?...be dumb?...be pointless? I was just wondering, and thought I'd ask...

Hello, So I'm still a noob at this E/R, but I followed a tutorial jdraw sent me and going by his tutorial and what you've said, it seems like you might need to make an additional table to connect the other two. If I understand E/R, what your saying, and how the tutorial set it up. Hope it...

Oh do you by chance have any ideas/hints on what my foreign keys should be? (How I should link my tables?) Thanks **Edit** Ok how would I link my Sunday School Class table with my members table? I need to be able to assign them to a class, and check if they are on the roll (if they're not...

Ok thank you! The only way a member can have multiple memberships is if they're on a committee(s). All the fields shown, in all the pictures, are what the pastor wants to track. The age makes sense. Now that I think about it, I know how to set it up in the form to display the age without...

:-O I love the screen name! I've never came across another with the same screen name (even if it's spelled differently). :-D

The age is in there just for the member detail form (which will show ALL information for that member), the pastor likes having it and it helps when we do VBS and (every once in a blue moon) we redo the Sunday School Classes. I can see that for the death date and will take of the y/n field...

I really appreciate all the help and the link for the tutorial. I'm still reading through it (just started today when I got back to work). If ya'll don't mind, I'm going to post screen shots as I go along to make sure I'm on the right path. So here's the first, let me know whatcha think...

Ok, thank you so very much for your help and explaining all that to me!

Now it's not doing anything. It's not hiding the ribbon or the nav pane when the login form is loaded. (I would say it's not showing it, but since it's not hiding it, I can't say for sure if that part is working or not.) Also, it says it can't find "MSysObjects".

lol sounds fun. :-D No problem at all, you do what you need to. I really appreciate the help!

Ok thank you! I do have my click & on load functions at the bottom, the other code wasn't necessary for this question.

No, sadly that's all one table. I'll take out the punctuations & spaces. Thank you all for your responses. I'll do the tutorial and then on my next day at work, I'll apply to this db. Thanks. (I'm going to go ahead and close this and if I have any other questions, I'll either reopen it or...

Ok, thank you. I'll check the code again, I thought they were all ended. The switch is actually a sub for my "OnClick" for the log in button on the form. And the other code is for the "OnLoad" for the log in form. **Edit** I see what you're saying about the sub in sub. How would I go...

So I have code that uses a switch to open a specific switchboard depending on the department. It was working just fine. Then when I went to try adding code for the "On Load" on my log in form, it decided to stop working. I was trying to add code so that when the login form opens everything is...

So I've posted a few forums on here and recently I've been told to normalize my data (which is a new concept to me). When I first started reading about it, I thought I had done a fairly good job of it (I have a table for my church members, visitors, children, those who have passed away, and...

Plog, you're wonderful! You're usually the one to answer my questions and you do it in such a helpful & learning way! Is it possible to do the directory with that setup? Or should I create it in Word and have the information transfer over? (I tried looking at it to see what I could do with it.)

Hello, I have been working on recreating my church's records from Alpha to Access. Today I wanted to work on the directory, and I'm not sure the best way to go about this. Our old directory is set up by family, with a family picture, address, anniversary, each member's name, birthday, and...

Heyo, Just wondering if you've had a chance to look at this and help me. I greatly appreciate the help!