Hello,
Does there exist a function which when passed an access object gives its type in acObjectType format i.e. 2 for form, 3 for report and so on.
I need to find and saves object type in a table but couldn't find any such function. Before, the same was being performed by macro using screen. ActiveObject and when I converted this into VBA, screen.ActiveObject always gives me object type as table even when the code was run from a form (same form which had the macro and now converted VBA). So now I am in search of a built-in function of way to write a function which when passed an object, for instance
Best Regards
Abdullah
Does there exist a function which when passed an access object gives its type in acObjectType format i.e. 2 for form, 3 for report and so on.
I need to find and saves object type in a table but couldn't find any such function. Before, the same was being performed by macro using screen. ActiveObject and when I converted this into VBA, screen.ActiveObject always gives me object type as table even when the code was run from a form (same form which had the macro and now converted VBA). So now I am in search of a built-in function of way to write a function which when passed an object, for instance
gfGetObjectType(mObj as Object) as acObjectType
Best Regards
Abdullah