Results 1 to 9 of 9
  1. #1
    New Lounger
    Join Date
    Jan 2004
    Location
    Salem, Oregon, USA
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access 2003 Form Doesn't display (2003)

    I'm running a fully updated Access 2003 in XP. The application syncronizes a set of replicas. All of the critical actions work properly, with a small annoyance. I would like to have something to amuse me while the app is running, so I built a modal popup form that displays the name of the replica being updated. I am writing the name to an unbound text box and repainting the form at every step of the loop. The actual synchronization process is kicked off by a sub call in the form's load event. The annoyance is, the form doesn't show. When it runs, either in full or development mode, all I see is an empty grey Access Frame, with an hourglass. The application quits when the replica set is finished, so it sits there for "n" seconds, then closes.

    Nothing I have been able to do will make the form display. I must be missing something obvious, but as you can see, I don't have a clue.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Access 2003 Form Doesn't display (2003)

    Does it help if you insert one or more DoEvents instructions in the loop?

  3. #3
    New Lounger
    Join Date
    Jan 2004
    Location
    Salem, Oregon, USA
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access 2003 Form Doesn't display (2003)

    I dim'ed IE as Integer, and added IE = DoEvents in the loop. As far as I can see, it has no effect on the display of the form.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Access 2003 Form Doesn't display (2003)

    Another thing you could try is to set the TimerInterval property of the form to 2000 (milliseconds, i.e. 2 seconds) or so, and to repaint the form in the On Timer event of the form:

    Private Sub Form_Timer()
    Me.Repaint
    End Sub

    I doubt that it will work, but who knows...

  5. #5
    New Lounger
    Join Date
    Jan 2004
    Location
    Salem, Oregon, USA
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access 2003 Form Doesn't display (2003)

    No Joy. You were right, it didn't have any effect either. OK, let's go another way. Is there anyway I can run the app in a "silent" mode where it doesn't pop up an Access screen at all? It is logging all of the activities, so if it didn't display, I could schedule it and read the log at my leisure.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Access 2003 Form Doesn't display (2003)

    You could use Automation to open an instance of Access from another application (Word, Excel, VB6) and run the code. The instance will be hidden by default.

  7. #7
    New Lounger
    Join Date
    Jan 2004
    Location
    Salem, Oregon, USA
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access 2003 Form Doesn't display (2003)

    You have a fine, sneaky, mind, Hans. I'll give it a try. Thanks for the good advice.

  8. #8
    New Lounger
    Join Date
    Jan 2004
    Location
    Salem, Oregon, USA
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access 2003 Form Doesn't display (2003)

    I took the code off of the Form Load Event, and put it on a command button. Set up that way, the form displays when the application is run, and shows the replicas as synchronization proceeds. Strange are the ways of Access.

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Access 2003 Form Doesn't display (2003)

    Thanks for the update.

Posting Permissions

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