Search results

Spikepl - The entire thing is across 2 semesters, and the choices are different per semester i.e. the same module cannot be chosen in both semesters, so I suppose removing one course from the second list box when it is picked in the first list is actually irrelevant. A course can only have 1...

Spikepl - The list boxes are working great - I have two queries; Semester1courses, and Semester2courses - As the student can pick a maximum of 3 for each Semester I have just done 2 list boxes, one for Semester 1 and one for Semester 2. Everything is now validated so that the user can only pick...

Spikepl - Thank you for all the advice, and a great bit of code! I have added the code to my database, and just had to make the minor replacement of closing the space in strMsg = strMsg & ", " as it was not able to complete a Dlookup, but apart from that everything seems to be working great! I...

Spikepl - Initially this throws up a problem - In order to validate the choices by totalling the number of credits each course has, I had some VBA shown below which did this: CreditsChoice1 = DLookup("[CourseCredits]", "Courses", "[CourseName] = '" & Combo51.Value & "'") CreditsChoice2 =...

Spikepl - Thanks for getting back to me! OK - The reason I am slightly hesitant about list boxes is because I had already set up the combo boxes (not knowing any better), and have done the coding behind them, but I suppose if using list boxes will make everything easier it wouldn't take too long...

I don't understand what you mean by what code I am running?? Basically, I am doing a database which allows students to pick up to a maximum 6 courses across the university year. Firstly, they fill in their own details i.e. name, address, email etc. I then have a button with this code: If...

From what I understand, I have now set the recordset to the one which I would like, but am having trouble displaying each record in the recordset in separate textboxes. The Recordset should be something like this: B787878 BSB090 B787878 BSB050 B787878 BSB045...

Thanks for getting back Uncle Gizmo - Apologies for the confusion; by form, I mean a simple access form which you can put combo boxes/textboxes on etc, in this case, it is where my textboxes are located. By Module, I am not referring to VBA modules for code, but rather a university course i.e. a...

Good Afternoon, I will try and make this as clear as possible, and hope that someone on here can help me! I have a table titled 'enrolments' - This table has 2 fields, StudentID, and CourseID. It is a one to many table so for example, one record could be: StudentID B787878 CourseID...

Good day all, This is my first time using Access Forums - My name is Mark, and I hope you can help me with a problem I am having. I have a form with a single control source, several combo boxes with record sources only based on queries, but these combo boxes do not have control sources (the...