Search results

I have a frmOrders with a subfrmOrderDetails, currently set up so that the sub form is invisible if the main form has a null ID, so when the users open to a new record they can't jump straight into adding things to a non-existent OrderID. The code for the form is Private Sub Form_Current()...

I have an enrollment database for a summer camp. The users requested that I create a report that shows the students name and the first camp they have enrolled in for the summer (so they know who is new or not.) The database is broken down into Season>Week>Classes and I've got so far as to have...

I have an enrolment database to put students in classes. On the class setup form, there are three combo boxes, to select Teacher1, Teacher2 and Teacher3 (classes have multiple teachers, but never more than 3), which all come off tblTeachers. The combo-box records the TeacherID on the...

I have a Class Enrollment Database with a Master Roster report, that details the Students Name, and what class they are enrolled in. Its quite a long document, and its sorted by student name. What I would like is to be able to assign each class a color, and then that row to have that selected...

I use Access 2010, and my co-workers use Access 2007. I created a database, btu I am the only one who can open it, so I rebuilt it as an Access 2003 file (they still can't open it, even when I save it as a 2007 file, but i know there are compatibility issues between them). Anyway, its all...

I have 2 cascading combo boxes, the first lists Productions, then the second shows the different Performances for each production, both on the same subform (frmOrderDetails). It is currently part of a subform on an Orders form, for people to buy tickets. I can use the boxes when I have just...

I need some creative help here, I have an enrollment database, which currently enrolls students through an order form, (that is we choose the student, the class- which lists the price, etc...). This is put onto an Orders Table, and an Order Details ID table, tblOrders has the detail of the...

Using Access 2010, I occassionally need to export a report as a PDF file. These are invoices, and I'd like the filenames to be created automatically (CustomerName then Order Number) so that there is consistency. Has anyone attempted this before, and could point me in the right direction?

I have an invoice function on an enrollment database I'm working on. Currently we can open up a formatted invoice for a particular order, and it is all laid out and totalled properly, however we ocassionally need to combine 2 or more invoices together, usually when there are multiple children in...

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...

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...