Search results

Hmmm okay. I think I am getting the hang of this. About the Alternate Registration--Can you explain how to use it? I would like to use that one instead because the other people in my department who will be registering students are NOT computer literate at all and I would like to make it as...

What is the purpose of the Add Registration Alternate form?

Thank you so much so far! Your info has been helpful. Can you tell me how one would go about using the DB you made? I don't understand how it could be used to enter new classes that correspond with the correct session/period. When I add a new class in tblClass it does not reflect in the Add...

Okay... I'm trying to follow everything you said. I changed the Classes table to reflect what you advised. I created a table with StudentID and ClassID. The form to edit which student goes in which class (I'm assuming that's what you meant by "assignments"?) is confusing. How would I use a...

What would be the best way to have the classes set up, then?

Access 2000 DB: Table Relationships:

OK, this is a project I was working on earlier this year and came here for help, so if this sounds familiar to some of you, bear with me... I work at a community college. I am creating a DB to hold all the information for registering kids' in our summer Kid's College program. That information...

I'm still completely lost as to how that would help. I'm just about ready to give up on this project.

Okay... so if I were to make the "Yes/No" box part of my Students table instead of Classes, would that take care of it...? I can't redesign my DB at this point. I am running out of time.

For...? Also, disregard the issue I was having with the classes showing up multiple times...

My mistake. After reviewing my needs for this DB, I realize now that I actually do need to view all four periods at a time within a session. So what I had before works just right. So, this is what I'm working with: Now here is my problem. When I enter a new Student's record with name...

This looks like just what I need. Thank you! And yes, I will need to create reports from this. But first, why do the classes appear multiple times? Example: When I select "Session 1" and "Period 2", there are around 130 entries for "Lego Jr Continued (K-2)" when there's only supposed to be one...

I've created the same unbound box for the Periods now, but I'm not sure how to connect it to the query. Here's what I have: Again, thank-you SO much for your help. My boss has been breathing down my neck to get this project finished ASAP.

Perfect!!! Thank-you so much. Is there a way now that I can filter out the sessions by period?

Okay, here is what I have... I would like to make it so that when I select a session from the drop down box (on Form1) and click on the "open query" button, it will open the query based on what session I selected. For instance, if I choose "Session 2" from the drop-down box, I want the button...

What do you mean, query used to show the classes? I don't have any queries yet...

How do I do that?

What I need is, for example, when Session 1 is selected, only classes in that session will appear. There is over 100 classes and they are divided between the three sessions.

After trying dozens of things and research all over the internet and asking on other forums I am having absolutely zero luck and am pulling my hair out with this problem. My DB has the following tables: Registrant info, Sessions, Periods, Classes. There are three sessions total, four periods in...

Okay, I've entered some VBA coding from this website and believe I have it working right now. Now here's my problem. I have the button set to open the Classes form. But it's opening the form with ALL classes, even though I enter the parameter value for Session 1 when it opens. I only want it...