Results 1 to 4 of 4

Thread: Progress Bar - Delay then works

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Oct 2000
    Posts
    98

    Exclamation

    I am submitting data to an excel spreadsheet from VB and it takes time to complete after clikcing on the cmdSubmit

    I placed a progress bar to show the progress ...

    This is what happens:

    I click on the command button and then the hour glass appears (at this time, I want my progress bar to be working) once the hour glass vanishes the progress bar will run..

    Can anyone please help me????


    Steve

  2. #2
    Fanatic Member Dim's Avatar
    Join Date
    Jul 2000
    Posts
    620
    somethng like:
    Code:
    If Form1.MousePointer = "11" Then
        'progress bar code
    Else
        'stop progress bar code
    End If
    Or is it the progress bar code that you need?

    D!m
    Dim

  3. #3
    _______ HeSaidJoe's Avatar
    Join Date
    Jun 1999
    Location
    Canada
    Posts
    3,946

    <?>

    If possible you should display your code. It might help others see the problem at a glance instead of wondering what the problem might be.
    "A myth is not the succession of individual images,
    but an integerated meaningful entity,
    reflecting a distinct aspect of the real world."

    ___ Adolf Jensen

  4. #4

    Thread Starter
    Lively Member
    Join Date
    Oct 2000
    Posts
    98

    Progress Bar Reply

    Thank you both...

    I do not code for the progress bar...

    What happens is when I click on the button nothing happens for a minute or so and then the code for the progress bar runs... at this point it is too late..

    i am putting this in the cmdbutton

    pg1.Value = 0
    pg1.Visible = True
    tmrProgress.Interval = 1000

    I tried this :
    If frmExpense2.MousePointer = "11" Then
    pg1.Value = 0
    pg1.Visible = True
    tmrProgress.Interval = 1000
    Else
    'stop progress bar code
    End If


    but i am not always getting the hour glass... just the mousepointer..


    Can you please help Steve

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