Version Ref

[SteveE]

I make many small changes to the DB as user may request (mde f/b split table), is there a way I can put an automatic verision number onto my menu form so I can readily check that it is the latest verison

any help appriciated

Steve

 

[Mile-O]

I usually have a module called basDeclarations where I list any public variables I'll need etc.

Within that I dimension a public variable call pVersion.

When a form loads I set it's caption to pVersion.

 

[SteveE]

Thanks for that but I,m not sure just what you mean. Does the call automaticly increment a value each time the mde file is created i.e 0001234 , 5, 6 etc

 

[Mile-O]

Sorry, I said variable - I meant Constant.

Na, if I'm going to create a new mde I just change the value of the public constant


It basically sits in the module:

Public Const pVersion = "v1.00.03"

When I make a fix, I update the number and make a new mde.

 

[SteveE]

Thanks for your help here, I understand in principal what your saying but not in practice could you expand a little please

thanks

 

[Mile-O]

Okay.

I create a module in my database and within it I put a public declaration of a constant. I call this constant pVersion and assign it a text value, this value being my database application's version number.

It is declared thusly:

Public Const pVersion = "v1.00.02"

In my form's OnOpen event I use the code to assign the value of pVersion to the form's Caption property

i.e.

Private Sub Form_Open(Cancel As Integer)
    Me.Caption = pVersion
End Sub

When I've finished my database I make an mde.


If a bug is found or I add new features to the database I open the module and just change the value of the constant pVersion, using the case above I'd change it to "v1.00.03"

Then, I'd create a new mde and distribute it.


Unfortunately Access doesn't have the Application, Version, Release numbers that can be found in Visual Basic.