A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Names Translation



 
 
Thread Tools Display Modes
  #1  
Old April 21st, 2010, 03:14 PM posted to microsoft.public.access.forms
Highlight between 3 fields[_2_]
external usenet poster
 
Posts: 26
Default Names Translation

Hello

I made program on MS Access 2007.

I am thinking to make possibility for translate(changes) the "menu, buttoms
and columns name".

For the columns change so such as:

Original columns name Changes to other
Name Namn
Price1 Pris1
Price2 Pris2

After converting to MDE.
I mean when I give my work as MDE to anyone, so he can change the word that
needs for forms and raports.

Any comments appreciate.

Thanks
  #2  
Old April 21st, 2010, 04:09 PM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Names Translation

On Wed, 21 Apr 2010 07:14:01 -0700, Highlight between 3 fields
wrote:

Hello

I made program on MS Access 2007.

I am thinking to make possibility for translate(changes) the "menu, buttoms
and columns name".

For the columns change so such as:

Original columns name Changes to other
Name Namn
Price1 Pris1
Price2 Pris2

After converting to MDE.
I mean when I give my work as MDE to anyone, so he can change the word that
needs for forms and raports.

Any comments appreciate.

Thanks


One possible solution would be to use the field's Caption property. If the
fieldname is "Price1" and the caption "Pris1" the latter is what you'll see in
many contexts.

Otherwise you'll need to just manually edit the controls.
--

John W. Vinson [MVP]
  #3  
Old April 21st, 2010, 07:28 PM posted to microsoft.public.access.forms
Highlight between 3 fields[_2_]
external usenet poster
 
Posts: 26
Default Names Translation

Hello

The important is not fieldname to be changed, but is it possibble to change
the caption?

If yes, how?

Best regards
  #4  
Old April 22nd, 2010, 02:30 AM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Names Translation

On Wed, 21 Apr 2010 11:28:01 -0700, Highlight between 3 fields
wrote:

The important is not fieldname to be changed, but is it possibble to change
the caption?

If yes, how?


Sure. Open the table or query in design view; select the field; and change its
Caption property on the field properties.

In VBA you can reference the caption property of the field; you may need to
create the property first since it's a "user property" which doesn't exist
until it's needed.
--

John W. Vinson [MVP]
  #5  
Old April 22nd, 2010, 09:14 AM posted to microsoft.public.access.forms
Highlight between 3 fields[_2_]
external usenet poster
 
Posts: 26
Default Names Translation

Hi

Thank you for information

I did test it and it work, but it didn't changed the caption on form.
Though the important is that be changed on form.

Is it possible to make the text on caption as link to another table or
something else to show the new text?

Thanks a lot
  #6  
Old April 23rd, 2010, 03:08 AM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Names Translation

On Thu, 22 Apr 2010 01:14:01 -0700, Highlight between 3 fields
wrote:

Hi

Thank you for information

I did test it and it work, but it didn't changed the caption on form.
Though the important is that be changed on form.


It wouldn't, unless you recreate the control on the form. The table Caption
property is the default for new controls, but would not change existing
controls.

Is it possible to make the text on caption as link to another table or
something else to show the new text?


I expect it would be possible but it would take some code. The caption
property isn't exposed all that well in the table structure. You might want to
have your own table of fieldnames, languages, and captions and put textboxes
(rather than labels) on your form to look up the appropriate caption for the
user's preferred language.
--

John W. Vinson [MVP]
  #7  
Old April 23rd, 2010, 07:51 AM posted to microsoft.public.access.forms
Highlight between 3 fields[_2_]
external usenet poster
 
Posts: 26
Default Names Translation

I expect it would be possible but it would take some code. The caption
property isn't exposed all that well in the table structure. You might want to
have your own table of fieldnames, languages, and captions and put textboxes
(rather than labels) on your form to look up the appropriate caption for the
user's preferred language.



Hello

Well, let make new table that namn "language"
have columns with name FieldName , CurrentWord, NewWord

So do you mean?

Can you please show me which kind of code that be on "Onload Form" to change
one caption to let me understand, then I can continue.

Thanks a lot
  #8  
Old April 23rd, 2010, 04:52 PM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Names Translation

On Thu, 22 Apr 2010 23:51:01 -0700, Highlight between 3 fields
wrote:

I expect it would be possible but it would take some code. The caption
property isn't exposed all that well in the table structure. You might want to
have your own table of fieldnames, languages, and captions and put textboxes
(rather than labels) on your form to look up the appropriate caption for the
user's preferred language.



Hello

Well, let make new table that namn "language"
have columns with name FieldName , CurrentWord, NewWord

So do you mean?

Can you please show me which kind of code that be on "Onload Form" to change
one caption to let me understand, then I can continue.

Thanks a lot


I'd add one more field to the Language table: Language. And you probably
don't need the CurrentWord field. For instance you could have records like

Language; FieldName; Caption
English; FirstName; "First Name"
German; FirstName; "Vorname"
Spanish; FirstName; "Nombre de pila"

In the form's Load event you would assign the Caption property of each control
on the form to the appropriate value from this table for the user; I'd presume
that you would have the user's prefeered language in a global variable or a
control on a startup form.

This is a simple untested solution to what could be a more complex problem,
but I hope this gives you some ideas!

--

John W. Vinson [MVP]
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:40 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.