how 2 abort Query unload?????help 
Author Message
 how 2 abort Query unload?????help

I have a prob.....I want to abort the query unload procedure.

query_unload executes...checking a certain flag...  if this flag is true, I
want to show a msg box....of CANCELID (1  i think) is chosen, I want to BAORT
query unload...is there a way to do tjis??????

pleez help if you even have an idea of which way to look for the answer.

thanx in advance
Tim

--
_______________________________________________|_|________|__/_________________
Tim Hockin -- STV 414b 438-7770      |         | |  _   _ |/
I.S.U. Art Education                 | | |\/|  | | |_| |_ | \ | |\|
"Don't dream it, be it" Frank-N Furter - The Rocky Horror Picture Show



Tue, 07 Oct 1997 03:00:00 GMT  
 how 2 abort Query unload?????help

Quote:
(Tim P. Hockin) writes:

> I have a prob.....I want to abort the query unload procedure.

> query_unload executes...checking a certain flag...  if this flag is true, I
> want to show a msg box....of CANCELID (1  i think) is chosen, I want to BAORT
> query unload...is there a way to do tjis??????

In your QueryUnload routine you can indicate that the form should NOT be unloaded by
setting the Cancel parameter to True before exiting from the QueryUnload sub.

----------------------------------------------

Axiomatic Software   CIS: 100273,154
"i forgive you molesworth for those uncouth words"



Tue, 07 Oct 1997 03:00:00 GMT  
 how 2 abort Query unload?????help

Quote:

>Subject: how 2 abort Query unload?????help
>Date: Fri, 21 Apr 1995 17:29:11 GMT
>I have a prob.....I want to abort the query unload procedure.
>query_unload executes...checking a certain flag...  if this flag is true, I
>want to show a msg box....of CANCELID (1  i think) is chosen, I want to BAORT
>query unload...is there a way to do tjis??????
>pleez help if you even have an idea of which way to look for the answer.
>thanx in advance

Hi Tim
Wouldn't be much use for having a QueryUnload if you couldn't cancel the
unload event. Check QueryUnload in on-line help.

------------------------------------------------------------------------
Chuck Stuart - Mesquite TX USA  
VBTrace 2.00 is a runtime Procedure Trace, XRef,
Debug, Profiler and much more. Shareware $49.
http://www.apexsc.com/vb/ftp/coop/cstuart
ftp.apexsc.com/pub/cgvb/coop/cstuart
------------------------------------------------------------------------



Tue, 07 Oct 1997 03:00:00 GMT  
 how 2 abort Query unload?????help

Quote:
>I have a prob.....I want to abort the query unload procedure.

>query_unload executes...checking a certain flag...  if this flag is true, I
>want to show a msg box....of CANCELID (1  i think) is chosen, I want to BAORT
>query unload...is there a way to do tjis??????

You can get out of the QueryUnload procedure with the Exit Sub command.
If you want to prevent the form from closing, set Cancel to True
before doing Exit Sub.

Jason
_____________________________________________________________________
Jason Simmons               Author of VBScript - a scripting language

                (ftp.cica.indiana.edu : programr/vbasic/vbscript.zip)



Tue, 07 Oct 1997 03:00:00 GMT  
 how 2 abort Query unload?????help
<<I have a prob.....I want to abort the query unload procedure.>>

As is clearly explained in VB's online help, you simply set the Cancel
parameter in the form's QueryUnload subroutine to some non-zero value.

Mani Visweswaran



Wed, 08 Oct 1997 03:00:00 GMT  
 
 [ 5 post ] 

 Relevant Pages 

1. aborting a query

2. Query Unload

3. Query Unload in VB.net?

4. help!!!! need to abort program

5. query unload with a select case question

6. Query Unload Question

7. query unload of MDI child question

8. Query Unload Event ?

9. HELP: ASP / SQL Server connection hangs when user aborts processing

10. Run update query on unload or refresh?

11. HELP: How do I notify monitoring app of logical abort

12. Unloading modal owner form also unloads modal form?

 

 
Powered by phpBB® Forum Software