Last objects to be updated

[ryetee]

I want to know what the last set of objects to be updated are.
I know I can display objects in order of last modified but the results are limited in that it appears to display those recently modified, those modified with 2 weeks and those older. Unfortunately the changes were made just before lockdown last year and then forgotten about. I can right click every module and select properties which will give me last modified date but there are quite a few objects and I'm after saving time Is there a easier way?

 

[arnelgp]

a good programmer keeps a record (whether in paper) of
all object modified / created.
he has to be systematic.

 

[ryetee]

a good programmer keeps a record (whether in paper) of
all object modified / created.
he has to be systematic.

....and if he isn't and I have to pick up the mess?

 

[gemma-the-husky]

It is a real pita that access seems to update the last modified date of modules when you open the dbs. The date created is OK, but not the date modified. It makes it very hard to fund recent code changes.

@ryetee I don't think you are correct about the dates. I am sure they all show OK for me. Maybe you rebuilt or compacted and repaired, or something like that, which caused the dates to change. I am not saying a C&R does do that (in fact I am pretty sure it doesn't)- but something of that nature might cause the effect you noticed. Dropping and relinking linked tables definitely changes the modified date for the tables.

 

[ryetee]

Unfortunately I don't have that luxury but here's what I did.

It is a real pita that access seems to update the last modified date of modules when you open the dbs. The date created is OK, but not the date modified. It makes it very hard to fund recent code changes.

@ryetee I don't think you are correct about the dates. I am sure they all show OK for me. Maybe you rebuilt or compacted and repaired, or something like that, which caused the dates to change. I am not saying a C&R does do that (in fact I am pretty sure it doesn't)- but something of that nature might cause the effect you noticed. Dropping and relinking linked tables definitely changes the modified date for the tables.

I think you've misunderstood about the date. The properties date is correct but you have to look at each in turn or run a report and plough through the report which is what I'm doing now. The bit that would have been good would be to arrange the objects in last date modified. This works if you've amended something in the last few days but anything older gets group under one heading could older and then it's in alphabetical order.

 

[gemma-the-husky]

if you select queries (or any object type), you can then right click at the top where it says queries, and then there are various sort by options to sort the queries. You get every query in date order. There must be a different option where it shows you the different view, which you described. Selected full details, and you get the date included.

Having said that, I still preferred the A2003 view, and before that I preferred the A97 view.

The search bar is very useful, though.

 

[ryetee]

Thank you for all the replies.
In the end I used a query using MSysObjects which has last modified date and has allowed me to suss it out!