Version number on form

[cprobertson1]

TL;DR - need a value on a form that gets carried across to other forms (in the form of a label preferably)

----

Hello folks,
I'm a relative newbie with Access so my apologies if I'm doing something daft and not realised it!

I'm in the process of setting up a series of databases for my work: four or five forms and tables running in a front end/back end manner to allow multiple user access.

On top of these five forms there is a "DEBUG" form which I use for quickly grabbing reports and data logs, quickly hiding background items for the front end and for opening other forms in design mode.


Just now ALL forms have a "version" number for the database front end as part of development - and just now they all get updated manually with me typing it in.

I'm looking to have a text-box on the "DEBUG" form which I can just type the current version number in and it will transcribe to the other forms. The version is currently stored in a table (but not all forms point to that table!)

What is the best way for the other forms to grab the version number either from that table or from that form?

 

[pr2-eugin]

Create a Text box, mimic it to be something like a Label. Then use its control Source as a DLookup statement. So even though the form is bound to another table it will still be able to get the version number because it is an unbound control.

 

[cprobertson1]

Thanks for the quick reply!

Quick question: what am I putting in as the "expression" and "domain" arguments for the DLookUp()?

Is the expression just "=field-name-from-table" and "<database_name>" for domain?

::EDIT::
Sorry, forgot to mention, the text box is just returning "#Name?" with what I currently have in it.

 

[pr2-eugin]

Forget about the expression builder, simply use the following as the control source.

= Nz(DLookup("[COLOR=Blue]theVersionFieldName[/COLOR]", "[COLOR=Blue]theVersionTableName[/COLOR]"), "0.1")

Pleas emake sure the highlighted section match your design !

 

[cprobertson1]

Ah, nailed it! Thanks very much

Is it possible to stop the users clicking on it as if to edit it? (i.e moving the cursor onto it?)

Will disabling it from VBA code permit that or will that prevent text appearing at all?

::Edit::
Yes it will xD

All fixed now! Thanks again for your help

 

[pr2-eugin]

As I mentioned earlier, mimic the text box as label. Play with the Locked property, Enabled property. Setting Locked to Yes and Enabled to No should work, if not I think one of the combination.