Hi friends,

I am converting an access 97 database to access 2000.
I have a problem in it.
in access 97 the properties of the forms were available throught the document object.
but in access 2k i could not find a way to retrieve the properties of the form. I need DateModified and DateCreated properties of the form

These properties are available in acess 2002.

looking forward to your help.

Thanking you,
Viral

Is it possible that you simply didn't set a reference to the DAO object library (which includes the Document object) in your 2k db. DAO is the default MDAC library in 97, ADO is the default MDAC library in 2K. ADO doesn't have a document object, so the DAO reference needs to be set manually.

Bob

thanks a lot for your reply Bob. but the problem is that we do not need to use DAO in our project.
is it possible retrieving those properties without using document object of DAO

Hi Viral,

I can't remember if the AccessObject object was a programmability enhancement with A2K or A2K2, but it should give you waht you need. The following loops through your project's Forms collection, printing the date created and date modified of each form:

Sub FormProperties()

    Dim objForm As AccessObject

    For Each objForm In CurrentProject.AllForms
        With objForm
            Debug.Print .Name & " - Created " & .DateCreated _
                & " - Modified " & .DateModified
        End With
    Next objForm

End Sub

Output:

Form1 - Created 2/16/2005 7:21:39 PM - Modified 2/16/2005 7:21:40 PM
Form2 - Created 2/16/2005 7:21:50 PM - Modified 2/16/2005 7:21:50 PM

HTH,

Bob

If my previous post turns out to be A2K2 stuff (and I have a hunch it might be), you can query the MSysObject system table for object properties in any version of Access. To get the Form properties you need from the system table, run:

SELECT Name, DateCreate, DateUpdate
FROM MsysObjects
WHERE (((Left$([Name],1))<>"~") AND ((MsysObjects.Type)=-32768))
ORDER BY MsysObjects.Name;

HTH,

Bob

hi bob,

thanks a lot for your help. your suggestions were very useful.
sorry, i m just discussing off topic..
can u tell me where r u from . r u a programmer?
i m from india

Thanks...
bye