Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Heart of Darkness: Error Message Help

Discussion in 'Information Technology' started by Rambo, Jul 28, 2006.

  1. Rambo

    Rambo
    Expand Collapse
    Guest

    Hi,

    I am trying to open a database created in access 2003, but saved in
    access 2000 format, in access 200 but am running into some trouble.
    When I attempt the open I get the following error message.

    Undefined function '[Format $]' in expression

    However, this error message does not appear when I open the database in
    access 2003.

    Can anyone help out?

    Thanks

    Sincerely,
    Rambo
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Big-hearted Sikh Bikers Raise $100K To Fight Pediatric Cancer Breaking News Jul 19, 2016
    Movies Ashdoc's movie review---In the heart of the sea 3D Theatre, Movies & Cinema Dec 9, 2015
    USA A Heart Attack And The Numbers Breaking News Aug 2, 2014
    The Heart of the Matter Part 1 (Video and Transcript) - the myth of saturated fat? Health & Nutrition Oct 26, 2013
    Heart Disease: Why Positive Attitude May Bring Longer Life Health & Nutrition Sep 12, 2013

  3. Douglas J. Steele

    Douglas J. Steele
    Expand Collapse
    Guest

    Your References collection is probably messed up.

    References problems can be caused by differences in either the location or
    file version of certain files between the machine where the application was
    developed, and where it's being run (or the file missing completely from the
    target machine). Such differences are common when new software is installed.

    On the machine(s) where it's not working, open any code module (or open the
    Debug Window, using Ctrl-G, provided you haven't selected the "keep debug
    window on top" option). Select Tools | References from the menu bar. Examine
    all of the selected references.

    If any of the selected references have "MISSING:" in front of them, unselect
    them, and back out of the dialog. If you really need the reference(s) you
    just unselected (you can tell by doing a Compile All Modules), go back in
    and reselect them.

    If none have "MISSING:", select an additional reference at random, back out
    of the dialog, then go back in and unselect the reference you just added. If
    that doesn't solve the problem, try to unselect as many of the selected
    references as you can (Access may not let you unselect them all), back out
    of the dialog, then go back in and reselect the references you just
    unselected. (NOTE: write down what the references are before you delete
    them, because they'll be in a different order when you go back in)


    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no private e-mails, please)


    "Rambo" <moneyball.wilson@gmail.com> wrote in message
    news:1153508511.834402.274070@p79g2000cwp.googlegroups.com...
    > Hi,
    >
    > I am trying to open a database created in access 2003, but saved in
    > access 2000 format, in access 200 but am running into some trouble.
    > When I attempt the open I get the following error message.
    >
    > Undefined function '[Format $]' in expression
    >
    > However, this error message does not appear when I open the database in
    > access 2003.
    >
    > Can anyone help out?
    >
    > Thanks
    >
    > Sincerely,
    > Rambo
    >
     

Share This Page