Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mouseman2006
  • Order by date
  1. mouseman2006

    Macro

    Thank you for your helped, it worked!!
  2. mouseman2006

    Macro

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

    Macro

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

    Macro

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

    Macro

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

    Macro

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

    Lookup Function

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

    Lookup Function

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

    Lookup Function

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

    Lookup Function

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

    Lookup Function

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

    Lookup Function

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

    Lookup Function

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

    Lookup Function

    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

Part and Inventory Search

Back
Top