Search results

I am trying to run a parameter query to return results where one of the fields (TotalHours) is greater than or equal to the parameter. If I run the query without the parameter, it gives the expected values, but when I run it with the parameter, it is returning only some of the records, but they...

TRANSFORM Count(qryDemogForCrosstab.StudentID) AS CountOfStudentID SELECT qryDemogForCrosstab.Classification, Count(qryDemogForCrosstab.StudentID) AS [Total Of StudentID] FROM qryDemogForCrosstab GROUP BY qryDemogForCrosstab.Classification PIVOT qryDemogForCrosstab.AgeGroup; Result is...

Galaxiom, Can you point me to a reference that would show me how to populate the list box with a recordset and sort it? I am pretty new to VBA so need some guidance. Thanks.

Yes, I should have made that clear; I needed the query to be able to add new records to its underlying table via form.

When I save a version of your db to my computer (to remove the read-only provision), your query is not updateable either.

Found the problem: I added tblTesting.TestTypeID to the query, and now it is updateable. I did not see the error listed in the status bar before: "Cannot add record(s); join key of table 'tblTesting' not in recordset."

Query: SELECT tblTesting.TestID, tblTesting.StudentID, tblTesting.TestDate, tblTestType.TestType, tblTesting.Form, tblTesting.SS, tblTesting.GE, tblTesting.NextForm, tblTesting.Memo FROM tblTestType INNER JOIN tblTesting ON tblTestType.TestTypeID = tblTesting.TestTypeID ORDER BY...

Yep, that was the problem. My subform CONTROL did not have the same name as my subform. (Not sure how/why Access named the control differently from the name of the subform, but anyway). So now all works well thanks to Nautical Gent & sneuberg!! The take-away here is: make sure you know the name...

I tried Private Sub Form_AfterUpdate() Forms!frmPair!sbfPairHoursSinceLastTest.Form.Requery End Subbut am getting error "Microsoft Access can't find the field 'sbfPairHoursSinceLastTest' referred to in your expression. The main form is frmPair, the subform I want requeried is...

I didn't post the code because I had tried several different things, none of which worked. The latest iteration (in the AfterUpdate event of sbf1): Private Sub Form_AfterUpdate() Me.sbfPairHoursSinceLastTest.Form.Requery End Sub throws error "Method or data member not found".

I have a form with two subforms (sbf1 and sbf2). Sbf1 has two purposes (1) to show each record of tutoring hours by date and (2) act as a data entry form for new tutoring hours. Both sbf1 and sbf2 are linked to the main form by StudentID. sbf2 is a form that displays the total tutoring hours...

Because I'm not as good at this as you are :p That definitely works; thanks! I'm still curious to know, though, why a query that runs without a criterion asks for a parameter entry when you add a criterion. :banghead:

I am trying to determine which StudentIDs are enrolled in the current academic year. qryCurrentAcademicYr compares today's date with the start/end dates of the academic year and returns a text string, ex. 2016-17 . I have a query (which I "wrote" in the Query Design window) to compare a...

Hi Steve, I have attached a stripped-down version of the db with StudentIDs standing in for StudentNames for privacy. The VBA code from the aforementioned MS site does work, but it has a few quirks that need fixing. 1)When you try to move a single record from one box to another (in either...

To do the "pick box" part, I came across this after I got your reply: How to use AddItem and RemoveItem to move selections from one list box to another: https://support.microsoft.com/en-us/kb/278378 and I got it to work, miraculously (although when I tried to do the exact example...

Relevant tables/queries to the form I'm trying to make: qryStudentsExtended (StudentID, StudentName, many other fields) on tblStudents (StudentID (PK)) tblAcademicYr (AcademicYr (PK), StartDate, EndDate) tblClasses (ClassID (PK), Class) tblClassAssignment (AssignmentID (PK), StudentID (FK)...

I am trying to set up a form to append class assignment records to a tblClassAssignment (Assignment ID (PK), StudentID, ClassID, AcademicYr). I have a cbo on form to choose the class, and another to choose the academic year. I want to have the list of current students drop down for the data...

Thanks for your really useful reply. There's a lot of good stuff in the ambysoft essay and in your post as well.

I do already have code that changes the background color of the form and shows a text box in the footer saying that the form has been changed, and how to proceed or undo the change. I guess if I already have the code for the form, I could do it with the controls instead, although this form has a...

I like this idea, because there are going to be times where the entry operator will need to view a record and not change it; for example, when he/she checks to see if a student is "new" or already in the database. I am such a beginner with VBA that it will take me a while to write the code, but...