Search results

Hey, thanks for the advice, I'm not very good at vb so I have a tendancy to over code. Here was what I used to solve my problem; Private Sub Text32_Click() Select Case Me.Combo34 Case "1 Day Camp/Class" DoCmd.OpenReport "Class Enrollment 1 Day", acViewPreview, , "[ProductID Field]=" &...

Figured that out too. Thanks.

Now I have another question, I have it so I click OPEN and it opens, but I need it to go to the report for the ClassID. Here is my code; Private Sub Text32_Click() Select Case Me.Text32 Case Is = "1 Day Camp/Class" DoCmd.OpenReport "Class Enrollment 1 Day", acViewPreview Case...

That worked perfectly, thanks.

I have an enrollment database for a theatre company, that is used to enroll the students into classes. How ever they have 9 different types of classes (eg, 1 day classes, 1 week classes, etc..) and each of these needs a differently laid out Class List. Its currently set up that they can click...

So, if I'm setting up a class table, I have Camp names Limit of Students However, we have 22 different types of camps, some which run some weeks and some which run others. What would be the best way to enter this information? Should I create new fields for each individual week...

I don't. I just have a master list of the child's details and what different classes they are enrolled in and use a query to separate them.

I'm designing an enrollment database for a summer camp program. It runs all summer and has up to seven different classes each week. I have a form that allows for each child's information to be entered, and then a week by week pick of which class they will be in which brings the information to...

I am creating a database to enrol children in summer camps. We have multiple camps per week, and have created a form to choose which class they want to be in, however, I would like the class to turn to red, or give some indicator once the maximum number of students is reached. I have tried to...