Search results

  1. E

    Modern Charts - Display Data Label -> Using VBA Default On?

    Thanks arnelgp! That worked for individual reports. Now I need to figure out how to get that code to run when each report is a sub report on a master report. Thanks again for your help.
  2. E

    Modern Charts - Display Data Label -> Using VBA Default On?

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

    Query will not read string from "dummy" textbox

    Thanks. The QueryDef is probably the route to go.
  4. E

    Query will not read string from "dummy" textbox

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

    Report Wizard 2007 versus 2010

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

    Fill a column during an Append Query

    Wow. Very simple: Expr1: "ORF_Benchmark" and then choose the field to append to. I swear I tried this exact technique the first time. Thanks for your replies and help!
  7. E

    Fill a column during an Append Query

    How? Everything I have tried doesn't work! For example, if I want to fill the column with "ORF_Benchmark"?
  8. E

    Fill a column during an Append Query

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

    Changing the size of a rectangle with VBA

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

    Counting 1s and zeros

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

    Compare two cells with text

    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).
  12. E

    Using a variable name as a subform name

    I removed the single quotes from around the variable name and that did not work either. Just to reiterate, this is a variable name that I want to use as the actual name of the subform.
  13. E

    Using a variable name as a subform name

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

    Page Break and Groupings

    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?
  15. E

    Run code for each record

    Thanks! That was it.
  16. E

    Run code for each record

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

    Calculate average

    Wow, thanks. The original data has over 3000 students and each test has between 50 and 70 questions, so I am going to try to change the code to create some loops.
  18. E

    Calculate average

    That will work, I was just hoping there was a "slicker" way in Access only. Thanks for the Excel tools.
  19. E

    Calculate average

    Thanks, I will take a look.
  20. E

    Calculate average

    Thanks for the reply. The first table is a listing of each student and how they performed on each question of the test. 1 stands for correct and 0 stands for incorrect. For example: ADAMS BOB J 000125 0 1 1 0 would imply that the student got the 1st and 4th questions wrong and the...
Top Bottom