Search results

I have a button on a form that opens and generates an attendance sheet report. That is working fine but I also need it to filter the list of names on the report to just the form for a specific activity (ActivityID) that is displaying when you click the button instead of all names for all...

Basically i have 2 main forms StudentInformation and ActivityInformation (not sure if tabs are considered main/sub where the two fields are above the subdatasheet-subactivitystudentpage) you select an activity to enroll a student in: the subform on the studentinfo (tab Activity Enrollment) as...

Re: Problems Filtering a subform [FIXED] to make an entry in subform1 (student info main form / activity enrollment subform) fill to subform2 (activity info main form / activity attendance subform) Ensure "ActivityID" is in both main form tables and link via relationships Enter "ActivityID"...

Glitch between main and subform filtering This is all working nicely: First I create the activities for the semester in the Activity Entry form And create the Participant record (if not already in the system) I then enroll each participant in activities for the semester. When you create a...

I forgot to say that information is being pulled with a query so when i try and put in two column widths i get an error.

How do you get a subform to show data words instead of the numbers for the combo box it represents.

I have a table that contains all the information for an activity. On the form enter the first four fields and have it filter table to narrow down the selection for Activity Name that meets the criteria entered in the first four fields. form has field names: cboSchoolID cboSessionID...

I think I was going about it wrong. I re-set the form so the first four fields (school, session, grade and core comp) was pulling from their respect reference tables and the made a query in just the ActivityName field to sort through the information in the School Activity table. But its not...

I was attempting to make a table that you entered the information into (like product or maybe order a or like the combination country/state/city) where you updated the information for the semester and them pulled it into the individual records according the the activity they took. does that...

Thank you so much. It may not be pulling correctly from the table but hopefully i can figure it out ... at least its pulling information now!

I changed as suggested from refSession to refSchoolActivities SELECT refSchoolActivity.SessionID, refSchoolActivity.Session FROM refSchoolActivity WHERE (((refSchoolActivity.[SessionID])=[Forms]![frmActivityTaken]![SchoolID])) ORDER BY refSchoolActivity.[SessionID]...

Can not get the cascading fields to work. When you select the Activity Taken cmdButton and then on School select "Lowell" you should have three Sessions (per the refSchoolActivity table) "CS Porter" should give you three and so should "Big Sky" and then narrow down to the Grade, component and...

I am extremely lost by what you are saying. i have added in the student form and table (minimal data only but it does have the student ID number). I can get a query Activities Taken to pull the data the way i need and filter depending on the criteria entered from the Compiled table but not...

I do have the student table(s) but was trying to get the activities working right first. With the activity tables filled with test data I tried out queries to make sure it was pulling correctly, i still have to enter the coding for the fields and ensure that it filters correctly. After a...

MarkK I think I figured out what you were saying, is this what you were think for the setup of the tables and linking? Then the cascading fields would all come off the SchoolActivity table correct? After studying your remarks and demo of the table setup above it finally sank in with the...

Yes there is more to the database but i removed it to just show the activity tables and forms. Each PARENT record is based off of the student and all records such as activities are tied together via studentID #. this database is for an after school program and is used by eight schools from...

How do you set up the tables and code so that there is no repeating over and over like in my jpeg "Multi" Its hard as three tables (ProgGrade, CoreComp and Term/Session) are not Unique entries. I am lost here :banghead: The student is the main record and the activity comes off that (but i...

I know whats needed but not how to code it so as not to have to repeat multiple times the tables for grade, component, and term (see single - multi jpeg above). Is there another way to set up the table to avoid the repeats (per multi) or a way to code as so to not have to repeat. That is what...

The school has to be the parent in this case, all of the programs (all 8 schools) use the same database and the coordinator for each school enters the participants from their school for each grade/component and then activity. They track each participant as they go through the grades (changing...

The purpose is for an after school and summer program that offer different activities (different ones are offered each term but repeat year to year and are different per grade level) in each of the core component areas. Below i did switch the order of filter to make more sense There are...