Recent content by JGalletta

  1. JGalletta

    Grouping records: I'll explain.

    Ok, great. That's what I did.
  2. JGalletta

    Grouping records: I'll explain.

    This is the horrendous solution I came up with: DoCmd.SetWarnings False DoCmd.RunSQL "DELETE tblFieldPestOverThreshold.* FROM tblFieldPestOverThreshold" DoCmd.RunSQL "DELETE tblOverThresholdMap.* FROM tblOverThresholdMap" DoCmd.RunSQL "INSERT INTO tblFieldPestOverThreshold (...
  3. JGalletta

    Grouping records: I'll explain.

    Even if those fields are not in the table whose values are being concatenated?
  4. JGalletta

    Grouping records: I'll explain.

    This is what I tried at first: ConcatRelated("pestFound","tblFieldRecInfo","tblFieldRecInfo.JoinPK = " & tblFieldRecJoin.JoinPK) However, I made a query that builds a table I can use ConcatRelated() with based on Field Number. Everything is working now. Thanks. P.S. I know this is probably...
  5. JGalletta

    Grouping records: I'll explain.

    The original concatRelated was using JoinPK from the second table in this image to concatenate pestFound values in the third table. Can I concatenate values in the third table based on Field Number in the first table, all while making sure duplicate values don't get concatenated twice (in the...
  6. JGalletta

    Grouping records: I'll explain.

    Ugh.. I just realized that the database will have duplicate field values on occasion due to multiple users entering data for the same field. This creates an issue where the query (with the ConcatRelated function) returns the following: FieldList PestList Field1 Pest1, Pest2, Pest3...
  7. JGalletta

    Grouping records: I'll explain.

    Thank you, sir!
  8. JGalletta

    Grouping records: I'll explain.

    I have a query that gathers information from the tables in my database and returns something like this: Field Pest 1 Insect1 1 Insect2 1 Insect3 2 Insect1 2 Insect3 2 Insect4 Field and Pest are fields in two separate (but joined) tables. Field exists only once in its...
  9. JGalletta

    Delete query problem.

    Pat, will enabling cascade delete only allow deletion in the downward direction of a hierarchical structure? i.e. Deleting a record from the second tier of a hierarchy will only delete records in the third, fourth, fifth, ... tiers, and not the first tier? If so, that function will prove...
  10. JGalletta

    Delete query problem.

    What am I doing wrong here??? DoCmd.RunSQL "DELETE tblScoutingRecords.*, tblScoutingRecords.[Record Number], tblFieldRecJoin.*, tblFieldRecInfo.* FROM (tblScoutingRecords INNER JOIN tblFieldRecJoin ON tblScoutingRecords.[Record Number] = tblFieldRecJoin.[Record Number]) INNER JOIN...
  11. JGalletta

    Obtaining value of a control DLookUp vs...?

    Reading your post again, I think I know what you mean. This would occur in the recordsource of the second subform? I'm assuming you bring the desired table/field into the recordsource query for the subform and it will then show up in the existing fields list when in the design of the second...
  12. JGalletta

    Obtaining value of a control DLookUp vs...?

    Ok, that answers my question. Thanks, Pat. I didn't know referencing the control always referenced the first record. Can you describe in a little more detail how to join to the "lookup table" and use a recordset? Does this involve creating a DAO Recordset and navigating to the correct record?
  13. JGalletta

    Obtaining value of a control DLookUp vs...?

    Hello all, Thanks for all the help on other subjects and threads. Here is another interesting question: Is it possible to reference the value of a control in the current record of a subform that is in continuous view from another subform without using DLookUp to reference the value in the...
  14. JGalletta

    Form_Current() event executing twice.

    I'm doing the commenting now, and I'm getting somewhere (I just don't know where...). It seems to be an issue with editing another subform and returning back to the subform that triggers the event. The subform that triggers the event is frmFieldRecJoin, located in Child20 of the Main form. I...
  15. JGalletta

    Form_Current() event executing twice.

    I have an interesting issue where one of my subform's Current event is executing twice. Here is the event: Private Sub Form_Current() DoCmd.SetWarnings False DoCmd.RunSQL "DELETE tblFieldListPopulation.[Field Number] FROM tblFieldListPopulation" DoCmd.RunSQL "INSERT INTO...
Top Bottom