Link to home
Start Free TrialLog in
Avatar of dosyl
dosyl

asked on

Shell versus Modal

Private Sub mnuSauvDonn_Click()
'Save the database in the drive a:
'To save the .mdb, we must to close the database.

    rstProfil.Close
    rstCli.Close
    dbCli.Close

Shell "d:\pkzip\pkzip.exe a:\GesKaSyDo.zip d:\geskasydo\GesKaSyDo.mdb", vbHide

'The sub Ouverture reopen the database because the pgm. is not finished.

'My problem is here the sub OUVERTURE must to run only when the shell have finished to save the database, because the database is not saved if the database is reopen.
'I need something like a shell modal.
'Or where i must to reopen the database?

Ouverture
End Sub
Avatar of mark2150
mark2150

Use the ExecCmd instead of SHELL. This will wait for the child to complete before continuing. Source code in "Code Snippets" section of my web page:

www.cyberchute.com/rvbus/madmark

M
ASKER CERTIFIED SOLUTION
Avatar of mark2150
mark2150

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of dosyl

ASKER

Mark2150, I want more Information. Your pgm. works but:
Where do you put vbHide or another one like in the shell, because i don't want the user see the window of the application.
If you can describe your variables in the Type and your functions i'd like that.
Can i remove some parts or i need all?

You can write to me at :
dosyl@sympatico.ca
Avatar of dosyl

ASKER

Mark2150, I want more Information. Your pgm. works but:
Where do you put vbHide or another one like in the shell, because i don't want the user see the window of the application.
If you can describe your variables in the Type and your functions i'd like that.
Can i remove some parts or i need all?

You can write to me at :
dosyl@sympatico.ca
You set the properties of the PROGRAM you're running. Set it to RUN MINIMIZED and CLOSE ON EXIT and it'll run with just a flicker down in the taskbar.

TYPE declares were lifted from MS page, I didn't write. They always work so I just leave 'em as is. No, I don't think you can remove much and expect it to continue to work.

M
Avatar of dosyl

ASKER

Where do you set these properties? You don't have a page of properties in a Dos
program, and if it is a windows program how to access to the properties of a program that is not in my pgm. it is not a Form. How do you put Run Minimized and Close on exit?
If you browse to *any* DOS program and right click it'll *create* a properties page automagically. Click on "program" tab and you're choices will be there!

M
Avatar of dosyl

ASKER

Another question when i do what you writed, my pgm. become minimized too how to see always my pgm. when the .exe is running? I could to put a progress bar too, i believe.
Avatar of dosyl

ASKER

MarkI250 don't answer to my last comment. The pgm. is minimized only in VB when it is a .exe the pgm. stays maximized.
Ok, is there a Q in here? Where are we now?

M
Avatar of dosyl

ASKER

No there is no question in the last comment, i answer to the previous comment.