Re: calling function without wait

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Of course

I build software to present table data
and i need to open the same form more then once (which is impossible as far
as i know).

In order to do so i have master form and when i "open table" i create copy
of the form in new name with table name.

When I close the form it will be deleted.

in order to do so i would like to create function that delete the form only
if it is not loaded. and to activate it i would like to run it from form
close and wait until it closed then delete it

"Stefan Hoffmann" <stefan.hoffmann@xxxxxxxxxx> wrote in message
news:eVfyeIzsHHA.1212@xxxxxxxxxxxxxxxxxxxxxxx
hi Roy,

Roy Goldhammer wrote:
When i run function from modul in access or in vb and call to diffrent
function, the exeution of the current function waits until the calling
function finished.
However if i use shell the function doesn't wait.
Huh? Can you give us an example, please?

Is there a way to call funcion that don't wait?
For functions in VBA this is not possible.


mfG
--> stefan <--


.

Relevant Pages

  • Re: Set permission to a folder
    ... "Cacls" is a command line program, ... Therefore, to call it from VBA, you need to use the "Shell" function. ... To get the correct options for your needs, test it out directly from the command line. ...
    (microsoft.public.excel.programming)
  • Re: shell function in VB
    ... you are effectively calling Shell as a Sub (no return value ... Now, for your question, the help files show it being appended to the end of ...
    (comp.lang.basic.visual.misc)
  • Re: Calling Add In Functions
    ... The previous code snippet I sent ... you explained about calling a managed class library from VBA. ... Uday Takbhate ...
    (microsoft.public.office.developer.automation)
  • Re: Enumerate records in Access Query
    ... You can do it with a subquery, as an alternative to calling a VBA ... E.g. if the records are sorted on the field Score, ...
    (microsoft.public.access.modulesdaovba)
  • Re: What happens in procedure 1 the very instant sub procedure 2 is called?
    ... That will be handy to know if there are any dependencies ... that depends entirely on what you're calling code does. ... it will return control back to the original ... >If, for instance, your called MySubmakes a call to Shell() it ...
    (comp.databases.ms-access)