Return Description property of DB Objects.

G

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
 
C

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top