Search results

Thanks but I am prohibited from doing that. It contains personal information on hundreds of students that is strictly confidential. Thanks for your help

Thanks for the reply. That is not working for me. Also in this query are class records from a class table keyed to the student. I am wanting to get class records for the students who were seniors in *year* I am using 2007, so I don't have a TOOLS menu, but if I drag the grade level table...

I have a query that is selecting students from a student table, keyed with an id. I want to only select students who are seniors in a certain year. The grade level (i.e. senior, junior) is contained in another table with ID, Year and Grade Level fields and is related to the student table...

I am having trouble joining two queries, I want to include all records from each query. Query 'N" has three records, query "S' has four for the matching ID field. I am hoping to have the result produce seven records. When I use the following: FROM qryN INNER JOIN qryS ON N-ID = S-ID...

Well this problem has morphed a bit. The "unknown" response to the combined query is coming from the source queries, which were working fine yesterday (they return the same response). I tried to re-create one of them in query wizard and received a message that the query could not be run...

I am very greatful for your help. I am not allowed to publish or distribute information concerning our students, although today I wish I could. Here is what I have. The result of running the query is "Unknown".

I am grateful for your answer, but there are some terms I don't understand. When you say start a new query and "add all three to the list", do you mean include them in the top portion of the query builder window?. When you say "join them on studentID", is that accomplished by dragging between...

I wish to join the results of three queries. My application is in a special needs school and I am calculating GPA. This requires converting numeric to ordinal grades and averaging the results over a time period for a unique group of students. There are three conversion algorithims for three...

Thanks, I'm on 2007 and my manual is right. I was trying to access data that is not on the report. I have it now, you're terriffic, thanks.

I am really greatful for the help. My SQL is a bit too long to put in the code, so I am going to try the Eval expression. I have a follow-up question on a related issue. My VBA Access manual says that the Load event of a report happens after the data is populated. I need to use the database...

I have developed a query to determine a student's class ranking for use while printing a transcript. The graduating year is a parameter. I currently have the criteria for the parameter set to a combo box in the form that executes the report, but I am getting an error. Here is my code...

Our application is a school gradebook whose primary data is classes and grades. A datum on each class record is "School Year" which is used to group and sort records for report cards and other reports. An offical transcript goes back 4 years, and this is tripping me up. A School Year is not...

I maintain a distributed application developed on Windows Vista and Access 2007. I recently had to re-install access and re-download the developer solutions. Now, when I make a packaged solution CD, the disk will not auto load. This is machine independent, it won't auto load on any machine...

Thanks - works like a charm.

I regret bringing this up again, but having read many threads on this issue, I still can't crack it. I have a form "Logon" in which I declare a variable in the general declarations section: Option Explicit Public strAccess As String Logon opens Form2 and closes. This code in Form2...

I recently downloaded Windows installer 4.5 on my Vista system. Now when I create a packaged solution with Access developer, the CD I create will not autorun. Has anyone run into this problem? Thanks

I am really grateful for the help on this issue. Pat's suggestion turned out to be on the money, although is an unexpected way. I have all the names right, but I do not have all of the levels in the syntax. The control I am trying to requery is a combo box in a sub-sub-sub form, in a...

Thanks very much for the reply and the link. As I read the reference, I believe it says that my syntax should be: Forms!Mainform!Subform1.Form!Subform2.Form!ControlName I am still having trouble. What I had was: Forms![Main Navigation]![Class Schedule Maintenance]![Class Schedule...

Thanks for your response. I have not been able to accomplish this, and again it is syntax. Here is what I have: Private Sub Class_Name_AfterUpdate() Forms![Main Navigation]![Class Schedule Maintenance]![Class Schedule Maintenance Subform]![ClassNameBox].Requery End Sub The error I get is...

Thanks for responding. Yes I have requeryed the snot out of that combo box, on entry, on exit, after update, on focus, on click - I would try "after Lunch" if it were there. I have also requeryed the subform the combo box is in, and the form that contains the subform in as many variations. I...