Local Language in name of the church

  • Thread starter Thread starter Frank Situmorang
  • Start date Start date
F

Frank Situmorang

Hello,

In my Churches table I have chruch ID and ChruchnameE for English Name and
ChurchNameL for Church Local Name.

What should should mention on the textcontrol to say if language in Defaults
table is not English, then it will take the Local Name.

Anyone can help me please?

Thanks in advance
 
On Mon, 1 Dec 2008 18:55:01 -0800, Frank Situmorang

The ControlSource should be:
=IIf(DLookUp("Language","Defaults")="English",[ChurchNameE],[ChurchNameL])

Note: if you do this for a lot of fields, your app will be very slow.
Alternatives require some VBA, which IIRC you don't master yet.

-Tom.
Microsoft Access MVP
 
Thanks Tom for your reply, I plan to use this just for Switchboard Menut
Items. and chruch table. For the reports and form I already use VBA on each
caption label of the forms and reports.

Is it also slow, even though for churchtable and just English and Local,
then I put it on the different back End, so I changed the linked for every
different country.

Thanks
--
H. Frank Situmorang


Tom van Stiphout said:
On Mon, 1 Dec 2008 18:55:01 -0800, Frank Situmorang

The ControlSource should be:
=IIf(DLookUp("Language","Defaults")="English",[ChurchNameE],[ChurchNameL])

Note: if you do this for a lot of fields, your app will be very slow.
Alternatives require some VBA, which IIRC you don't master yet.

-Tom.
Microsoft Access MVP

Hello,

In my Churches table I have chruch ID and ChruchnameE for English Name and
ChurchNameL for Church Local Name.

What should should mention on the textcontrol to say if language in Defaults
table is not English, then it will take the Local Name.

Anyone can help me please?

Thanks in advance
Click to expand...
Click to expand...
 
Back
Top