Table created date

[John]

Is there anyway to refer to an object's (e.g., a table) created date in
VB? The reason is I need to see the data set's "date effective", which
for me would be the date the table was created. I don't want a field in
the actual table tho.

Thanks...

[pietlinden]

John wrote:

Is there anyway to refer to an object's (e.g., a table) created date in VB? The reason is I need to see the data set's "date effective", which for me would be the date the table was created. I don't want a field in the actual table tho.

Thanks...

Sure. Put it in the table and then just make a form that doesn't
contain that field. Table NAMES shouldn't store data, that's what
FIELDS are for. Besides, you could have information with different
effective dates, all lumped into one BIG table (the way it should be)
and then you can query/filter that.

[John]

I don't need a field in the table with the date because the table is
actually a "data dump". The table (object) "created date" serves
nicely as the "date effective"; therefore, I just need to know how to
refer to the table/object created date in code.

[Rob Parker]

You can get it using a dlookup on the MSysObjects table, thus:
=dlookup("DateCreate","MSysObjects","Name = 'tblName'")

The MSysObjects is a system object, and is not normally visible; you can see
it if you check the appropriate option in Tools|Options|View. However (at
least in A97) the table does not need to be visible for the dlookup to work.

Rob

"John" <so*********@hotmail.com> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.com...

Is there anyway to refer to an object's (e.g., a table) created date in
VB? The reason is I need to see the data set's "date effective", which
for me would be the date the table was created. I don't want a field in
the actual table tho.

Thanks...

[Mark]

Hi All,
I use Tony's Auto FE updater to keep the frontend current. Because of
this, I don't need to go round setting it up for users as they all know of
the Shortcut on the network drive. By default, the "Windows in taskbar"
option in Tools - Options - View is checked. I have a form set to open as
invisible when the database is open which is combined with users having
several other forms open at the same time. This equates to quite a few
'Buttons' on the taskbar which need not be there. The users do not have the
toolbars to disable this themselves so I was wandering if there's a way I
can code this into the startup form?

Any help would me much appreciated.

Mark

"John" <so*********@hotmail.com> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.com...

Is there anyway to refer to an object's (e.g., a table) created date in
VB? The reason is I need to see the data set's "date effective", which
for me would be the date the table was created. I don't want a field in
the actual table tho.

Thanks...