Retrieve Table Information

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alan - 01 Nov 2005 10:57 GMT

Is it possible to retrieve table attributes such as Modified Date and Created
Date to be displayed within a text box on a form ??

Many thanks in advance

Reply to this Message

Ofer - 01 Nov 2005 11:35 GMT

Try this

Me.TextBoxName=Application.CurrentDB.TableDefs("Insert Table
Name").DateCreated
Me.TextBoxName=Application.CurrentDB.TableDefs("Insert Table
Name").LastUpdated

You have more information you can retrieve, after the table name, when you
type the dot, youll get a list of attributes

Signature

If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck

> Is it possible to retrieve table attributes such as Modified Date and Created
> Date to be displayed within a text box on a form ??
>
> Many thanks in advance

Reply to this Message