Hi All I want to set an Applicat

[Toby1kenobe]

Hi All

I want to set an Application Name for my DB. When set, such as "Heather Highschool", this gets used on any reports, forms etc.

Is this possible? can labels have a variable name instead of the actual text? Can i set an label on a report that also looks at the Application name variable?

Where would i declare the variable?

Thanks in advance
Toby

 

[KenReay]

Hi

See Tools \ Options to set an application name

You can name labels anything you want, provide dthe name is unique within the containing object

Althougn I have not done this I would aasume that in VBA you can do something like

lblMyLabel.Caption = Application.Name



Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[DJN]

Have a look at the Microsoft web site. They have the code for this.

http://support.microsoft.com/default.aspx?scid=kb;en-us;141618&Product=acc97

David