Search results

I have a table that I want to sort by the by class year. But i have like 20 options that are yes/no that i want to count the total of each so that i can do charting in excel. I have no idea how to create the query. I know that I only have to count the yes's. Bascially I need to my query to...

Question 1 I am writing this report that will break down students by graduation year and then divide them by whether they are actively using tutoring or not. My active field is a true/false checkbox. How do i change it in the report to say inactive instead of having it be a checkbox...

THis has to be an easy issue. I have a subform that in the on curren event i passes the ClassId out to my main for in an unbound text box Forms![Student]![ClassID] = Me![ClassID] I know this part works I then have a command button that should pass ClassID to a report so that it can be...

I have 2 tbl's one is class and the other is professor... in my logic i create a new class for each student however, I am trying to make label for the professor and since a professor can teach more than one class i need only one label. How do i do this

I am having a minor issue that needs a work around. I have probably 15 reports that all get filtered by the user selecting a semester from a combo box. Currently I am in the process of developing 15 forms that all do the same thing but there generate button just opens a different form. Is...

I am trying to build a report that will list all the classes that each student is taking. I also want this report to show if a student is not taking any classesby printing only their name and ID. I basically have 2 tables. One with student data and one with classes. It is a one to many...

This is a bit of a weird one. I have a combo box in a subform that has a hyperlink to open another form which in the on click event of the hyperlinked form saves the new information and should then update the combo box in the original subform. i figured i would use a requery to accomplish...

I have found a lot of answers here to my multitude of questions. However, I am having two final issues. Both happen to be in my subforms. Issue 1 I have a subform called Student addClass Subform and in the ON CLICK event of the save buttom it runs the following code DoCmd.DoMenuItem...

Ok I don't think this is hard I just can't seem to figure it out. My goal: Design a report that the user is able to select a semester from a combo box that will then filter the report to show only the selected semester. What's going on: Currently the report is generated out of a query that...

I need help. I am not sure if this is a form issue or a logic issue i have a db for tracking students the classes they take and their notetakers for classes. Each class is most likely unique to each student but sometime there are multiple students in each class that need a notetaker and there...

My goal is to have two combo boxes the first filters the second. it controls the semester that I am viewing. This works if i don't use continous forms but when i do it requeries every record in the form instead of the current record. I am not an access or vb guy but i have picked a lot up...