Search results

There is something in the Parent. That form is a Datasheet and the buttons to call the Child are on each row. Seems it is not recognizing the specific row in the Parent to pick from in the Child... Or maybe not. The 3 criteria being used should get me to the specific record in the Child

Thanks DB - as always. Something is still not working though. It is still not going to the correct Child record. I'm checking some obvious things....

All, Syntax problem somewhere. Any help is appreciated. In a button on the "Parent" form Macro I have the following, meant to open the "Child" Form to same record selected. I have this working with using one criteria t find the Child record, but combining the 3 fields is giving me trouble. The...

OK so if by extension the read only Union query makes the delete query read only I kinda get it, although again, I'm deleting FROM a totally separate table. I can work around this either way. Thanks for all the help

isladogs - thanks, but again, I'm not deleting FROM the union query. I'm deleting from an unrelated table, with the Union query used to ID the records to delete from the table. The union query is definitely read only

All - thanks very much for your input. I read all your notes and unless I misunderstood I'm still a bit confused.. The Union query in my DB identifies the records to be deleted FROM the other table. I'm not trying to delete form the union query itself or from a table that underlies the union...

Gasman - thanks, that worked. Unfortunately there is a second problem... The first DB I sent was after conversion of all underlying queries to tables, to make the diagnosis easier. When I plug your solution into my actual DB it does not, and I have isolated the problem to...

All, Someone that knows what they are doing can probably help in about 15 seconds. Attached is my DB with a delete query. Why is it not running? You will see the table relationships. I want 2 fields in the table [..._Tab] used to select the records in table [...Eeco] to delete. Any help is...

pbaldy - thanks for the response. Slightly different problem I think. There are 5 columns in the Forms' datasheet/table. One of the fields shows a numeric key (from the underlying query), but I'd rather show the text value of that key, which is in a separate table that I would only need to...

All, I have a form that references a considerable amount of data, so this is a question on response time and best practice. One of the fields in the Form requires a join to another table to enhance what is shown. Question is - do I do this join in the Form Data Record Source, or only within the...

DBGuy - thanks his worked great and yes I can see how to extend it to the other fields. One question that I'll ping you on offline - if I change the left side menu (that has the click event) to also be a subform it does not seem to work the same. Seems something in your code below would have...

All Thanks for any help with this. If I can get this first part I can apply it to a lot of other functions I need to build. In the attached DB there is a form [Recon_HoldErrorsEeco_Menu] with a subform [Recon_PositionErrors_SF]. There is a "Holdings Errors" menu on the left side with values...

DBGuy - worked perfect. thanks

Majp - thanks for the note. Im not sure of the best method either. The filters are working well now so I'm going to leave it until response time becomes a problem.

is there a way to make it open with no records showing? The real DB has millions of records and I dont want any results to show unless they are selected.

Again - really great. I copied everything in to my version and it works perfect. I may need to use this approach for a few other forms. It looks like I would just need to change the events in the filter references in each new form. Is that right? The mdlFilters&QueryUtilities seem non...

This is really great. Thanks so much for your time.

All - thanks for any help. I can't find this answer. I the attached DB - There is a form [Holdings_List] with 4 multiple combo boxes used to filter the table. I cannot figure out how to get them to all work "together". What I want is... 1) The form opens with no records showing 2) When the...

Thanks so much everyone - really helpful. I think I am good, but there is a second part to this that I'll reach out about. It may take a coder some time to get through - maybe a day here and there - so do any of you do any side (paid) work? I'd need some direct coding (to spec) and some time...

Awesome! That module name gave me the right Immediate result. Great tip. Now second step - to reference the function in the query. I used the Builder to find the select the Expression Value as below. That entered the formula in the Query Field, which I had to clean up to get it to look as it...