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

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

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

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 have 5 tables that i need to use in cascading field format so each narrows down the selection of the next table/field choices. The tables are set up to filter downward thus: School to Session to Grade to CoreComponent to ActivityName and Desc SchoolName 1, 2, 3, 4, 5, 6, 7 and 8...

I have been moving my information onto Tabs to concentrate the "type" of information in one place rather than having one very long form. On the Main Form-Contact Info tab there is an Address button (and below that a datasheet display only subform). The cmdbutton opens the Address form...

I have a table/form [tblStdAdv]\ [frmStdAdv] that contains all advisers a student had during their program. that form pulls from refAdv which has: Type 1- initial 2- current 3- previous and then an Adviser field, per record I need to pull the adviser onto the student's main page...

I have two forms - Main and StudentAdvisor (filtered by student ID#) The main form originally had a combo box field to display advisor, the problem is that some students had multiple advisors during the course of their program. This problem was fixed by the creation of a StudentAdvisor...

is this even possible and if yes how do you write a report (or query for the report) to do: 201030 = 1 spring semester 201050 = 1 summer semester 201070 = 1 fall semester so then attendance from 201030 till 201230 = 7 semesters and also going the other way so 201230 - 201030 = 7...

The main report is filled by a query with a parameter of (Between [T1] and [T2]) The detail section is hidden as I don't need this information showing but use it to generate the required numbers. The subreport is located in the footer and is filled by a query based off the main report query...

I have a field, Grad Term, that is set up with the Year/Semester: 201330 (spring), 201350 (summer), and 201370 Fall I have a query that pulls the information i need into a report (student, total etc) by term SELECT tblStudentInformation.[790ID], [LastName] & ", " & [FirstName] AS Name...

Form Background: I have a Single Form (necessary due to a Cascading Combo Box series) with a subForm datasheet. I enter the information into the Single Form (CourseTaken) and use a query to pull all related information into the DataSheet (CourseSummary) thereby mocking a split form. the two...

I have a main form (LOA-ReAdmit) containing two subforms (LOA and ReAdmit) and each subform contains a subdatasheet form. The subforms and the subdata form work like they should when you select an id hyperlink in the subdataform to fill the subform when only the LOA or ReAdmit form are open...

I have been working on a subform within a subform on a form. I have used this same subform directly on form and it works, but using it as a third layer is causing problems. It works but will not display all records only the first record entered. All records are displayed in the TribalInfo...

I have three tables the tblStudentInfo (holding the persons main data), the tblEducation (holding the students education records) and the refInstution (holding all university's and college information) I am pulling PersonID, name, etc from the tblStudentInfo, education records from...

I have a main form and a subform. The main form displays the information as combo box = column.2 (in other words it shows the actual word not recordid y/n checkbox = obviously shows which is checked however the subform shows combobox = 1 or 2 etc the recordid y/n check box 1 for...

the fields being used are: Course Type 1=Core, 2=Elective, 3=Non-degree and 4=Transferred Course Status completed, withdrew, incomplete Fields in use by query: UnitCoreTotal, UnitElectiveTotal, and UnitTotal Unit Core works with: SELECT Sum(tblCourseTaken.Units) AS...

I need to separate the units into type and then program total. this will allow me to know which type of course is missing at a glance. I have four unbound field ReqUnit, CoreUnit, ContentUnit, TotalUnit for query input. Drawing from these field. Field 1 = cboCourseType (Required, Core...