Search results

Using Access 2019, and the modern charts, I have created a series of bar graphs to display aggregated student behavior counts by month. When I designed the chart, I selected "Display Data Label" so that the value shows atop each bar. The charts are based off of a table that I update with a...

I have a two-column list box where the user selects multiple Test Names and Test Measures. Through VBA, I loop through and create a string of the selected items and store into two seperate variables, one for each column. I concatenate with the "In" and some parenthesis to end up with the...

I have searched in vain for this answer, but so far no luck! When I use the Report Wizard in 2007, I get a report where the labels are linked to the appropriate textboxes. I can also move the linked label/textbox around and the adjoining labels and textboxes adjust their position...

A testing company has changed the format in which they send us our results. Before, every student would have ONE row with multiple testing information as the column headers. For example: StudentId, TestName1, Test1Score, TestName2, TestScore2, etc Now, we receive the data where students have...

I have a report where I am trying to change the size and position of a rectangle based on student scores. I have the rectangle in the detail section and the code in the detail section Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) ACTMathPercent = Me.ACT_Math_Percent...

In the table (a small sample of a test where 1 is correct and 0 is incorrect. The test question number is in the header row) below, how would I get a count of the 1's and zeros for each school, A B and C, for each question 1 to 6? School 1 2 3 4 5 6 A 1 1 1 1 1 0 A 1 0 1 0 0 1 B 0...

How do I compare two cells in a spreadsheet with each other using the IF statement. For example: =IF(A2 = B2, "Yes", "No") always gives me No eventhough A2 = C and B2 = C (both contain an upper case C).

I have an array of subform names that I want to use as part of a line of code that converts numbers to specified letters: currSubForm(1) = "sbfrm_Commit_Students_Learn" currSubForm(2) = "sbfrm_Know_Subject_Teach_How 1" currSubForm(3) = "sbfrm_Know_Subject_Teach_How 2" Then inside a loop I have...

I have a report that has 3 fields, School building, Teacher and then students. I have grouped the report by School Building and then by Teacher. How do I force a new page so that I get a the teacher's student roster on each page?

I have a report that will "bubble" in a student's student ID number on a test scan sheet. For example, if the ID number is 381, then the code I have written will shade in (make the backcolor of a textbox black)the number 3 bubble in the first column, the number 8 bubble in the second column...

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

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

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

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?

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