Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Posts
    159
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Queries in 2002 (2002)

    I have a dilema. I can't seem to grasp the differences between 2000 and 2002. I need to create a query in a DateTime field that will return the dates in mm/dd/yyyy format. They way I used to do it Date: Format([DateTime],"mm/dd/yyyy") does not work. I get the error message "Undefined function '[Format$]' in expression"

    I guess from what I have been able to read in the HELP section I need to learn SQL. Along with the answer for the above question, does anyone know a good SQL reference?

    TIA
    Bret

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Queries in 2002 (2002)

    Are you in an MDB or an ADP? If you're in an ADP, you aren't building queries, you're building views and stored procedures in SQL Server and SQL Server doesn't recognize Access/VBA functions. If you're in an MDB, you've got a references problem.
    Charlotte

  3. #3
    2 Star Lounger
    Join Date
    Mar 2001
    Posts
    159
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Queries in 2002 (2002)

    I am in mdb. The thing that is strange is, all these queries worked/work in Access 2000. But when I upgraded on this one machine, now I have started getting these error messages.

    Thanks.

    Bret

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Queries in 2002 (2002)

    As Charlotte said, the problem is not with your queries - it has to do with references. Go to the modules tab and open any module in design mode, then select Tools/References and you should see either some missing references, or you may see no reference to DAO, and a reference to ADO instead. Compare what you see on an Access 2000 machine with what you see on the Access 2002 PC, and change the 2002 PC to be the same as the 2000 PC.
    Wendell

  5. #5
    2 Star Lounger
    Join Date
    Mar 2001
    Posts
    159
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Queries in 2002 (2002)

    When I go to the Modules tab there isn't anything listed. Just to give you a little background. These queries are from tables that are linked to a software program that uses Access as the data storage device.

    I don't know if this makes any difference to what you are trying to help me with or not.

    TIA
    Bret

  6. #6
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Queries in 2002 (2002)

    What Wendel and Charlotte means is the following.
    Open a module in design view.
    If there is no module create a new one.
    In this module, select the menu Tools, References.
    You will get a window like the picture below.
    Look at the list if you find near one of the check boxes the word MISSING
    It this is the case, the uncheck this check box.
    Close the module. (you don't need to save it).
    Attached Images Attached Images
    Francois

Posting Permissions

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