Results 1 to 4 of 4
  1. #1
    gsearley
    Guest

    Mid command in query (2000 SR1)

    Hi,

    I have been using a query in Access 97 without any problems. I have moved up to Access 2000 and the following field in a query brings up an error "Undefined function 'Mid$' in expression:

    Descr Second: Mid$([mg_descrn],[Second Word Descr]+1,5)

    I have checked it against the original Access 97 version and there is no difference.

    Can anyone please help me?

    Regards,

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Mid command in query (2000 SR1)

    Hi,
    It sounds like you have a references problem. If you open the VBEditor (Alt+f11) and select Tools-References, do any of the ones that are checked start with 'MISSING:'?
    If so, try unchecking the offending reference (make a note of what it is first, just in case) and compile your database.
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    gsearley
    Guest

    Re: Mid command in query (2000 SR1)

    Rory,

    Thanks for that - I had a MISSING:Microsoft DAO 2.5/3.5 Compatability Library

    I unticked the box and everything works fine now - what is the compatability library anyway?

    Regards,

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Mid command in query (2000 SR1)

    It is, as far as I know, there to ensure that old code will continue to run in newer versions.
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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