enumerating objects

[Mark]

How do I refer to and compare objects in one database with those in another?
For example:

FOR EACH object in db1 with the same name and object type IN db2 THEN
'do something here

Thank you.
Mark

(p.s, I can't use just the object name since, in a moment of dumbness, I may
have given a form and a query, e.g., the same name)

 

[Guest]

Even if the names for objects are the same this will not affect your comparison. As long as you give VBA the object type EG Forms! or tables!, it woun't try and reference them as a single object

 

[Tim Ferguson]

How do I refer to and compare objects in one database with those in
another? For example:

Use the Containers and Documents objects... documented in help files.


Tim F

 

[Mark]

Thanks for your help, Tim

Use the Containers and Documents objects... documented in help files.


Tim F

 

[Mark]

Thank you Russell. I was hoping there was a way to do this without
specifically referencing in the code each type of object.
Mark

Even if the names for objects are the same this will not affect your

comparison. As long as you give VBA the object type EG Forms! or tables!, it
woun't try and reference them as a single object.