Application Version Number

[KabirPatel]

Is there a way of specifying the version number of an Access application?

e.g. In classic Visual Basic you can specify the version number in the "Project Properties" menu option and then use these values in code by doing an app.major, app.minor etc... (or something like that).

Is there an equivalent in MS Access?

Cheers,
Kabir

 

[dan1dyoung]

Kabir,

Not as easy as that, or not that i know of unless you use the "Tools" > "Startup" menu and put it in the "Application Title".

I have a table tblSoftwareInformation with Name, Version, & Copyright fields. I then put my data in there and then call it like below in the onload event of the main window (Form):

Dim intX As Integer
Dim s As String
Dim strTitleName As String

s = Left(CurrentDb.Name, Len(CurrentDb.Name) - Len(Dir(CurrentDb.Name))) & "\DYS_Logo.ico"
Const DB_Text As Long = 10
strTitleName = DLookup("SoftwareName", "tblSoftwareInformation")
intX = AddAppProperty("AppTitle", DB_Text, strTitleName)
intX = AddAppProperty("AppIcon", DB_Text, s)
Application.RefreshTitleBar


Dim strTitleRegText As String
Dim strTitleCompany As String
strTitleRegText = ("Registered to ")
strTitleCompany = DLookup("CompanyName", "tblCompanyInformation")
Me.Caption = strTitleRegText & strTitleCompany

Application.RefreshTitleBar

Also i take the company name from the company details table above to display:

My Logo My Software Name - [Registered to Company Name]

where the [ ] is due to that i have the window maximised

Thanks

Dan