Re: Compile error when using the Mid,Left and right function in VB code [Multipost]

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Veign (NOSPAMinveign_at_veign.com)
Date: 05/05/04 

Date: Wed, 5 May 2004 11:49:29 -0400

[Multipost] 

-- 
Chris Hanscom
MVP (Visual Basic)
http://www.veign.com
--
"John in St Louis" <jminnich@energypetro.com> wrote in message
news:AA52DEAA-F243-43D5-9034-8E78E436CE98@microsoft.com...
> I have written a business application that uses the following IF
statement:
>
> If Val(Mid(myTab, 5, 2)) = 2 Then
>
> However, not all the time but, sometimes the program bombs due to a
compile error that highlights the "MID" function and indicates "Can't find
project or library".  I can highlight Mid and press "F1" and VB help opens
the Mid function properly and there appears there is no problem but I can't
fix the compilation error.  The VB 6.0 macro is running from an Excel 2000
workbook.  I have also tried to add all relevant reference libraries but
still have found no solution.
>
> If anyone has a solution to this problem, please email me.  Thanks
>
> John in St. Louis

Relevant Pages

  • Re: yesterdays menu
    ... Ararilla at 10:00 and St. Louis at noon, ... john wrote: ... Wendy approached in a waffle house waitress outfit ... the coffee was so smoking hot giving me a facial ...
    (rec.motorcycles.dirt)
  • Re: Court of Appeal judge accused of flashing (Formula 1 spoilers!)
    ... I may need some help from a legal aid lawyer. ... I am glad Louis got a win. ... I take it there was a nasty accident. ... I watched last night on the 'highlights' prog. ...
    (uk.legal)
  • Re: Morning Smoke, Wednesday 1/2/2008
    ... Don't sell your mittens yet, it was 9F in St. Louis this morning, but ... I had a no-name bulldog with Vintage Virginia from John Dengler's this ...
    (alt.smokers.pipes)
  • Re: Compile error in vb6 code [MULTIPOST]
    ... MVP ... I have activated all the reference libraries that appear even remotely related with no solution and it now takes a lot of time to open the file. ... > John in St Louis ...
    (microsoft.public.vb.general.discussion)
  • Re: DSum Problem
    ... "John W. Vinson" wrote: ... When I click ok to clear the message, it>highlights the ... >I made a beginner's attempt at moving the quotes around and>adding/removing ...
    (microsoft.public.access.queries)