Results 1 to 5 of 5

Thread: preventing HALT of VBA MS access code

  1. Mar 24th, 2007, 12:52 PM #1
    Asher David
    Asher David is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Jun 2006
    Posts
    263

    Question preventing HALT of VBA MS access code

    Hi,

    I created a code that will quit MS access application. But before that it will give a MessageBox before it will quit. But it seems that I can press CTRL-ALT-BREAK then the code will not continue quitting the application.

    Is there a way to disable this thing?

    Thanks a lot!
    "Its easy to teach FAITHFUL MAN to be ABLE than ABLE MAN to be FAITHFUL"
    Reply With Quote Reply With Quote
  2. Mar 24th, 2007, 04:40 PM #2
    salvelinus
    salvelinus is offline
    Frenzied Member
    Join Date
    Feb 2003
    Location
    Argentina
    Posts
    1,950

    Re: preventing HALT of VBA MS access code

    Can you post your code & be more specific? For example, at what point are you pressing Ctrl... I don't have a Break key on my keyboard.
    Ctrl-Alt-Delete is a Windows operating system operation that brings up the Task Manager. Ctrl-C is a DOS break operation, although I don't hit ALT.
    Tengo mas preguntas que contestas
    Reply With Quote Reply With Quote
  3. Mar 26th, 2007, 12:51 PM #3
    Asher David
    Asher David is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Jun 2006
    Posts
    263

    Re: preventing HALT of VBA MS access code

    BREAK is the same key at PAUSE

    CTRL-ALT-BREAK is the one im using to stop/halt the macro on running.
    "Its easy to teach FAITHFUL MAN to be ABLE than ABLE MAN to be FAITHFUL"
    Reply With Quote Reply With Quote
  4. Mar 26th, 2007, 08:53 PM #4
    salvelinus
    salvelinus is offline
    Frenzied Member
    Join Date
    Feb 2003
    Location
    Argentina
    Posts
    1,950

    Re: preventing HALT of VBA MS access code

    I don't use macros, but fromthis I'd guess you're stopping execution of the macro. This is likely a designed function in Access, don't know if you can prevent it.
    Tengo mas preguntas que contestas
    Reply With Quote Reply With Quote
  6. Mar 27th, 2007, 12:39 PM #5
    Asher David
    Asher David is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Jun 2006
    Posts
    263

    Re: preventing HALT of VBA MS access code

    do you have any idea just to continue the MS access quitting?
    "Its easy to teach FAITHFUL MAN to be ABLE than ABLE MAN to be FAITHFUL"
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width