Re: Last Modified Date

You're right. Shouldn't have doubted you.

Odd though, with Forms Reports & Modules the dates are changed, but not
tables or queries. Any idea of the logic of that

Phil

"MGFoster" <me@xxxxxxxxxxx> wrote in message
news:34SdnTGA_Ym3SNfXnZ2dnUVZ_g5i4p2d@xxxxxxxxxxxxxxxx
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

No, only if the design is changed.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBSkrVT4echKqOuFEgEQJDwgCg++UWTvaHf5ldHsl79hrOlzKcZmUAoPoV
SxkbV6lwoIXjH6HglqtxJ9Ov
=t2qo
-----END PGP SIGNATURE-----

Phil Stanton wrote:
Doesn't a compact change the date?

Phil

"MGFoster" <me@xxxxxxxxxxx> wrote in message
news:Uf-dnQ631rdBxNfXnZ2dnUVZ_hhi4p2d@xxxxxxxxxxxxxxxx
koturtle wrote:
I need to display the last time a table was modified (design changes)
on a form.
I don't care about data changes but only the modified date that shows
in the main database window.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Like this in an .mdb file:

strLastMod = currentdb.TableDefs("table_name").Properties("LastUpdated")

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBSkpaAIechKqOuFEgEQInPQCgi9D4xg/BhVh+TVZ86BvpvaQeY94An0b3
/KggPMVcn+JRGtU/4lzcV922
=Ro88
-----END PGP SIGNATURE-----


.

Relevant Pages