Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by LogisticsNGR

  1. LogisticsNGR

    Shell Command from Access VBA - Alert Access When Finished

    Excellent. Very helpful. Thank you.
  2. LogisticsNGR

    Shell Command from Access VBA - Alert Access When Finished

    It can run for hours depending on the size of the problem. not a huge deal for me since i will be the only one using access to call AMPL. but i was curious since VB has a SHELL command with a time parameter that allows you to state how long to wait on the application before moving. i do not...
  3. LogisticsNGR

    Shell Command from Access VBA - Alert Access When Finished

    Thank you PH. It also worked perfectly and clearly is shorter. One question: How long would it wait for the called application to complete? Forever? Is there a way to set a time limit?
  4. LogisticsNGR

    Shell Command from Access VBA - Alert Access When Finished

    Thanks to both TomThumb and p27. The latter's code worked perfectly.
  5. LogisticsNGR

    Shell Command from Access VBA - Alert Access When Finished

    I am using the 'shell' command from within Access to run an external application (AMPL -- an optimization software). How do I make it so that Access knows when AMPL is done running so that I can automatically import AMPL's solution file? Any help is appreciated.
See more

Part and Inventory Search

Back
Top