Search results

To make clear what I am after in THIS specific case - I am capturing the KeyDown and KeyUp events. I am using a function, because I have a huge number of controls on the form - several hundred. (It's a matrix, so please don't give me a hard time about my form being too complicated - it's not.) I...

Yes, there are all sorts of other possibilities. Thank you for your response, but I am not looking for other ways to achieve this. I am specifically trying to find out what values are available that can used in the scenario I described. ActiveControl is clearly one. I would like to know all the...

Thank you, but ActiveControl.Name was just an example. I know I don't always NEED to pass a parameter - sometimes there are other ways to do it. But the point is, sometimes I WANT to pass a parameter, and I would like to know what all values are available to be passed. That was what I was asking.

I've had to deal with this in using foreign characters, and it has led to some weird and frustrating behavior. I learned long ago to stick with VERY strict naming - the 26 Latin letters and numerals. NOTHING else, ever.

When I want an event to call a function rather than the standard 'Event Procedure', I use the syntax =MyFunction(Param1; Param2;...) in the box for that event. I sometimes want to pass my own constants, but sometimes I'd like to pass some information from the form, like...

All right, now you're just babbling. I'm out.

I don't claim there is anything wrong with it. Not one comment have I made anywhere that is critical of his work. What makes you think I believe that? I'm simply telling you what *-I-* did.

I also wrote in a subsequent post that I went to the last record. I used the navigation buttons on the bottom of the query's display, although I did not specify how I did it. It did not seem relevant, and I wasn't expecting to open such a detailed debate on the topic. But since you ask, that is...

It does, thank you, and it appears to be the exact same problem as I encountered, in a most similar arrangement - a central class for events, form/subform construct raising events, and complete disassociation of objects raising events from objects reacting to events. Setting the WithEvents...

Well, I described exactly what I did, way back in #7. Opened a query, once with my expression, once calling a VBA function to do the exact same thing as the expression. The expression was fast, the VBA function slow. I don't know what more you think I can add to that.

True - it would be more a reason to not use it.

What do you mean, 'not an argument'? Just that you don't care about the speed?

Nope, that wasn't it either. Commented out the line setting the WithEvents variable to nothing, just to confirm the problem still exists. It does. But even when I release the global variable pointing to each subform directly in the subform's Close event, this unwanted accumulation of instances...

I guess that makes a certain amount of sense, but I did release the variables. Although, now that I think about it, I release them in the parent form's Close event. I wonder if I need to release them directly in the subform. Maybe letting the subform close while the variable still points to it...

Nope - that wasn't it. I have global variable pointers to the parent form and each subform, set in each of the form/subform's Load events, and I explicity set all three to nothing in the Close event of the parent form. But despite that, this multiple instancing of the WithEvents variable was...

If you put the expression I showed you directly into the SQL statement the defines the recordset, you can then open it, go to the last record via the .MoveLast command and measure the time. But the OP wanted an expression that would go directly into a query, without any VBA involvement, so that...

I don't know what you mean by that - I'm not going to mail you my computer. The 'complete test environment' is an Access database, nothing more. You can easily make a blank one yourself, create a table, load it with the sorts of strings the OP described and make your own tests. If you do it with...

If you're doing it in a loop, that means you're doing it in VBA, which complete negates the point of having JUST AN EXPRESSION in a query. Yes, your results are not at all surprising. You are in VBA, and you are adding the overhead of calling JET to your already slow VBA. The way to do it, which...

The first few show up quickly. Getting to the end (having to call the VBA function for every record) took a long time.

I did not use a RegEx for this simple test - just the VBA version of the Mid and Instr functions, so I did not even have the overhead of the RegEx machinery. Even the bare-bones VBA functions were vastly slower than pure JET. Just having to call VBA code, even when it does almost nothing, is...