By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,327 Members | 1,805 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,327 IT Pros & Developers. It's quick & easy.

Table Description

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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


Nov 12 '05 #2

P: n/a
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

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.