Search results

Ok, great. That's what I did.

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

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

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

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

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

Thank you, sir!

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

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

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

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

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?

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

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

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

This is what I ended up coming up with: DoCmd.SetWarnings False DoCmd.RunSQL "DELETE tblFieldListPopulation.[Field Number] FROM tblFieldListPopulation" DoCmd.RunSQL "INSERT INTO tblFieldListPopulation ( [Field Number] ) SELECT tblFieldInformation.[Field Number] FROM tblFieldInformation"...

Here is what I've been thinking about, and fooling around with: DoCmd.SetWarnings False DoCmd.RunSQL "DELETE tblFieldListPopulation.[Field Number] FROM tblFieldListPopulation" 'To clear list. DoCmd.RunSQL "INSERT INTO tblFieldListPopulation ( [Field Number] ) SELECT tblFieldInformation.[Field...

Yeah, that example doesn't quite cut it for me. I think you understand the gist of what I am trying to do though. Perhaps I can run some append/delete queries on a separate table which would be used solely to populate the drop downs, but I know I'll be running into issues when a value needs to...

I've seen and read posts regarding filtering of combo boxes, but haven't seen one about filtering based on prior entries of that combo box... Let me explain: I have a subform in continuous view on my main form. The combo box in question is in the subform. I'd like to be able to eliminate...

Can the union query be written with SQL to make a recordset to loop through for calculations? Not sure I'll need to do this, but is it possible?