enumerating objects

  • Thread starter Thread starter Mark
  • Start date Start date
M

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)
 
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
 
How do I refer to and compare objects in one database with those in
another? For example:
Click to expand...

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


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

Russell Lucas said:
Even if the names for objects are the same this will not affect your
Click to expand...
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.
 
Back
Top