Vba – Measuring query processing time in Microsoft Access

I just tested this and it works in Access 2010.

Say you have a SELECT query with parameters:

PARAMETERS startID Long, endID Long;
SELECT Members.*
FROM Members
WHERE (((Members.memberID) Between [startID] And [endID]));

You run that query interactively and it prompts you for [startID] and [endID]. That works, so you save that query as [MemberSubset].

Now you create an UPDATE query based on that query:

UPDATE Members SET Members.age = [age]+1
WHERE (((Members.memberID) In (SELECT memberID FROM [MemberSubset])));

You run that query interactively and again you are prompted for [startID] and [endID] and it works well, so you save it as [MemberSubsetUpdate].

You can run [MemberSubsetUpdate] from VBA code by specifying [startID] and [endID] values as parameters to [MemberSubsetUpdate], even though they are actually parameters of [MemberSubset]. Those parameter values "trickle down" to where they are needed, and the query does work without human intervention:

Sub paramTest()
    Dim qdf As DAO.QueryDef
    Set qdf = CurrentDb.QueryDefs("MemberSubsetUpdate")
    qdf!startID = 1  ' specify
    qdf!endID = 2    '     parameters
    qdf.Execute
    Set qdf = Nothing
End Sub

The Objective-C Runtime Reference lists

Ivar class_getInstanceVariable(Class cls, const char * name)

which returns an opaque type representing an instance variable in a class. You then pass that to

id object_getIvar(id object, Ivar ivar)

to get the actual instance variable. So you could say

#import <objc/runtime.h>

id getInstanceVariable(id x, NSString * s)
{
    Ivar ivar = class_getInstanceVariable([x class], [s UTF8String]);
    return object_getIvar(x, ivar);
}

if the instance variable is an object. However, if the instance variable is not an object, call

Ivar object_getInstanceVariable(id obj, const char * name, void ** outValue)

passing in a pointer to a variable of the right type. For example, if the instance variable is an int,

int num;
object_getInstanceVariable(x, [s UTF8String], (void**)&num);

will set num to the value of the integer instance variable.