Solved

showing form while...

Posted on 1998-09-02
3
141 Views
Last Modified: 2010-04-30
What is the best way to show form while another forms sub is running?

I've got a form where user gives some information and then pushes the save button which runs SaveDatabase sub and that saving can take a while. I would like show some kind of "Saving in progress..." form there and it would disappear when saving is done.

Anybody any ideas where I could find some nice saving animations?

Thanks in advance!
0
Comment
Question by:majala
  • 2
3 Comments
 
LVL 14

Accepted Solution

by:
waty earned 50 total points
ID: 1432526
Do as follow :

Sub SaveDatabase()

    FormWait.show
    doevents
   
    '*** Here save your database
    ...
    ...

    '*** Work is done

    unload FormWait

End Sub
0
 

Author Comment

by:majala
ID: 1432527
Is there any way to do this if those both forms are modal?
0
 
LVL 14

Expert Comment

by:waty
ID: 1432528
The only way, is doing the save database in your modal waiting form.

See your other question for some more details.
0

Featured Post

ScreenConnect 6.0 Free Trial

At ScreenConnect, partner feedback doesn't fall on deaf ears. We collected partner suggestions off of their virtual wish list and transformed them into one game-changing release: ScreenConnect 6.0. Explore all of the extras and enhancements for yourself!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Article by: Martin
Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question