Return Description property of DB Objects.

[Guest]

I have an access application where the reports and their underlying queries
change frequently, I'd like to build a push button solution to update these
databases. Is it possible to return the data in the descrition property of
database objects like queries, forms, reports, modules, etc.? (Right click on
a form, query, or report and select properties. That description field)

What I'm lookig for is a solution that would allow me to put a version in
that field and then build an object import routine to import newer vrsions of
database objects.

Any suggestions would be great!

VinceV

 

[Crystal]

Hi Vince,

here is for tables and queries

currentdb.TableDefs("Tablename").Properties("Description")
currentdb.QueryDefs("Queryname").Properties("Description")

Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access
strive4peace2006 at yahoo.com