image - visible and not visible options...

[bgseib]

This will be easy for most probably... I have a button that calls 9 SP's in sequence, and I am wanting to display an image for the user while a sp is running and once it completes and the nest sp starts the image will go to invisible and the next image will become visible.
I am doing the same now with message boxes, but would like to change to images that automatically open and close for the viewer to have something to make the time go by faster...

sample so far:

cnn.execute ("sp_1")
MsgBox "stage 1"
cnn.execute ("sp_2")
MsgBox "stage 2"
cnn.execute ("sp_3")
MsgBox "stage 3"

etc.. I would like to change the message box to a image.. And ideas???

Thanks,
Brian

 

[Cosmos75]

What is an SP and what does cnn.execute ("sp_1") do?

 

[The_Doc_Man]

I would assume SP is subprogram or an external image file or a humongous ODBC query or something like that?

Define several image boxes, each with one of the images you wanted to show. Set all of their default properties to .Visible = false.

Design your code to adjust the position of the image boxes at run time. I.e. between executions, rather than activate a message box, insert some code to muddle around with the properties of one of your image boxes. Check the image box properties list for the .Top and .Left properties. You can make them move to where you want within the Access window at run time by asserting new values to these items. You can also just set the .Visible to true or false as you wish.

 

[ElsVanMiert]

I suggest that you replace the messagebox (which requires a reaction of the user) with a pop-up form displaying a JPG or GIF and an on-timer-event that closes the form automatically after a short period of time.

 

[bgseib]

SP = Stored Procedure (on SQL Server)

I actually did the same thing as suggested - I created 10 forms with status bars on them. The first one with 10 % complete, then 20, then 30 and so on. The problem I am having is that the sp's run so fast that the status forms do not have time to repaint.. In other words the forms will only show up when the sp takes at least 10 seconds to run... I wonder if there is a repaint call I can call when I change the visible properties on the form to force it to show even if it is just for a second or two...??

Brian

 

[The_Doc_Man]

me.repaint