Recent content by mouseman2006

Thank you for your helped, it worked!!

Thanks again for your continued help. I am adding the expression you gave me to the Notes form, next to OnOpen. I enter the code fine, but I get an error message when I run it. I am not sure what I am doing wrong. When I click on the command button labeled Notes it is saying Run Time Error...

Hi, thanks for your continous help, but i received an error, when i ran the code. It says: The expression On Open you entered as the event property setting produced the following error: The object does not contain the Automation object 'Me'. I entered the following information in On Open...

Thanks for your help. I am using Fneily suggestion, but I did in the Macro Action page. I have the following information Echo line 1 OpenForm line 2 Go to record line 3. In GoToRecord, I have the following information: Form Notes New I would like, if possible when I click on absences it...

Thanks for your help, it worked like a charm. I have another question. In my notes form I have the following fields: Student ID Date Notes Can I run a macro that will place the correct Student ID number from the Student Information form to the Student ID in the Notes Form? In other words...

Hi, I have a form that lists Students Information, Parents Information and a subform called Attendance. I want a macro to work in the attendance subform. So when i click on absent (yes/no)data type it will automatically go to the Notes form. Thanks in advance. Stephen DeSerio

Duane, Thanks again for your help! I got it working correctly with a subreport. Thanks Stephen

Hi Again, I did exactly what you said with the combo box, but i obtain no information. I should have atleast 5 missed assignments for one student, but it is leaving it blank. I used the following formula: SELECT [Missed Assignments - Report].[Social Security Number], [Missed Assignments -...

Hi Duane, Thanks for your help again. Last question, the combo box works great, but it does not seem to link the data to a specific student. For example, when i open the report, it has every student missing 5 assignments, which actually it is just from one student. Is there away to link the...

Thanks i used the combo box, it works like a charm! Steve

Thanks for your help! I see how the formula works. How would i use this formula to pull data from another query that is not part of my report. Thanks again Stephen

Thanks again for your help, but i decicded to try something different. I think it will be easier for me to count the students who scored "0" on the test (which will mean a student who has to retake an exam or missed the assignment). I am using the following formula: =DCount("GradeA","Class...

Thanks for responding. I am sorry i was not clear. I am actually trying to count the Completed Assignments field, which is a "Yes" and "No" Data Type and place the information in the summary report. I am trying to obtain a count of students who missed their assignments. I am using the...

I have a class summary report and i would like to find the number of missing assignments. The missing assigment report is from another query. Is there a way i can create a formula in my summary report and obtain the information from my missing assignment query. Thanks you in advance. Steve