Results 1 to 5 of 5
  1. #1
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Function not available

    Geoff,

    Can you fix that URL?
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  2. #2
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Function not available

    Anyway, without seeing the original post, I'd ask "can you reproduce the error condition?"

    If so, what happens when you use mid$ instead of mid?
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  3. #3
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Function not available

    Hi,

    Charlotte has brought my attention to a post in Access, which I thought would be worth while posting here to the wider VBA community.

    I've had the situation occassionally where I've had the message "function not available", pointing to a simple function like "mid".

    The original post referred to a problem in a query- but as I've seen the same problem in VBA I thought it was worth while bringing attention to the post.

    Here's the <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=acc&Number=31802&Search =true&Forum=acc&Words=&Match=StarPost&Searchpage=0 &Limit=25&Old=allposts&Main=22047>link</A>
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  4. #4
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Function not available

    Kevin,

    Hopefully the link is fixed now.

    This is not reproducible. Mid$ did not fix it. It happened to on one machine, I could not fix it. I had to get the machine reimaged to do it.

    I see from the post referred to that I just needed to correct a dll.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  5. #5
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Function not available

    Geoff,

    Here's my post to the cross-post you posted. (post haste)

    Andrew,

    Geoff posted your post in the VBA forum which is where I saw it. I have an idea. Since you are developing in Access 2000, the database engine [could be] | [is] | [is not] MSDE -- the SQL Server engine.

    I don't know if Access 2000 allows you to select JET or MSDE, but if you are using MSDE, then the query syntax is based on the SQL-TransAct language. In that language there is no MID function -- at least there wasn't back in SQL 6.x (please correct this if incorrect). There is a SUBSTRING function, however, that accomplishes the same thing. How about trying the query with SUBSTRING instead of MID?

    Just a thought.
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

Posting Permissions

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