Last time form design has changed. (1 Viewer)

[pekajo]

Hi,
I have a bit of a problem in that I have two same databases and have updated one and now I need to import the new forms from one to the other as I have only updated the forms.
Is there a way of finding out when forms designs were last changed which should give me an indication what forms I need to import.
Thanks for an help
Peter

 

[Edgar_]

Is there a way of finding out when forms designs were last changed which should give me an indication what forms I need to import.

You can try using this from a watch
CurrentProject.AllForms("name_of_your_form").DateModified

or
From the immediate window
?CurrentProject.AllForms("name_of_your_form").DateModified

or
In a line of code
Debug.Print CurrentProject.AllForms("name_of_your_form").DateModified

or
Right click from the navigation and choose form properties.

or
If you want to evaluate all your forms, use a loop and use the code above like

Sub CheckFormDateModified()
    Dim f As AccessObject
    For Each f In CurrentProject.AllForms
        Debug.Print f.DateModified, f.Name
    Next f
End Sub

And check the report in the immediate window

 

[RonPaii]

Hi,
I have a bit of a problem in that I have two same databases and have updated one and now I need to import the new forms from one to the other as I have only updated the forms.
Is there a way of finding out when forms designs were last changed which should give me an indication what forms I need to import.
Thanks for an help
Peter

If you split the database, all you need to do is copy the new FE and link it to the 2nd BE.

 

[Albert D. Kallal]

Hi,
I have a bit of a problem in that I have two same databases and have updated one and now I need to import the new forms from one to the other as I have only updated the forms.
Is there a way of finding out when forms designs were last changed which should give me an indication what forms I need to import.
Thanks for an help
Peter

Just right click on the nav pane, and choose details.

Like this:

Also THEN note how I changed the sort to descending for modified date.

I assume of course this is a "one time" event, and for future development, if you split your database, then this "issue" will go away....

R
Albert

 

[pekajo]

Thanks so much.
Peter

Just right click on the nav pane, and choose details.

Like this:
View attachment 122807

Also THEN note how I changed the sort to descending for modified date.

I assume of course this is a "one time" event, and for future development, if you split your database, then this "issue" will go away....

R
Albert

Thanks so much
Peter

 

[pekajo]

Thanks so much.
Peter

Thanks so much
Peter

Thanks for your reply
Peter