Local Language in name of the church

[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

 

[Tom van Stiphout]

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

 

[Frank Situmorang]

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

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