Multiple labels could be change with on go. (1 Viewer)

[Samadkhan]

Hey All,

I am trying to create several forms where I will place Title (lable) company name.

Is is possible in access 2013, if I change somewhere the name of company and it should change all labels with the same company name?

If is it possible please let me have the solution how may I apply this.

Thanks you very much.

 

[CJ_London]

not clear what you are asking - but sounds like you should be using a bound text box to show the company name, not a label.

If this is not the answer, you will need to provide more information - change the name of the company where? how is it stored?

if you are talking about a design change then you will need vba to loop through all forms and reports and for each of these loop through all the controls and where it is a label, compare the caption property.

Alternatively, you might just be able to change the caption property of a field in a table somewhere

As I said, you need to be much clearer about your requirement

 

[isladogs]

Save the company name in a table.
Create a public function GetCompanyName in a standard module to read that value.
Use the function in each label caption instead of hard coding the name.

It will then automatically update the labels if another company name is used later

 

[Samadkhan]

Thank you very much CJ_London for your swift response, highly appreciated...

I have created the tblUser, In this table I have created the field UserNme (Company Name).

Then I created a form with the lblCompanyName (Lable).

I am a beginner, if possible please help me and specify the Public functions GetCompanyName code with bundles of thanks.

Thank you

Save the company name in a table.
Create a public function GetCompanyName in a standard module to read that value.
Use the function in each label caption instead of hard coding the name.

It will then automatically update the labels if another company name is used later

 

[Samadkhan]

Thank you very much CJ_London got my issue resolved...

Thank you millions much ... have a wonderful day ..!!!

 

[CJ_London]

Then I created a form with the lblCompanyName (Lable).

for my suggestion, create a textbox, not a label. You can delete the associated label control

Assuming this is a one record table in the textbox controlsource put

=dlookup("CompanyName","tblUser")

you may also want to set the textbox Locked property to Yes

 

[isladogs]

You keep referring to CJ_London but quoted my post and function idea.
As you have indicated it's now solved, there seems no point in explaining further.
Cheers!

 

[Samadkhan]

Dear Ridders,

Please accept my sincere apology, I am new and don't know much about this forum now I am learning .... Hope you may understand .


Thanks

You keep referring to CJ_London but quoted my post and function idea.
As you have indicated it's now solved, there seems no point in explaining further.
Cheers!

 

[isladogs]

I'm not offended and hopefully neither is CJ London....but it did make it hard knowing whether to reply or not