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. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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] |
Thread Tools | |
Display Modes | |
|
|