Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2003
    Posts
    104

    Unanswered: Closing And Restarting Access in "Admin" View

    Hi All,
    I was wondering if there is a way to
    1.) Close Microsoft Access and Restart it
    2.) simulate holding down the "shift" key as access is being restarted.

    Please look at the attached image. It should help explain what I am trying to acheive

    Check Pic --> http://shassouneh.homestead.com/file...restarting.jpg

    Any and all feedback would be much appreciated.

    Thanx

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    I don't think you can restart the ACCE$$ again, because when you exit ACCE$$ you will not be able to execute any more commands

    To exit Acce$$ you can use
    SendKeys "%{F4}", True
    OR
    Application.Quit acPrompt

  3. #3
    Join Date
    Nov 2003
    Posts
    104

    yes, but...

    Quote Originally Posted by hammbakka
    I don't think you can restart the ACCE$$ again, because when you exit ACCE$$ you will not be able to execute any more commands

    To exit Acce$$ you can use
    SendKeys "%{F4}", True
    OR
    Application.Quit acPrompt
    That is true. HOWEVER, You can always do somehting like the following pseudo-code

    Run External App "AppName FileName.ext"
    Close Accesss

    The true problem here is simulating holding down the shift key As access is starting up. Please see the attacheed image in the original post for more details

  4. #4
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Quote Originally Posted by shassouneh
    That is true. HOWEVER, You can always do somehting like the following pseudo-code

    Run External App "AppName FileName.ext"
    Close Accesss

    The true problem here is simulating holding down the shift key As access is starting up. Please see the attacheed image in the original post for more details
    That is also True, you can do start your application then end Acce$$.

    Simulating pressing SHIFT key can not be made. Because when you open the .mdb file you don't have any written code from you to be run. Perhaps try some advanced commands of the old DOS. (Not sure)

  5. #5
    Join Date
    Nov 2003
    Posts
    104
    Quote Originally Posted by hammbakka
    That is also True, you can do start your application then end Acce$$.

    Simulating pressing SHIFT key can not be made. Because when you open the .mdb file you don't have any written code from you to be run. Perhaps try some advanced commands of the old DOS. (Not sure)
    The Only thing I cna think of is an over ride. Like say if you use a command Line switch to similar to the following:

    RunMe.bat

    MsAccess.EXE /override AccessDbFileName.mdb

    the only problem is I wonder if Microsoft Access has such a switch that over rides any code or settings

Posting Permissions

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