Search results

Hello, I've got a form with a drop down combo box with two columns. When you hit the down arrow it shows both columns, but when you click a choice, it only shows the data in the first column. How do I make it show both columns after it has been chosen? Ex. First col is First Name, second...

-_- I'm at the point I will pay someone to do this for me! So many headaches over something that seems so simple. Ok. Thanks for all the help and explanation. I will research those topics.

That sounds great, my only problem is I no nothing of VBA. Can you point me in the direction of a tutorial that can help me set this up? Also, can I add people to the class as needed and take them off the roster? I'm starting to think I'm too noob for this task lol.

I'm sorry I don't know if I'm being dumb or if the heat is getting to me...Does when you say "to populate for that week" does that mean it will automatically show up the names or that I will have to enter the names every week? If it does mean I have to add every week, is there any other way to...

Ok I think I understand what you're saying, which sound amazingly easy (just hope my limited knowledge of Access will allow it to be easy). :-) But can you help me set it up? I understand how to do the Menu Form and the date and class would be a temp vars that would be passed to the Attend...

Ok, so after playing around I think I found the underlining problem. I'm trying to generate a form like the one pictured. (This one was accomplished in my practice db when I added the names to a table for each class.) But in this db I'm trying to pull the names from the member's table and the...

Here's the picture of the relationships. As for the form. There will be a main form that the attendance is entered in and a subform that will only show the attendance for a specific person (this sub form will be located in the member's detail form). The main form will be just the name, date...

Ok so I have an enrollment table, members table, ss attend table, and ss class table. They are linked as follows: Members (one to many) Enrollment Enrollment (one to many) SSAttend Enrollment (many to one) SSClass Is this correct? It looked like that's how you were suggesting the...

That's true, but I can't wrap my head around how to take the roll sheet and only mark those absent, and still the the records that the pastor wants. (Member Attendance History, Class Attendance for month/week/etc, and so on.) Not sure if it's the headache, lack of food, or just a duh moment...

For the Enrollment table, how would the relationships go? How does this keep it from looping? Do I need to delete my relation between SSAttendance & SSClass?

Oh, sorry (about the S1 thing). Wouldn't it be the same thing to just mark present? The way it is currently set up (in Alpha) is they print off a roll sheet with the date of each Sunday for the month. Each Sunday the teacher marks who's present, then Mon I go in and transfer the mark into...

K, now that I finished reading the rest of your post... I understand the need for the Enrollment table, thank you for explaining that to me and I will add it. As for the attendance and absences, I kinda thought they went hand in hand. If June 14 shows a check, then they were present, but if...

Real quick, the S1_, S2_, etc. Those are for each Sunday of the month. (1st Sunday, 2nd Sunday, so on.) I did this because I thought it would save space and be easier to generate how often someone attend if each month is on a row.

Thank you! That helped me fix it.

Sorry if this isn't in the right place, let me know and I'll move it. I have a drop down list to select a committee, but my list is only showing half of the list. There's no scroll bar, and when I try typing in one of the others, it tells me it's not on the list and asks if I would like to...

Ok, here's the database with just the tables and forms for this. Basically what I want it a form to show the names of people who are in a specific Sunday School class. Then for each Sunday of the month, I will select if they were present or not. I would like for the Date of each Sunday to the...

Ok, so I know I've asked about this alot, but I believe I've got my tables normalized correctly and I see the issue. I've got a form I'm trying to make, Sunday School Attendance, and I've got three tables linked, Members, SSAttend, SSClass. Linked as follows: Members to SSAttend (One to Many...

IT WORKS!! Thank you so much guys!! And thank you, Uncle Gizmo, for explaining that to me!

Good news! I (somehow) got the subreport to filter (by playing with the actual report). If I open the actual Deacon Family report, it won't filter...but in the form it does. So that's good! Now my problem is how to make the deacon tab not available if the member is not a deacon, and how to...

lol maybe... Yea I kinda am. Just kinda led there. I'll close this one. Thanks for the reminder.