Results 1 to 6 of 6
  1. #1
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Sending Commands to other Applications (ACCESS 2000)

    I am using MS Access to launch the DOS prompt using START / RUN / CMD in a Windows NT environment. Once the DOS prompt is present, is there a way to send and execute commands via the Access Macro?
    <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23>
    Regards,

    Gary
    (It's been a while!)

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Sending Commands to other Applications (ACCESS 2000)

    Are you talking about a macro or VBA code? And what are you trying to do? About all you can do at the DOS prompt from Access is run a batch file. Most things you would normally do from Access (i.e., change directory, find a file, kill a file, etc., already have command available from code to do the same thing without using the command prompt.
    Charlotte

  3. #3
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Sending Commands to other Applications (ACCESS 2000)

    Charlotte,
    Right now, I am using a Macro but could use VBA code as well. I am trying to launch an application that creates an MPM flat file. At the dos prompt, you would type in the command MPMRRF which starts an MPM application that creates a data file. When the data file is complete, I would return back to Access.

    How would you launch the batch file from MPM after the DOS prompt is activiated?

    Thanks for your help
    Regards,

    Gary
    (It's been a while!)

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Sending Commands to other Applications (ACCESS 2000)

    I believe you can launch them both at the same time by passing the batch file as an argument when you call the command prompt.
    Charlotte

  5. #5
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Sending Commands to other Applications (ACCESS 2000)

    Charlotte,

    Thanks for the advice. I will give it a try and let you know of the outcome.

    Gary

    <img src=/S/cool.gif border=0 alt=cool width=15 height=15>
    Regards,

    Gary
    (It's been a while!)

  6. #6
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Sending Commands to other Applications (ACCESS 2000)

    Hi Charlotte,

    I finally was able to try this, however, could not get it to work. I can start the command prompt, but seem to be unable to pass the batch file. I will try it again.

    Thanks for your input.
    Regards,

    Gary
    (It's been a while!)

Posting Permissions

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