Application title from startup on a form?

[Harmannus]

Hallo,

Is it possible to show the "application title" from the startup menu (under
tools) in a field on a form?

<application title>

e.g. Customer relationmanagement


Regards,

Harmannus, The Netherlands

 

[Wayne Morgan]

You have to set it one time to "create" the property. This can be done using
the Startup options or by creating the property in code. To retrieve the
value that has been set use

CurrentDb.Properties("AppTitle")

 

[Harmannus]

Hallo,

Thanx for the response!

If i want to show this on opening a form. Where do i put this code and how
do i link it to a field?

Thanx for any tips.

Regards,

Harmannus

 

[Wayne Morgan]

How do you want to show it when opening a form? If you just want it to show
in a textbox, I was able to get the text box to show the value by placing

=CurrentDb.Properties("AppTitle")

in the textbox's control source. When you say "link it to a field" what do
you want this "link" to do?

 

[Harmannus]

Hallo Wyne,

Adding it to the control source works! Thanx!

I also want the application size to be displayed like this. Got a suggestion

me.txtFilesize = FileLen("yourdatabase.mdb")

But doing it your way (adding it to the control source) what is the syntax?
Tried various things but can't get it to show the size.

Thanx in advance!


Regards,

Harmannus

 

[Wayne Morgan]

=FileLen(CurrentDb.Name)

 

[microsoft]

Hallo Wayne,

Thanx for the quick response!

Greatly appreciated!


Regards,

Harmannus