Determine name of application being executed...

Besides the App Title, you can:

1. use a custom database property that you create (i.e. MyAppVersion, MyAppTitle, etc) and retrieve that.

2. Get the actual file name:  CurrentDB().Name

3. Use an internal table to hold the info.

Jim.

There are different ways to handle this, such as:

• You could set a database property and retrieve it.
• You could have a table and read it. (This is what I do)

What I do for the table approach is


This way for each version I have a 1-many relationship allowing me to detail the changes between each version.  This is great when reviewing things at a later date,

What I don't recommend is storing the version in the filename as this means you need to continuously keep updating shortcut or your launch script.

I use a table (tbl_VersionHistory) which includes a notes field for each time I make changes to the application.  It has an ID column, VerNum (text), VerDate, and Comments.  When I get ready to deploy the application, I edit the AppTitle and create an AppVersion database property as well, so that my AppLauncher can compare the AppVersion value in the version being run with the current version which is stored somewhere on the file server.

I do the same thing that Dale does;  additionally, my Main Menu form writes a record into the WorkLogTb that includes the revision date of the db being opened.  That way I can see what version(s) my users are opening, and nag them to update their installation if necessary.  :)

I do the same as Paul and display the version on my Main menu.  This make it easy for any user to report back to the developer details of problems and you can quickly validate that they are using the right version.

I use to do like Dale and check the version with my deployment utility, but have since switched to always copying a fresh copy of the front-end to my users when they launch the db.

Thank you so much for the valuable input! The solution of Gustav sounds the easiest one to use... Again , thank you so much for your help! Cheers Michael

I do the same as Paul and display the version on my Main menu.  This make it easy for any user to report back to the developer details of problems and you can quickly validate that they are using the right version.

 Ditto here.   I go one step further though in that if a user double clicks on the version number display on the main menu, I bring up the version history.

 In my table, I have developer notes and  user notes (what gets displayed) , along with the # and date deployed.

Jim.