Object References

[raskew]

Hi -

Is there an object reference delineating whether an 'object' (and I may be using the term incorrectly) is a table, query, form, report?

I'm attempting to develop a command button that when clicked, would open an object (table, query, form, report) specified in a table (probably an [ObjectName], [ObjectType]) in somewhat the same way that you can have a hyperlink field that, when clicked, opens that particular hyperlink.

Your help appreciated. -- Bob

 

[boblarson]

Hi -

Is there an object reference delineating whether an 'object' (and I may be using the term incorrectly) is a table, query, form, report?

I'm attempting to develop a command button that when clicked, would open an object (table, query, form, report) specified in a table (probably an [ObjectName], [ObjectType]) in somewhat the same way that you can have a hyperlink field that, when clicked, opens that particular hyperlink.

Your help appreciated. -- Bob

Bob -

There's an object type in the MsysObjects table. It also has the name of the object in the NAME field.

 

[Banana]

In similar vein to Bob's suggestion, mvps.org/access has some sample queries for getting all object names.

Alternatively, you can use AccessObject's Type property and AcObjectType Enumeration to interrogate a given object's type.

 

[raskew]

Bob / Banana -

Thanks so much. I must be having a real 'Duh-Huh' moment! I've used MSysObjects.Type probably hundreds of times, but it didn't click on me this time.

Thanks Again,

Bob

 

[boblarson]

Bob / Banana -

Thanks so much. I must be having a real 'Duh-Huh' moment! I've used MSysObjects.Type probably hundreds of times, but it didn't click on me this time.

Thanks Again,

Bob

No problem - I've been having moments like that more frequently myself.