Search results

I have a grade book application for our school with tabbed data sheet forms. Updated data on one data sheet does not appear on another. The primary job of this application is to input student schedules. Virtually all of the entries in the schedule table are derived from lookup tables to...

OK, I'm stuck. I have a tabbed interface with subforms for various functions. On the Print function subform I run a query-based report that takes criteria for two items from the form: [Forms]![Main Navigation]![SchoolYear] is one. When I run the report the result looks as though the query...

I can't figure out how to create the "Northwind" style tabs - ones that look like file folder tabs, have cool colors and an image. I have read many posts here and my miserable manual, but I am at a loss. I want something like a hot pink tab with George Wilkinson's picture on it. I'm...

Thanks for your help, I figured the problem out. In other reports I had to pass a parameter for the where condition, but in a report based on a query where the criteria parameter was pointed to an object on a form, that is not necessary. I was doing both.

Two buzzards are sitting on a dead clown having a feast. One looks up to the other and asks "Does this taste a little funny to you"?

The query is working well: SELECT Students.StudentId, Students.[First Name], Students.[Last Name], [Forms]![Print Menu]![SchoolYear] AS SchoolYear FROM Students WHERE (((Students.StudentId) Not In (Select ID from [Grade Level] where [Grade Level].[School Year] =[Forms]![Print...

Thanks for you on-point reply, and the lesson. I had trouble making this query work until I realized that I actually did not have any missing records in the table. I must have a low expectation of my users.

Very cool, thank you for sharing your wisdom.

I really appreciate the reply, but I did not give a sufficient explaination of the tables. In the grade level table there are several records for one student, not one. In our school, we cannot calculate a grade level (i.e. 10th, 11th or 12th grade), it must be assigned. So a student may have...

Is there a way to enable a "printer prompt" dialog box out of a report? When I print directly from Access I am given a prompt box, where I could select a printer, but in my reports the print executes without a prompt. I am using DoCmd OpenReport from VBA for printing.

I would like to craft a query that identifies the absence of records. Specifically I have a table with students linked to a table of grade levels. I need to audit for missing grade levels, i.e. students whose grade level for a specific year is absent. My knowledge of SQL is growing, but I...

Right, I get it now - the builder is generating the SQL not simply the fields I select. I am getting a Cartesian product, a concept new to me today. I tried monkeying with the joins in the SQL and wound up with over 10 million results. Thanks for the direction, I now know what to go learn about.

Here is the SQL: SELECT Classes.[Class Name] FROM (Students INNER JOIN Classes ON Students.StudentID = Classes.ID) INNER JOIN [Grade Level] ON Students.StudentID = [Grade Level].ID; It is the presence of the Grade Level table (147 records) that results in the return of 1271 results. The...

Here is an ammendment to my question. In the query builder I had a related database, with data I intended to add on the report. At the time of the question posed above, it was not part of the query, just in the query builder. When I remove it, the query works as I expect, it returns 811...

I have created a simple query to calculate averages from data in the records of one table. I have no selection criteria in this query, I want to calculate averages for each record and use the resulting recordset as the basis for a report. In my table there are 811 records, but the query...

Thank you for a excellent solution, and thank you for the syntax lesson. This solved the problem perfectly.

I need "Big Picture" help. My application will generate report cards for the students at my school (it is already handling all of the scheduling). Each "class" (i.e. Algebra) has four quarterly grades. The grade fields start out as null, because any number (like zero) could be a grade...

I have received much help in this forum, and I do not regret not getting an answer to this question (whining is forbidden, so I won't discuss my stupidity). Here is what I learned since I posted the question. I was not forcing footers to groups or sorts where I did not need to put text or...

I have a very fundamental confusion about page breaks on reports. My reports are breaking on the first group that contains the "keep together on one page" condition. Subtended groups with that condition are kept together on a page but do not result in a page break. I cannot find a helpful...

Thanks for taking the time to help me. Actually that is exactly what I am doing. I have no problem making the combo box drop down student names, but when I select a name in the box, the data in the subform does not change.