none
?? cannot find the object "Procédure événementielle" RRS feed

  • Question

  • Good morning,

    I have created a program with Microsoft Access on my computer that uses Windows 7 in French and Microsoft Access in French

    Then, I did copy the database into another computer that uses Windows Vista home edition in English, almost everythings works perfectly, however, on one of the button, it gives me the message in the title of that discussion.

    That button is working perfectly on my computer, the same database on the other generate that error, someone has any idea of what's going on?

    Thanks


    Claude Larocque
    Sunday, January 22, 2012 9:03 AM

Answers

  • Claude Larocque wrote:
    > ...
    > I have created a program with Microsoft Access on my computer that
    > uses Windows 7 in French and Microsoft Access in French
    >
    > Then, I did copy the database into another computer that uses
    > Windows Vista home edition in English, almost everythings works
    > perfectly, however, on one of the button, it gives me the message
    > in the title of that discussion.
    >
    > That button is working perfectly on my computer, the same database
    > on the other generate that error, someone has any idea of what's
    > going on?
     
    This is a frequent problem with DBs created on a non English
    system. If you try to let them run on a different language system
    than it was created the translation of the respective term for
    the English [Event procedure] doesn't always work.
     
    One solution for the problem is to develop multi language
    applications on an English system. If you start with the English
    "Event procedure" Access has no problem to translate the term
    in the property sheets to "Procédure événementielle" on a
    french machine or "Ereignisprozedur" on a German system
    "Procedura evento" Italian etc.
     
    Usually there are also less problems caused by special
    characters if you use and do everything in English.
     
    Another solution is to test on an English system and replace
    every remaining occurrence of [Procédure événementielle]
    by [Event procedure]. If you are sure that the problem only
    happens with this particular button you may replace the
    term by hand in the button's click property.
     
    It would be more secure to control the complete database
    with a find&replace tool.
     
    Even better is to loop through the properties collection
    with VBA and check the values for the term
    "Procédure événementielle". Different from the user interface
    it has always to be "Event procedure" there. So this solution
    also works on your French development system.
     
    After that test and replacement process distribute this version
    and be prepared to always do this before shipping a new version.
     
    --
    cu
    Karl
    *********
    Access-FAQ (German/Italian): http://www.donkarl.com
     
     

    Sunday, January 22, 2012 10:15 AM
  • Claude

    I use the free add-in called Z-Tools from skrol29.com. One of the tools is Deep Search. It will search through everything and make whatever replacement you want. As a precaution, always make a backup first.


    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    Tuesday, August 11, 2015 2:25 PM

All replies

  • Hi Claude,

     

    Google translate tells me that "Procédure événementielle" is "Event Procedure". So if you look at the Command Button properties >  "Events" tab and the "OnClick" event, on the English version of Access this should read "[Event Procedure]" and not "[Procédure événementielle]"

    Sunday, January 22, 2012 9:46 AM
  • Claude Larocque wrote:
    > ...
    > I have created a program with Microsoft Access on my computer that
    > uses Windows 7 in French and Microsoft Access in French
    >
    > Then, I did copy the database into another computer that uses
    > Windows Vista home edition in English, almost everythings works
    > perfectly, however, on one of the button, it gives me the message
    > in the title of that discussion.
    >
    > That button is working perfectly on my computer, the same database
    > on the other generate that error, someone has any idea of what's
    > going on?
     
    This is a frequent problem with DBs created on a non English
    system. If you try to let them run on a different language system
    than it was created the translation of the respective term for
    the English [Event procedure] doesn't always work.
     
    One solution for the problem is to develop multi language
    applications on an English system. If you start with the English
    "Event procedure" Access has no problem to translate the term
    in the property sheets to "Procédure événementielle" on a
    french machine or "Ereignisprozedur" on a German system
    "Procedura evento" Italian etc.
     
    Usually there are also less problems caused by special
    characters if you use and do everything in English.
     
    Another solution is to test on an English system and replace
    every remaining occurrence of [Procédure événementielle]
    by [Event procedure]. If you are sure that the problem only
    happens with this particular button you may replace the
    term by hand in the button's click property.
     
    It would be more secure to control the complete database
    with a find&replace tool.
     
    Even better is to loop through the properties collection
    with VBA and check the values for the term
    "Procédure événementielle". Different from the user interface
    it has always to be "Event procedure" there. So this solution
    also works on your French development system.
     
    After that test and replacement process distribute this version
    and be prepared to always do this before shipping a new version.
     
    --
    cu
    Karl
    *********
    Access-FAQ (German/Italian): http://www.donkarl.com
     
     

    Sunday, January 22, 2012 10:15 AM
  • Thanks Karl,

    When you mention a find&replace tool, is it a code that I will execute and that will check all the properties to replace the "Procédure événementielle" to "Event procedure" automatically.

    If you have such a code, I would very much appreciate if you can send me an example or some explanations on how to loop through the properties collection and changing from French to English automatically...

    Thank you

    Claude from Quebec, Canada


    Claude Larocque
    Tuesday, January 24, 2012 8:46 AM
  • Exactly the same problem with Access 2010.

    I program in french, with a french setup. My english colleagues want to use my Access database and development. For some fields, they retreive "cannot find the object "[Procédure événementielle]"" error message because, the event procedure is associated with "[Procédure événementielle]" instead of "[event procedure]". The


    I must verify and change each field for each forms  => 30 hours to spend.

    Microsoft, can you propose a solution or a workaround please ? Is there a way to automatically transform the reference ?

    Regards

    Eric

    Tuesday, August 11, 2015 9:53 AM
  • Claude

    I use the free add-in called Z-Tools from skrol29.com. One of the tools is Deep Search. It will search through everything and make whatever replacement you want. As a precaution, always make a backup first.


    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    Tuesday, August 11, 2015 2:25 PM