Search results

  1. stormin_norm

    Can update on Union query

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

    Can update on Union query

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

    error: you can't carry out this action at the present time

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

    error: you can't carry out this action at the present time

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

    error: you can't carry out this action at the present time

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

    You can't carry out this action message

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

    error: you can't carry out this action at the present time

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

    Report using sql in VAB vs. query

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

    crosstab fails w/ form parameters Jet error

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

    crosstab fails w/ form parameters Jet error

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

    crosstab fails w/ form parameters Jet error

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

    Trimming a string of text

    Try this: Left (string,len(string)-2)
  13. stormin_norm

    crosstab fails w/ form parameters Jet error

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

    use same subform 3x on form

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

    use same subform 3x on form

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

    which form/obj instatiated me?

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

    which form/obj instatiated me?

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

    union query or other way?

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

    union query or other way?

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

    use same subform 3x on form

    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...
Back
Top Bottom