Results 1 to 13 of 13
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Undefined function

    Undefined function

  2. #2
    Lounger
    Join Date
    Nov 2001
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Undefined function

    Yet another missing References problem

  3. #3
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Undefined function

    Hi Rich

    I checked the nine references on development computer and are identical to customer computer, event same sequence, application complies clean on customer computer.

    Thanks, John

  4. #4
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Undefined function

    Odd situation. You can download the Office Service Releases from Microsoft. I think the URL is http://officeupdate.microsoft.com
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

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

    Re: Undefined function

    I've seen that message when there was something wrong with the punctuation of an expression, parens out of place, etc. Then it will look at anything that comes after what it sees as the end of the expression and say "Huh? I don't recognize that!" Your Nz expression doesn't return an empty string as a default, so if it is null, you should NOT see "Open", and the NumberOfDays function will probably fail also. That may be your problem. If providing a default in the Nz expression doesn't cure it, try changing the expression inside the Right() function to a simple string and see if it still complains about the Right() function.
    Charlotte

  6. #6
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Undefined function

    Hi Charlotte

    You said

    "Ttry changing the expression inside the Right() function to a simple string and see if it still complains about the Right() function"

    How do I cheange this to simple string?

    Days: IIf(Nz([Certificate])="","Open",Right(" " & NumberOfDays([Begin],[Certificate],True),4))

    Thanks, John

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

    Re: Undefined function

    What Charlotte means is something like this:
    Days: IIf(Nz([Certificate])="","Open",Right(" " & "abcdef"))
    If this is working you have a problem with the NumberOfDays function and not with the Right function.
    Francois

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

    Re: Undefined function

    Close, Francois, but you left out the number of characters in the Right function.

    Days: IIf(Nz([Certificate])="","Open",Right(" " & "abcdef",4))

    I also suspect that a Null [Certificate] may be part of the problem, since that's being fed into the NumberOfDays function as well. Might also want to try this:

    Days: IIf(Nz([Certificate], "")="","Open",Right((" " & NumberOfDays([Begin],[Certificate],True)),4))
    Charlotte

  9. #9
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Undefined function

    Hi Charlotte & Francoisl

    I got the following from another board:

    If you created the database on an SR-1 machine and then try to run it on a
    "plain vanilla" one, the internal version numbers of the librarieswon't
    match, even if all the names are the same and in the same sequence. You
    must unset and reset the references on the customer machine and recompile.

    I did'nt mention this to you,does this sound like the culprit?

    John

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

    Re: Undefined function

    Since I'm on the loung a had a number of "US" database that I look at.
    I never had that problem.
    I have Office 2000 Developer Edition English International with SR1.
    I you want you can attach the db or send it to me by email (see my profile) and I'll test it.
    Francois

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

    Re: Undefined function

    <img src=/S/confused.gif border=0 alt=confused width=15 height=20> I have no idea which libraries they're talking about, so I can't advise you. Of course, they may be talking about later versions of ADO, but that's really a different issue.

    Were you trying to run your query on a plain vanilla machine? Like Francois, I haven't run into this problem, but in any case it shouldn't apply if both machines are running SR-1. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Charlotte

  12. #12
    Star Lounger
    Join Date
    Jan 2001
    Location
    Yorkshire, England
    Posts
    82
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Undefined function

    i would suggest you get down to the simplest test possible.
    Go to the immediate window in VBA editor and type

    ?right("abcdef",3)

    which should reply

    def

    if it does there is nothing wrong with Right() and you need to dig deeper as Charlotte suggested

  13. #13
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Undefined function

    Hi All

    I originally created the db and query on SR-1 (9.0.3821) machine and it worked.

    I copied it to a customers machine that had,

Posting Permissions

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