Search results

I have two tables, one containing the result of each student's answer to a multiple choice question. StudentName, StudentID, Q1, Q2, Q3, Q4, Q5, Q6 In the fields Q1, Q2, etc, are 1's and 0's, 1 if the student got the question correct and 0 if they did not. In another table is the standard...

Thanks! I was using the name of the object on the tab, and not the name of the subform. Thanks much.

I am trying to reference a text box on a subform, that is located on a tab. The main form is named: Language Arts Assessments The tab control is named: Ind_Grades The Individual tab is named: Kindergarten The subform on the tab is named: Kindergarten1 The textbox is named: Wi_DRA2 Do I...

I have a table with various school names and a form with a combo box with these school names. I can easily select a single school and the query will show only the data for that school building. How do I set up the combo box or the criteria in the query if I want the query to show ALL of the...

I have several subreports (student transcripts from previous school years) on one report. Some students do not have any grades for a particular school year (if they moved out of district, then returned). 1. Is is possible to make the subreports that do not contain any data not visible and...

Thanks I will give that a try.

Let me clarify, I was not talking about the order of the rows, but the fields. For example, if my Excel has the following fields from left to right StudentID, LastName, FirstName. When I import this spreadsheet into Access, and assuming it adds an ID autonumber, the field order is switched...

When I receive test data from our Dept. of Ed., individual student answers for each multiple choice question are all kept in one field: Field1 ABCAACDCCDAC ACCAADDCCAAB ACCABDDCCAAB etc... How can I split this one field into many fields, one for each answer. I would like to automate this in...

With Access 2007, when I import data from an Excel 2007 spreadsheet, the fields are out of order when compared to how they were arranged in Excel. For example, Access adds an ID field, and when I look at the design of the table after import, the ID field is never the first field, but at some...

Great idea! I was focused on programming the report.

I tried your first suggestion before I posted and the program prints multiple lines between the some of the bounds. I am trying to stay away from sub-reports. However, it may be the only way.

I have a report of student's decending reading scores built from a query. I would like a line to show up that breaks the students up between levels. For example, there would be one line seperating the students who scored 6 and above from those who scored 4 or 5 and a line seperating those...

Can I use a variable for the expression in a DLookup function? For example, I would like to use the value from a textbox to determine which field is used: myStart = Me.CurrentStartPoint Mileage = DLookup("['myStart']", "MileageChart", "[Finish] =" _ & Forms![frmDailyMileage]!myFinishPoint)

Is it possible for VBA code to automatically highlight (select) a single selection from a list of choices in a listbox, rather then with a mouse click?

Thanks That was the trick!

The tables are set up with the following field names: StudentName MathPerformanceLevel SciencePerformanceLevel EnglishPerformanceLevel SocialStudiesPerformanceLevel This data is downloaded from the state in Excel format.

In order to graduate, a student must pass all 4 parts of a state standardized test. If they do not pass one or more of the tests (Math, Science, English and Social Studies) they need to take the test they did not pass again. How can I query the students who need to retake the test by looking...

Got it... Me("OverallAvgPassRate_3_" & CurrentYear)

I would like to use a variable in a control name in VBA. For example, each of the text boxes below will receive a value based on the results of a DLookup function: Me.txtboxOverallAvgPassRate_2005 Me.txtboxOverallAvgPassRate_2006 Me.txtboxOverallAvgPassRate_2007 I would like to condense them...

That works if the field you are looking for matches exactly what you are looking for. These are file names that I am searching through. For example, in the string c:\holt_scout\01-CA1-Defense-40-Stunt1.avi, I want the query to be able to pick up all the file names with the word "Defense" or...