Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Sep 2003
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Function Error from Laptops only (Access 2000 SR-1 or SR-3)

    I am getting an odd error when printing a report (using a cmdButton) from a form, but only when the user is using a laptop.
    Database has been running for some time without incident using desktop P/C's (should this matter ?)

    Error: Function is not available in expressions in query expression 'IIF(Left([cProduct Code],2)=4,"Yes","No")'

    This only happens if user is on a laptop (and happens every time) but, has not occurred from a desktop. I have tested various security levels and SR levels.

    The function in question, determines if an order is "outsourced" entirely, based on the value of the first two characters of the [Product Code] field.

    Has anyone run into compatibility glitches for laptops ? Please help !

    Thanks,
    Craig <img src=/S/bash.gif border=0 alt=bash width=35 height=39>

  2. #2
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Function Error from Laptops only (Access 2000 SR-1 or SR-3)

    Sounds like a missing reference issue - some library files used by the Access project may not be installed on laptop but are installed on desktop pc. The fact that it's a laptop is not relevent, other than maybe not all options were installed with Access or Office to conserve disk space. Recommend check this MSKB article:

    ACC2000: How to Resolve Reference Issues in an Access Database

    This article states in part:

    "Function is not available in Usage expression"

    "You may receive this error message if there is a problem with a programming type library, or if the code does not specifically call out the correct library and the file is listed at a lower priority in the reference list than a file that contains the same function name--for example, if DAO code is used with the ActiveX Data Object (ADO) library listed at a higher priority than the DAO library. You may also receive this error message if a form or a report contains an ActiveX control. "

    See article for details & how to fix.

    HTH

  3. #3
    New Lounger
    Join Date
    Sep 2003
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    The Problem is solved

    Thanks MarkD! <img src=/S/bow.gif border=0 alt=bow width=15 height=15>

    I didn't think obout the VB side of things. I copied the files in my reference list to the network folder and the fix works fine!

    Go PENS !

    CMC <img src=/S/flags/Pennsylvania.gif border=0 alt=Pennsylvania width=30 height=18>

Posting Permissions

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