Access application "Property" Revision Number

[MichaelRed]

see it via:
[tab]File => Database Properties => (Tab) Statistics => second section => second line

"Revision Number:"

Any one ever seen a value here? Know how to retrieve / set it. Have any reference at all?

I have expended my patience (and severl hours), includiing searching herein (Tek-Tips), MSDN, and various locations on ye olde "NET".

Lots of implied ways to get there - no cigar.

I'm guessing it is like the app.title, it doesn;t really exists until you create it, but not sure yet. I might try it tomorrow.




MichaelRed

 

[PHV]

How about CurrenDb.Properties("Build") Or CurrenDb.Properties("ProjVer") ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[MichaelRed]

I have tried to list the "db Properties", and these values are available. Changiing objects in the db and saving does not change them. Since I have never changed them (directly) I am quite unsure of their source/generation.

Sub basDbProperties()

    Dim i As Long, z As Long

    On Error Resume Next
    For z = 0 To CurrentDb.Containers("Databases").Documents.Count - 1

        For i = 0 To CurrentDb.Containers("Databases").Documents(z).properties.Count - 1
            Debug.Print CurrentDb.Containers("Databases").Documents(z).properties(i).Name, _
            CurrentDb.Containers("Databases").Documents(z).properties(i).Value
        Next i

    Next z

End Sub

Since these do not change and they are NOT displayed (see original post) I do not THINK they are what I am (tiredly) searching for.

Thank for trying to help an old lame brain.




MichaelRed

 

[MichaelRed]

hmmmmmmmmmmmmmmmm ... I did add the db property for revision number and set it to a value. Using the routine posted, I can see the value, -but- still no value shows up in the "database properties" (see first post) so adding the db properties does not enable / or setr what ever is behind the MS version of revision number.



MichaelRed