Results 1 to 4 of 4

Thread: Big Trouble

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Oct 1999
    Posts
    253

    Unhappy

    Hello.

    I am trying to run a query asynchronously by using this statement:

    RecSet.Open ...,...,...,adAsyncFetch

    The recordset is declared in this line:

    Dim WithEvents RecSet As ADODB.Recordset

    I have inserted code in the FetchProgress and the FetchComplete events of the recordset object in order to update a progress bar on a form.

    The problem is that the events just don't seem to occur at all!!! I have executed my program and waited around 3 minutes for the progress bar to be updated but nothing has happened!

    Can someone help me please? I must finish this project until the end of the week!!!

    Thanks!!!

  2. #2
    Guest
    did you use 'WithEvents' when declaring your Recordset?

  3. #3
    Guru Clunietp's Avatar
    Join Date
    Oct 1999
    Location
    USA
    Posts
    1,844
    does your withevents declaration reside at module level or procedure level?

    are you handling the events?

  4. #4

    Thread Starter
    Addicted Member
    Join Date
    Oct 1999
    Posts
    253

    Unhappy

    The recordset is declared at module level, of course. I have no idea what the problem is.

Posting Permissions

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



Click Here to Expand Forum to Full Width