Table Description

[r0adhog]

Is there a way to set the control source of a Label to the Description of
the table that is the record source of the form on which the label resides?
Basically I need to know the code to get the Table Description.

Thanks in advance.

rh

[Rick Collard]

You can get a table's description using:

CurrentDb.Containers("Tables").Documents("MyTable" ).Properties
("Description")

You will need to include error trapping with this code. If the table
does not have a description you will get a runtime error. HTH

Rick Collard
www.msc-lims.com
On Fri, 30 Apr 2004 12:25:46 -0400, "r0adhog"
<ro*****@nospam.phreaker.net> wrote:

Is there a way to set the control source of a Label to the Description of
the table that is the record source of the form on which the label resides?
Basically I need to know the code to get the Table Description.

Thanks in advance.

rh

[r0adhog]

shaweeeet, works like champ, thank you much!

"Rick Collard" <no****@nospam.nospam> wrote in message
news:40****************@news.west.earthlink.net...

You can get a table's description using:

CurrentDb.Containers("Tables").Documents("MyTable" ).Properties
("Description")

You will need to include error trapping with this code. If the table
does not have a description you will get a runtime error. HTH

Rick Collard
www.msc-lims.com
On Fri, 30 Apr 2004 12:25:46 -0400, "r0adhog"
<ro*****@nospam.phreaker.net> wrote:

Is there a way to set the control source of a Label to the Description of
the table that is the record source of the form on which the label resides?Basically I need to know the code to get the Table Description.

Thanks in advance.

rh