Search results

I'm not sure. I set a global reference to the subform in the main form's load event: Set gbl_frmAkces = Me Set gbl_frmPodrobnosti = gbl_frmAkces.sfPodrobnosti.Form and thereafter use the syntax: gbl_frmPodrobnosti.RecordsetClone gbl_frmPodrobnosti.RecordsetClone.NoMatch...

Unfortunately, that is not all. That is usually where it bombs, but that is only because it's the first step, in a series of things I want to do. But every reference to the Recordset object from there on throws this error.

That was my understanding, but it's not happening that way. So I also thought, but it is not working. Error 3420 - "Object invalid or no longer set." I do not understand how I can have a clone of something that doesn't exist. It is a recordset filled by a pass-through query calling a SQL...

I did. Once again, any reference to the actual Recordset object bombs, while a reference to the RecordsetClone object works properly. That includes my main problem, trying the get the RecordCount value. Recordset.RecordCount bombs, RecordsetClone.RecordCount works.

Yes, I can, WHEN the Recordset object works correctly. It does not, hence this post. Any reference to the actual Recordset object bombs, while a reference to the RecordsetClone object works properly. However, manipulating the RecordsetClone object does not change the displayed records of the...

Tried this a while back in AccessForums.net (https://www.accessforums.net/showthread.php?t=84803). Got several suggestions, but no solution or explanation, and the problem continues. ======================== I believe this has started since I switched to 365 - I don't recall it happening in...

I can give you one positive reference to the topic in general. My central point concept avoids the problem of combinatorial explosion, which yours suffers from. Multiple event raisers and bound event handlers very quickly becomes unwieldy...

Scoping is something that I know only superficially. But you may be right. I did not want to take a chainsaw to my DB to find the source of the problem, but it seems I may have to, if only to quiet the hornet's nest I have stirred up here.

I suppose you can assure me, but I don't see it. Specifically, I don't see it in G, L & G manuals, except in the one case that I mentioned, of a form reacting to control events on another form. No, I'm not too stubborn to listen – I have listened, very carefully. But you keep repeating your own...

Whew - that's a lot to take in. I'll have to study that a bit before I can respond in any sensible fashion, but thank you for the explanation.

I didn't claim you don't know what you're talking about. I only wrote that what I have seen from many other sources, including manuals from people I know to be knowledgeable state that separation of the sort I describe is the proper way to do such things. I do not know if I have all the details...

I don't know what to say to that. I have stopped and stepped the code, and what I described IS exactly what is happening, which is the reason for this post. Even stopped, both in the immediate window and examining code elements from the breakpoint, that is the status. If you tell me from a...

Hm. Well, I'm not an expert on this topic, but all the reading I've done suggests that your way of 10 object variables and 10 separate event handlers is exactly the wrong way to go about such work. Maybe I'm using the word encapsulation incorrectly, but the notion is the independence of...

Yes, but doing it as you describe, the calling form must know about EVERY POSSIBLE construct that may raise an event. Doing it my way, yes it is more complex, but the calling form need not know anything about how many other constructs are raising events. Your way, every time I add something that...

Sorry about the heiroglyphics - this runs on a machine with a Czech OS, and some of that language's special characters do not port.

Below is the entire routine. It is now outside the form, in a standard module, and works fine. Then enclosing With ZNForm is of course necessary when it is in a standard module. When I had it inside the main form, the With ZNForm construct was naturally not necessary. EXCEPT, that it didn't work...

Because then the calling from must know about the dialog form, violating encapsulation.

I'm kind of new to using custom events, so maybe I didn't explain it very well. Does my explanation to Doc man make it any clearer? You demo code works perfectly, of coure, but does it not violate the principle of encapsulation? The CallDialog form must know about the ChooseAnimal form, and...

Ok, sorry - I guess my description was not clear. I'll try again. Main form is open in single-record form view. Main form contains subform, in datasheet view, displaying records from an auxilliary table that are linked to the currently visible record in the main form. As main from moves from...

It's not a subform that is raising the event, it's a popup dialog form. The main form contains a subform, and what is filtered and displayed in that subform is what gets changed by code in the dialog form. I want the main form to requery the subform when it hears the news that the table from...