Re: Best Error Trap

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Norm Cook (normcookNOSPAM_at_cableone.net)
Date: 10/07/04

  • Next message: Michael A. Gunther: "Re: Adjusting Field Size" 
    Date: Thu, 7 Oct 2004 07:48:50 -0500

    Many thanks, that does the trick nicely.

    "Pawel Durys" <pdurys@op.pl> wrote in message
    news:ck170b$m30$1@news.onet.pl...
    > "Norm Cook" <normcookNOSPAM@cableone.net> wrote in message
    > news:10m852qgmip2a33@corp.supernews.com...
    > > Is there a standard method to check the results of a VB query?
    > > For example
    > > Set RS = DB.OpenRecordSet(SqlQuery)
    > >
    > > I've tried
    > > If Not RS Is Nothing
    > > 'doesn't seem to work-returns a RS object but I guess RecordCount is
    > > zero?
    > >
    > > On Error Resume Next
    > > RS.MoveLast
    > > If RS.RecordCount = 0 '
    > >
    > > Can't seem to get my head around this.
    > >
    >
    >
    > Maybe check out BOF and EOF property at the same time.
    >
    > --
    > Bye
    > Pawel Durys
    >

  • Next message: Michael A. Gunther: "Re: Adjusting Field Size"

    Relevant Pages

    • Re: Best Error Trap
      ... "Norm Cook" wrote in message ... > Is there a standard method to check the results of a VB query? ... Pawel Durys ...
      (microsoft.public.vb.database.dao)
    • Best Error Trap
      ... Is there a standard method to check the results of a VB query? ... 'doesn't seem to work-returns a RS object but I guess RecordCount is zero? ... Can't seem to get my head around this. ...
      (microsoft.public.vb.database.dao)