How to use =[currentproject].[Name] with modifications?

[jjake]

Hello,

I have a project i publish with updates every so often that i keep in a version history table. The format is "Ver 1.0.0".

Currently i use a text box that displays the latest number from my table and shows it to the user so they know what version they have.

My issue is that when i am working on a new version in the background and i input a new version into the table it automatically updates their screen to the new version # that is displayed. I only want it to update when they download the new version which is where my question comes in.

I save my files names with the new version number whenever they are ready to be released. e.g "CST 7000 Maintenance Database Main 1.0.6"

I just edit the version number at the end when i release it. I found out about the command =[currentproject].[Name] but it shows "CST 7000 Maintenance Database Main 1.0.6.accdb". Is there a way to limit this so i can display "Ver 1.0.6" using the 1.0.6 numbers from the file name? And if possible could i store them values into another field?

 

[Ranman256]

I keep all file names the same. This way every users shortcut starts the same file.
But the main menu load will check the FE config tbl, with the backend version tbl.
If they don't match, the user gets a nag screen to update.

 

[arnelgp]

your db should be split, put the version no in a table in fe and not on be. then just dlookup this table for the version number.

 

[jjake]

your db should be split, put the version no in a table in fe and not on be. then just dlookup this table for the version number.

Ah good idea. I never really thought about splitting my tables. I always put everyone on the be.