Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2002
    Location
    Belgium
    Posts
    243

    Red face Unanswered: RTRIM is not available

    I'm working on a desktop with database which is located on a laptop.

    When I open the database on the desktop everything works fine, but when I open it on the laptop it gives error 3075 :

    -----------------------------------------------------------
    Function is not available in expressions in query expression
    RTRIM(TPER.per_nm) + " " + TPER.per_vnm
    -----------------------------------------------------------

    I used this in a createTable-query just to put the lastname and the first name (seperated with a space) of our employees in a temporary table.

    Both PC's are running the same version of Access :
    Access 2002 (10.2627.2625)

    Same language of Access-installation.

    Anybody any idea ?
    Thanx

  2. #2
    Join Date
    Oct 2001
    Location
    Chicago
    Posts
    440
    Are you getting any other errors?

    Check your references? Missing a reference will produce goofy errors not related to the missing reference.

    Can you compile?

    Matt

  3. #3
    Join Date
    Nov 2002
    Location
    Belgium
    Posts
    243
    Originally posted by Rockey
    Are you getting any other errors?

    Check your references? Missing a reference will produce goofy errors not related to the missing reference.

    Can you compile?

    Matt
    This is the first error I encounter when starting the database.
    I don't know if there are any others, because I have to end the execution.

    And I can compile.

    I used the Access Query-designer to create the query.
    In the Form_load event of my startup-form I got this code

    Code:
    Docmd.OpenQuery "qryCreateTemporaryTable"

    When I put this line as comment the database starts without any problem.

  4. #4
    Join Date
    Oct 2001
    Location
    Chicago
    Posts
    440
    Missing references?
    Code window-->Tools-->References

  5. #5
    Join Date
    Nov 2002
    Location
    Belgium
    Posts
    243
    Originally posted by Rockey
    Missing references?
    Code window-->Tools-->References

    It looks like it has something to do with the Microsoft Common Dialog Control.
    On my laptop I was still using an older version.
    Thanks a lot.

Posting Permissions

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