Results 1 to 7 of 7
  1. #1
    Join Date
    Jan 2004
    Location
    OHIO
    Posts
    75

    Lightbulb Unanswered: Loader in access...

    I have a volunteer database in which i have split and applied users and permissions to. However, it takes about a minute for a user to login, i guessing because i have a major form opening on load. I was wondering if there is a way for when a user goes to login that a loading window appears and says, "Please be patient...logging you into the system..." or something to that affect. I need it to show a status meter and then once it is 100% it automatically closes and opens the main form.

    Does anyone have any experience with this or could help me out. Thanks!

    Best,

    B

  2. #2
    Join Date
    Aug 2004
    Posts
    1

    Talking Beautiful...

    I actually have a database that tracks our inventory and it takes a minute to login. I need a loader that you are talking about too. Does anyone know how to put one together? Come on, someone can help can't they?

    Sincerely,
    -Miss. Aqua

  3. #3
    Join Date
    Jan 2004
    Location
    OHIO
    Posts
    75

    well, i guess no one knows how....

    Miss. Aqua,

    It seems that no one on the forum knows how to address our issue.

    Best,

    B
    Last edited by ironchef; 08-24-04 at 10:38.

  4. #4
    Join Date
    Jan 2004
    Location
    Toronto, Canada
    Posts
    259
    There is a way, however, it is not powerful enough to give you an accurate estimate of the percentage completion of the loading process. it just tells you if the form is loaded.

    If CurrentProject.AllForms("Form Name Here").IsLoaded = True Then



    End If


    To make this a loop, add a sleep timer... so in a loop statement, add this statement, then Sleep 100 and it will keep doing this loop until the condition is satisfied.

  5. #5
    Join Date
    Jan 2004
    Location
    OHIO
    Posts
    75

    status bar

    is there a way to show a status bar at least. It does not need to show the perecentage per say, but at least a bar the fills up as it loads...

    Thanks in advanced,
    b

  6. #6
    Join Date
    Jan 2004
    Location
    Toronto, Canada
    Posts
    259
    If you go to the ToolBox when your in form design mode,
    and click on the hammer icon "More Controls",
    scroll down to Microsoft ProgressBar Control SP 6.0 (i think),
    or SP 5.0,

    and insert that into your form.

    To control the slider,
    in your form.Load, initialize the loader to have these values,

    if your progressbar is named progbar1,

    progbar1.Max = 100
    progbar1.Min = 0

    and in your loop which was mentioned earlier you can increment the values of the progressbar by

    progbar.Value = 50 'you can put any value from 0 - 100

  7. #7
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    since you can't predict login time and you can't measure "partial" login, you have to cheat.

    attached is a non-linear status bar scam... maybe you can combine something like this with Jerrie's .isloaded to produce the desired (but faked) effect.

    izy
    currently using SS 2008R2

Posting Permissions

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