Application Title / form name

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can you display the application name and name of the report in the page
header?

Example:

XYZ Company Limited - Sales Report
 
Where are you storing this information? You might try something like:
="XYZ Company Limited - " & [Name]
 
The company name is stored in the Application Title field in the startup
options.

An extensive search fails to find anything on retrieve the Application Title
for use in report headers, etc. Maybe something like Application.Title or
Application.Caption?


--
Rick in N S


Duane Hookom said:
Where are you storing this information? You might try something like:
="XYZ Company Limited - " & [Name]

--
Duane Hookom
MS Access MVP
--

Rick in NS said:
How can you display the application name and name of the report in the
page
header?

Example:

XYZ Company Limited - Sales Report
Click to expand...
Click to expand...
 
in message:
The company name is stored in the Application Title field in the startup
options.

An extensive search fails to find anything on retrieve the Application Title
for use in report headers, etc. Maybe something like Application.Title or
Application.Caption?
Click to expand...

This is a perfect case to build a small, single record table with the application
title (in your case the company name) and then you can reference it anywhere
in your application.

For example, I have a table called tblLicense. Among other fields, one is called
CompanyName. In every single Report Header I have a text box, txtCompany
with a Control Source of:
=DLookUp("[CompanyName]","tblLicense")

I can just copy/paste that onto every new report I create. One change to that
field (through a form) will automatically show the new company name on all
reports.
 
Back
Top