[AccessD] How do I retrieve a form's LastModified date?

Dan Waters dwaters at usinternet.com
Mon Jun 2 12:39:52 CDT 2008


Hi Max,

Well - I still remember a few things.  I am using A2003 and it didn't work
for me about 6 weeks ago.  After I found the MS KB article, I stopped
trying.  

I'll try again!

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
Sent: Monday, June 02, 2008 10:50 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] How do I retrieve a form's LastModified date?

Hi Dan,
That may be the difference.  I am using A3k.

I am thinking of upgrading because my version is now 5 years old - why are
you still working with geriatrics. (smile).  Don't you know that as you get
older the mind gets more unreliable.  That is why....ummm....sorry, forgot
what I was saying...

Max


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
Sent: Monday, June 02, 2008 4:12 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] How do I retrieve a form's LastModified date?

Max,

Are you using Access 95 or 97?  It is supposed to work with those versions.

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
Sent: Monday, June 02, 2008 9:56 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] How do I retrieve a form's LastModified date?

Dan,
They are definitely different on  my computer.

Here is the  output which corresponds to what is shown in the database
window.


frmEvent      10/05/2008 08:10:29         13/05/2008 17:32:13 


Max
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
Sent: Monday, June 02, 2008 2:51 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] How do I retrieve a form's LastModified date?

This is what I did try.  The .DateCreated and .DateModified both give the
Created Date.

There is also another VBA method using Containers, but the result is the
same.

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
Sent: Monday, June 02, 2008 8:27 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] How do I retrieve a form's LastModified date?

You could mess around with the AllForms properties.  Something like this:-

Function frmProperties()
  Dim obj As AccessObject, dbs As Object
  Set dbs = Application.CurrentProject
  For Each obj In dbs.AllForms
    If obj.Name = "frmEvent" Then ' or If obj.IsLoaded = True Then
      Debug.Print obj.Name, obj.DateCreated, obj.DateModified
    End If
  Next obj
End Function

This will extract the modified date and other items.

Max
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
Sent: Monday, June 02, 2008 1:33 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] How do I retrieve a form's LastModified date?

Bob - I tried to find this out as well.  I finally found a MS KB article
which said that since A2000, you cannot get the date last modified
programmatically due to the database structure change at that time.  The
only way to find out the date is to just look at the database window.

There is VBA code to get the last modified date, but the date it returns is
the created date, which isn't helpful.

HTH,
Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bob Gajewski
Sent: Monday, June 02, 2008 7:03 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] How do I retrieve a form's LastModified date?

Hello Friends

I need to check the last modified date/time on a form. I suspect that this
is only possible through an API call, which is something I know NOTHING
about.

Could someone please help me or point me to a resource that I can learn
from?

Regards,
Bob Gajewski

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list