Search results

Extremely new to queries and still don't understand quite how they work, but I have a query that is almost working the way I would like. :banghead: SELECT StudentInformation.[790ID], StudentInformation.LastName, StudentInformation.FirstName, StudentInformation.DegreeType...

Unfortantly I think I am doing something wrong. I made a query and set it as the row source for the Description field SELECT Courses.CourseID, Courses.DepartmentID, Courses.CourseNo, Courses.CourseName FROM Courses WHERE (((Courses.DepartmentID) Like [Forms]![CourseTaken]![Program]))...

I have two combo boxes Program that has several programs (HHP, BMD, etc) and and Desc91 . I want the the selection in the Program field to filter the Desc to just display the selected type instead of a full list. The problem is that after filling in the complete record and selecting a new...

I don't know if this is possible but... right now everything is saving to "Course" but that is quickly going to fill and make a long selection list what I did was add "Program" field hoping to make the lists shorter and filter off the BMED and HHP ,etc (will add the other when this...

I did add it to the control source. I get #Name? instead of an age. I did look at that link which is where I got the formula for the control source.

I am attempting to calculate the age in years. I added the field to the form after I split the database into a Server/Client format. I am using 2010. I placed this into the Control field txtDOB = Date of birth (bound field) txtAge = Unbound (does not have a field in the table)...

Updating combo list after table open from hyperlink edit I have completed my database with the help of all you (YEAH - and thanks for all the help). My issue is that i have several "Add" hyperlinks that open a table in datasheet view to update the combo list if new information is required...

OK I get that, but where would you put it on the child record? AfterUpdate, OnDirty, etc.

So how would you go about making the font color change on the parent record cmdbutton if you enter a record on the child form? I have been working with the AddlAddress on Dirty with If Me.Form.Dirty Then Me.Form![StudentInformation]![cmdAddlAddr] = "Accent 2, Lighter 40%" End...

I am wondering if it is possible to make a cmdButton change color. I have the parent form [StudentInformation] with several command buttons to open the child records. I would like to be able to make a command button [AddlAddr] change color (say to green) when you enter a record on the...

Thank you boblarson. The calculation worked. Even though the field still shows on the split form it is not stored in the table and I can live with that (unless there is some way to make it not show except in the form section). Bryan thank you for the link to more info, I will read more on the...

So remove from the table and remove the control source from the field. Then where do I put the DSum statement? Sorry i'm not getting this. The book I have (Access 2010 In Depth) doesn't seem to cover this type of thing or I have not found it.

Your right I have no idea, I am still attempting to teach myself (painfully) how access works. That domain aggregate, how does it work. If I can base it to only display that works as I discoverd having it in the table made it show for every record which is not necessary.

I'm thinking I may need to remove the fields from the table and then add them to the form as an 'unbound' field with the control source being the query.

I have included a graphic of the CourseTaken form. It records several bits of information (and is also used for advising purposes) so there are several "CourseStatus" available. Whit i would like to do (but am unsure how) is take ONLY the courses that are completed and total them so you know...

No the form's record source is the CourseTaken table. I just need that field to either use the query to calculate the information or figure out how to make the field do so within the form/table itself.

I have a field that I need a calculation in. All records are based on the students 790# All fields are from the CourseTaken table. the Units and TotalCreditEarned (are numeric set) but each 790# can have multiple courses, and I need to total the units per 790# and "completed" status...

See graphic. 1. If I open the "Institutions" form from the list of forms (1 on graphic) then select the Edit command button, the table opens and allows editing. 2. If I use the "Add" command on the child form, it opens the "Institutions" form fine, but when you select the Edit command...

I have an Institutions form. If you open it by the form by selecting it from the list, the edit command button on the Institutions form works, it opens the table and allows you to edit the table. This way you can scroll through all the institutions using the arrow on the bottom. However, if...

Yeah! finally located the source using the documentor. in the ON CLICK macro for the button! the macro still had 790 ID. Thanks for all the help.