Search results

When I run this query everything works SELECT Sum(tblCourseTaken.Units) AS TotalCredits, tblCourseTaken.[790ID] FROM tblCourseTaken GROUP BY tblCourseTaken.[790ID], tblCourseTaken.CourseStatus HAVING (((tblCourseTaken.CourseStatus)="Completed")); When I try and narrow it down from all to just...

I have a form with unbound controls that I set the control source as a query =[qryUnitTotalRequired]![TotalCreditsReq] which just returns #NAME? I have tried this several different ways with no luck. http://www.access-programmers.co.uk/forums/showthread.php?t=233369 the other problem is that...

I have a form (CourseTaken) that has a subform (UnitTotal). Everything is working except that the subform "detail fields" will not display until all three fields have an entry though they do save the information. The other problem is that the unittotal "footer field" will not display the total...

Now i'm getting a run time error "13" Type mismatch

Ok now you lost me. I assume you meant turn the input fields (not forms) to labels but how you do that?

Still no totals. I ran it through debugger, the UnitTotal turned red, so I removed that hoping it would make the others work. No such luck.

If i'm ready to scream I can imagine how you feel trying to help. I still cant get it to work so made this graphic hoping you can see what I am doing wrong. Again thanks for all your help.

I had added the quotes, but copied yours exactly and still get this error.

Sorry to be such a pain, but this is totally over my head. I understand the verbs but the nouns escape me. Basics: 1. Create an unbound text field on the CourseTaken form (UnitTotalReq) 2. in After Update of the CourseStatus field add: Private Sub CourseStatus_AfterUpdate()...

That link just takes me to the main page with 203 entries. Where do I go exactly? Like Queries /.......

I set the course tables up as a cascading combo boxes. That was the way I had read the instructions to do that. The reason I used a subform is that it was the only way i knew to set a query as the source instead of adding the fields to the table. I am willing to add the fields to the table...

Finally managed to get the total to work. Now the only problem is that the first three fields will not display unless all three (status') have an entry though the information is saving.:banghead:

Another problem I encountered when deleting the information and re-entering from scratch. The total footer field displays. but the other three (query) fields do not display until there is an entry for all three. though the information is saving. and I still can not get the unit total to...

I have not added a footer to a from before, is it the same as adding one to a report? =Count(*) as the control source?

Thanks!! the subform is displaying now and the req, core, content are correct, but the total is not calculating the three correctly. it is just showing the total for content. What i need it to do is total the previous three status/credits.

I have a form (UnitTotal) as a subform on the main form (CourseTaken) which is run from a query (UnitTotalAll). The UnitTotalAll query is has 2 fields from the main form (frmCourse Taken /Units & Status) and 4 queries to calculate the different units tied to a specific status (3 units -...

I managed to get it to save the actual data I wanted displayed by changing the row source code from ID to Name SELECT tblCourseDept.DepartmentID, tblCourseDept.DepartmentName FROM tblCourseDept ORDER BY tblCourseDept.DepartmentID;

I did actually manage to get the record to display in the split table now by working with the Row Source code. Now the only problem is that it is displaying "15" instead of "BIOL" and for the department and "12" instead of "525" Course Number.

Way Way over my head there.

Saving but not displaying on split form I have been working on the cascading combo boxes. Everything is now working except that the values (department and courseNo) are saving, but not displaying in the split form. I have followed the advice on fixing the problem (must not be doing it...