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

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

NO NT_ID is not... mainform feeds from a table called Students subform1 feeds from a table called Classes (has NT_ID field in it) subform2 feeds from table called Notetaker (NT_ID )

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

Im not really sure what you are asking... can you clarify it a little