Search results

Thanks Pat. I tried that first, and only retrieved 1 row. The one student who has a grade for cs101, the other students do not yet have grades, hence the union join. I think the only solution is to insert into temp table the union query, allow the user to update the temp table. Then run an...

I can't update a union query, so what to do? build form/subforms, write some vba code to perform inserts/updates? I need help query pro's! I have a table Student: studentID LN FN cohort I have a table Grade: studentID course grade five students in the cohort. I am building a form which...

Thanks for the tips. I agree with the form corruption. I had a similar parameter form with two queries to populate the list boxes which appeared corrupt. I then renamed it to bad_xxxxxx and rebuilt the form. The form worked fine then. Until the other day. I then deleted the bad_xxxxx, ran...

No auto update process or recursion in my code. So that is okay. Just a simple: Form select student --> DoCmd.openform formWithsubform [studentid]=lbstudentselect I changed the form and subforms to use a query as the record source vs. the table. And everything appears to be working fine. WHY...

I tried various backup copies of the database to see when the error popped up. Hunting for what changed. The only thing I noticed is the selection form frmCollegeCourseSelect stays open and will not close, no error message, but remains open even though I closed the details form w/ subform. Is...

Marcelo- I have the same problem. What were your steps to resolve this issue? -stormin norm.

I have one form->subform which continues to produce the following error message when I attempt to exit the form: "You can't carry out this action at the present time" I checked all the forms for locking etc...but can not find what is causing this error message. HELP! What typically causes this...

Report using sql in VBA vs. query Before I go down this path, I want to get some input from some experts. In the queries discussion, I am seeking to create a parameter form which pulls up a base query and then creates a crosstab query for use in a report. the idea is: param frm->qry 4...

Can I reference a queries' column heading property from a form or VBA? Perhaps through command. or object. ??? -norm.

Rich- I tried using [Forms]!... as a parameter, but I then get an error message "you canceled the previous operation." I also tried to use parameters called "ClassSelect" and "SemesterSelect", but then get prompted for response, perhaps I can use VB code to push the fields into these parameters...

In the joined tables, the class is defined as text. In the query, I do not have explicit parameters. Simply have in the criteria for Class--> [Forms]![frmRptSemesterGrade]![txtClass] Again, works fine when the form opens the qryStudentGrade, but fails on the crosstab

Try this: Left (string,len(string)-2)

I have a parameter form with two fields txtClass and lbSemester. I then click a command button to run the qrySemesterGrades retrieving the set of students, course number, course name, grade, etc.. This works fine. I then run a crosstab query against the qrySemesterGrades results in order to...

It is important to view all the profiles on one screen, they are not large so they will fit. I just thought there would be an easy way of reuse of the same subform vs. having three different subforms tied to three different queries.

Looks like the only way is three seperate queries, and changing the subform recordsource. Any other ideas/comments?

OpenArgs sounds good, I just have to reference the parent open args when on the popup, to pass along the menu choice.

Is there a stack or method for finding out which object/form is the parent object/form? Lets say you have a main menu which opens a popup form, which then opens a form. It would be nice to use the same popup form, track which menu item opened it, and pass this information to the child form...

Good idea, but it won't look good on the screen. I guess the only thing to do is write a vba routine to get all courses, then for each course lookup for the student, and then print result. I was hoping I could do a union. Thanks.

I have a student table, class table, syllabus table, and grade table. They all must be linked to show the students grade on a form. Note: Each class has different syllabus (list of courses) so for Mary Jane, she may have a different list of courses. I can easily get the grades for the classes...

Main form has a listbox for custid once selected three subforms should populate with profile1, profile2, profile3. I do not wish to create three seperate subforms, simply re-use the same subform and filter as: subform1 filter profile=1 subform2 filter profile=2 subform3 filter profile=3...