Recent content by workingpoor

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

Oopss Your suggestion totally worked rural guy.. Sorry... When I refreshed my browser it didn't show your post... Thanks again

I did a little changing I did a little more work and i have gotten rid of the type mismatch error. Now i am gettting a dialog box asking for a parameter value. Something has to be wrong with the last line of code where i set the parameter value to equal the variable reptcriteria. Am I...

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

That worked perfectly! Thanks

Can you be a little more specific right now i am jsut using a generic select statement SELECT semester.semester, DSS_Student.StudentID, [LastName] & ", " & [FirstName] AS Name, Classes.CRN, [Dept] & "-" & [course] & "-" & [section] AS [Course #], [profFN] & " " & [ProfLN] AS Professor FROM...

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

Thanks I knew it was something close. I wasn't sure if you could requery a control.

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

Shaneman: Your solution was correct I was using the form name of the subform instead of the control name which is why it wasn't working thanks for you help

I have looked at looked but can't find the error anywhere. Do i follow the caption name in the properties or the name of the form?

I looked around at other posts and i know the syntax should be [Forms]![MainForm]![subform].form.requery so for my application it should be as follows [forms]![Student]![Student_Classes_Subform].Form.requery however i keep getting the following message "DSS Student Database Can't find the...