Results 1 to 8 of 8
  1. #1
    2 Star Lounger
    Join Date
    Jun 2004
    Location
    L, Schleswig-Holstein, Germany
    Posts
    184
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Translation Problems! (Jet database engine...) (2003)

    Hello everyone,

    I've been working with the german version of Access all the time and now set up an all-english system. Of course this is supposed to make errors in Acces, because we developers love bug hunting! Well here's one I can't figure out:

    I have a query qryTest and it's where condition was "[Formulare]![frmXXX]![cboXXX]" (german version). When I start up this database now with my new english version I get the usual "Enter Parameter for Formulare..." box. Entering my value - of course - gives me the desired result.
    (The funny thing is that Access edits those "Formulare" automatically to its final form, i am always entering "Forms" and Access makes it german... anyways, thats somthing different)

    Here is what I tried. I thought to myself "let's make it international" - and so I changed the where condition happily to "[Forms]![frmXXX]![cboXXX]" - as every expert would recommend I guess. And this is what I get with that: "The Microsoft Jet database engine does not recognize 'Forms!frmXXX!cboXXX' as a valid field name or expression."
    Great!

    I really didn't change anything, but format c: and use an all english system. There was a Reference Error (developers love those too) referring to MSCOMCT2.OCX (that usual Microsoft Windows Common Control) but I guess that was just a reminicent of the old system (as the name is Common Control-2) - a copy I guess...

    Hope you guys can help me work with the english system...

    dENNIS

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Translation Problems! (Jet database engine...) (2003)

    Very strange! The Dutch version of Access 95 accepted both Forms and its Dutch translation Formulieren. Later versions only accept Forms, not Formulieren.

    Anyway, try typing the entire expression from scratch.

  3. #3
    2 Star Lounger
    Join Date
    Jun 2004
    Location
    L, Schleswig-Holstein, Germany
    Posts
    184
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Translation Problems! (Jet database engine...)

    Groetjes van Maastricht!

    Yeah tried retyping everything and first entered the WHERE condition manually, then over the "Build..." Wizard, which both came to the same result as described before. Really don't know what this means...
    Full expression:

    TRANSFORM Count(*) AS TheValue
    SELECT "Name" AS Name
    FROM tblCommittees INNER JOIN joinSchoolUNMemberCommittee ON tblCommittees.CommitteeID = joinSchoolUNMemberCommittee.CommitteeID
    WHERE (((joinSchoolUNMemberCommittee.Year)=[Forms]![frmYear]![cboreg]))
    GROUP BY "Name"
    PIVOT tblCommittees.Committee;

    (Without the WHERE Condition, everything perfect, with manually entered WHERE condition "2004", everything perfect)

    Dennis

    EDIT!!
    ------------------------------------------------------------------------

    OK I found the problem, but very funny though - if this is true it means I cannot program any further with the english version, because other people are using the german version.

    For a crosstab query I have to define the Parameters for the Values, right? Well as soon as I changed the "[Formulare]!..." to "[Forms]!..." in the Query>Parameters box, everything worked. I am only using 2 crosstab queries and they are preliminary yet, but now i'm really afraid that there are more problems I cannot foresee... Great

    Dennis

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Translation Problems! (Jet database engine...)

    Ah, I hadn't thought of explicitly declared parameters (and yes, you need them in a crosstab query). It's good that you found it!

    Before giving up, try the version that works in the English language version of Access (with [Forms]!... both in the criteria line and in the Parameters dialog) on a PC with the German language version. It ought to work.

  5. #5
    2 Star Lounger
    Join Date
    Jun 2004
    Location
    L, Schleswig-Holstein, Germany
    Posts
    184
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Translation Problems! (Jet database engine...)

    Yeah I will just install a seperate version on some other system...

    You don't happen to know what this MSCOMCT2.OCX was, right? I searched the web and there are multiple references about it. I downloaded a MSCOMCT2 version from some website and registered it as I had to, added it into ACCESS and it registered with the same Common Control-2 name, even tho it was (SP4) instead of (SP6), but that was the version I guess. I don't know now if in a standard installation of Access the MSCOMCTL will get installed or the MSCOMCT2... multilanguage... gotta love it

    Dennis

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Translation Problems! (Jet database engine...)

    MSCOMCTL.OCX is different from MSCOMCT2.OCX.
    MSCOMCTL.OCX is needed for controls such as ListView and TreeView, and MSCOMCT2.OCX is needed for controls such as the Date/Time picker. Neither is part of a standard MS Office 2003 Pro installation, as far as I know.

  7. #7
    2 Star Lounger
    Join Date
    Jun 2004
    Location
    L, Schleswig-Holstein, Germany
    Posts
    184
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Translation Problems! (Jet database engine...)

    Very good, then I included both during some testing.

    Thanks for your help Hans en slaap lekker
    Dennis

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Translation Problems! (Jet database engine...)

    Welterusten <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •