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

Report to List All Objects Modifieds After Spec Date/time

P: n/a
For the 2 weeks or so, I need to keep one mdb, in which I am working on a
project, in sync with another mdb in which I need to make ongoing changes.
At the end, I will take out the old mdb and install the new one, so the new
mdb will contain the new project, plus all of the ongoing changes made to
the old mdb.

I would like to make a report which lists all forms, queries, etc modified
after a particular data and time.

1. As an example, what would be the syntax to show the modification date
and time of a given form, say "MyForm" in the immediate window?

2. Is there a collection I can use for forms, queries, reports, and
modules, where I can loop thru each object and test its modification date
and time? Something like Application.Query(1).ModificationTime?

Many thanks
Mike Thomas


Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Try a query like this:

SELECT MSysObjects.Name, MSysObjects.Type, MSysObjects.DateUpdate
FROM MSysObjects
WHERE Not ((MSysObjects.Name Like "~*") Or (MSysObjects.Name Like "MSys*"))
ORDER BY MSysObjects.DateUpdate DESC;

Access 97 maintained these dates well. Can't promise it will be satisfactory
in more recent versions, or survive compacting, but it's the best you've
got.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Mike Thomas" <mi**@ease.com> wrote in message
news:PI******************@newssvr31.news.prodigy.c om...
For the 2 weeks or so, I need to keep one mdb, in which I am working on a
project, in sync with another mdb in which I need to make ongoing changes. At the end, I will take out the old mdb and install the new one, so the new mdb will contain the new project, plus all of the ongoing changes made to
the old mdb.

I would like to make a report which lists all forms, queries, etc modified
after a particular data and time.

1. As an example, what would be the syntax to show the modification date
and time of a given form, say "MyForm" in the immediate window?

2. Is there a collection I can use for forms, queries, reports, and
modules, where I can loop thru each object and test its modification date
and time? Something like Application.Query(1).ModificationTime?

Many thanks
Mike Thomas

Nov 13 '05 #2

P: n/a
Thanks Allen,

You are right - they won't survive compacting, so I have to work around that
issue, but as you say, its the best there is.

IMHO it's one of the disadvantages of the Access "one big file" approach.

Many thanks
Mike Thomas
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:40**********************@freenews.iinet.net.a u...
Try a query like this:

SELECT MSysObjects.Name, MSysObjects.Type, MSysObjects.DateUpdate
FROM MSysObjects
WHERE Not ((MSysObjects.Name Like "~*") Or (MSysObjects.Name Like "MSys*")) ORDER BY MSysObjects.DateUpdate DESC;

Access 97 maintained these dates well. Can't promise it will be satisfactory in more recent versions, or survive compacting, but it's the best you've
got.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Mike Thomas" <mi**@ease.com> wrote in message
news:PI******************@newssvr31.news.prodigy.c om...
For the 2 weeks or so, I need to keep one mdb, in which I am working on a project, in sync with another mdb in which I need to make ongoing

changes.
At the end, I will take out the old mdb and install the new one, so the

new
mdb will contain the new project, plus all of the ongoing changes made to the old mdb.

I would like to make a report which lists all forms, queries, etc modified after a particular data and time.

1. As an example, what would be the syntax to show the modification date and time of a given form, say "MyForm" in the immediate window?

2. Is there a collection I can use for forms, queries, reports, and
modules, where I can loop thru each object and test its modification date and time? Something like Application.Query(1).ModificationTime?

Many thanks
Mike Thomas


Nov 13 '05 #3

P: n/a
I'll have to go back to square 1 one this one - MSysObjects.DataUpdate is
showing an incorrect date - it does not even agree with what is showing in
the 'modified' column in the data base window (which is correct as long as
the mdb has not been compacted).

Mike Thomas

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:40**********************@freenews.iinet.net.a u...
Try a query like this:

SELECT MSysObjects.Name, MSysObjects.Type, MSysObjects.DateUpdate
FROM MSysObjects
WHERE Not ((MSysObjects.Name Like "~*") Or (MSysObjects.Name Like "MSys*")) ORDER BY MSysObjects.DateUpdate DESC;

Access 97 maintained these dates well. Can't promise it will be satisfactory in more recent versions, or survive compacting, but it's the best you've
got.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Mike Thomas" <mi**@ease.com> wrote in message
news:PI******************@newssvr31.news.prodigy.c om...
For the 2 weeks or so, I need to keep one mdb, in which I am working on a project, in sync with another mdb in which I need to make ongoing

changes.
At the end, I will take out the old mdb and install the new one, so the

new
mdb will contain the new project, plus all of the ongoing changes made to the old mdb.

I would like to make a report which lists all forms, queries, etc modified after a particular data and time.

1. As an example, what would be the syntax to show the modification date and time of a given form, say "MyForm" in the immediate window?

2. Is there a collection I can use for forms, queries, reports, and
modules, where I can loop thru each object and test its modification date and time? Something like Application.Query(1).ModificationTime?

Many thanks
Mike Thomas


Nov 13 '05 #4

P: n/a
"Mike Thomas" <mi**@ease.com> wrote:
You are right - they won't survive compacting, so I have to work around that
issue, but as you say, its the best there is.

IMHO it's one of the disadvantages of the Access "one big file" approach.


INMNSHO this is a bug on MSs part. They should've have reset that date when
compacting. Preferably not importing either.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.