Search results

Thanks for responding. :) I plugged in my variables, and it did wonders! Though, I have one more question. Here's what I have: Private Sub ClassSize_AfterUpdate() Dim x As Integer x = 1 For x = 1 To Me.ClassSize [Forms]![Class]![Class Seat subform1].[Form]![SeatNumber] = x...

Hello, I've run into a smidge of a programming problem on my form, and I'd appreciate any help whatsoever. I have a table called "Class" with a subform called "ClassSeat". The ClassSeat subform has the following fields: ClassSeatID (AutoNumber), ClassID, StudentID, and SeatNumber. The field of...

Greets Mr. B. :) Really appreciate you taking the time to look through my nonsense. To answer your questions, I do have a combo box that lists seats 01 - 30, and I've been trying to create a query that would populate the box with available seats. Taking your tips into consideration, I now...

Any ideas at all would be helpful. :)

Basically - is it possible to run a query based on a selection in one combo box (ClassID) and then have the filtered results show up in another combo box (SeatNumber) on the same form?

Ack - so instead of taking class size into account, I've been given permission to just make 30 the max number of seats for every class. So far I have the table with ClassID, StudentID and SeatNumber, where ClassID and StudentID form the composite primary key.These fields are located in a...

Thanks for responding! :) And that actually makes a whole lot of sense. Will mess around with that and let you know the results in a little bit. *currently working on something else*

Hey again. :) I've run into yet another problem on my form, and I'd appreciate any help at all! There's a text box on my form that is bound to another field called "SeatNumber", which basically reserves a seat for a registering student. The problem is that you have to blindly enter a seat...

Ah - apparently it's bad form to store derived values! Gonna fiddle with reports then. :)

Just kidding. I've run into another roadblock and would appreciate any tips. Where exactly do I put the statement "PaymentAmount = FeeTotal + TuitionTotal"? Would I be dealing with a property of PaymentAmount's textbox? Or the main form's? Or none of the above? :o

Problem solved! I just created another field called FeeTotal which accounted for the total cost of additional fees, completely separate from the TuitionTotal. PaymentAmount then equals FeeTotal + TuitionTotal. Then after a bit of coding (and nested IF-THEN-ELSE statements), I got the...

Argh, typo in thread title. "...more than one box checked!" Sorry. :O

Afternoon all. :) I've been working on a registration form where students can enroll in classes. So far, they can enroll in multiple classes through a subform in continuous form, and the tuition total is calculated in the subform's footer. I then created a text box in the main form that...

Oh, wow. That's all it took. Simply changed the datatype for the StudentID to Number on the Registration table. Thank you so much! Now I just need to figure out how to enroll one student in multiple classes through the same form, versus having to fill in the same form several times for...

Thanks for responding. :) And StudentID is actually set to AutoNumber on the Registration table. If I set it to Number, would the relationships still hold? Gonna mess with that right now.

Afternoon all! I've been trying to create a Registration form (e.g. enrolling students into a class), and I just keep running into problems. So far, I have tables "Student" and "Class", and a third junction table called "Registration" with a composite primary key. I created a form based off of...

Thanks so much for clarifying. Makes perfect sense now. (Though, the key word "junction" should have given that away. Having an off day here.) Gonna play around with both of your suggestions now, and I'll let you know if I run into anymore problems. Thanks!

Hello again, Paul. :) And I'm actually not sure what you mean by a many-to-many junction table. :( My registration table currently includes Student ID, Class Code and additional payment information (e.g. payment amount, type). I fiddled with relationships to where the ID and Code are linked to...

(e.g. enrolling one student in multiple classes.) Hello! I'm having a spot of trouble and would appreciate any help at all. (I'm still an Access novice, so apologies in advance if something doesn't make sense.) My three tables are Student, Class, and Registration. I created a separate form...

Oh! I think I understand now. I was poking around in other threads, and found what I think you were describing. I'll try messing with the control source tomorrow. Thanks for the tip. =)