Results 1 to 7 of 7
  1. #1
    Forbes's Avatar
    Forbes is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Mar 2017
    Posts
    133

    Command Line through Access

    I am curious, is there a way to:

    A) Run cmd Prompt scripts on a form (with the command Prompt window not displaying) but instead....
    B) Echo the results into a text box?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Access is a GUI.
    command lines went out in the 90s.

  3. #3
    Forbes's Avatar
    Forbes is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Mar 2017
    Posts
    133
    No offense but as a Linux server admin I disagree respectively of course . I am aware that a Form presents a Graphical Interface, but I am in need of this information regardless.

  4. #4
    jwhite is offline Competent Performer
    Windows 10 Access 2013 32bit
    Join Date
    Dec 2012
    Location
    North Carolina
    Posts
    349
    What you are looking for is not supported in MS-Access.

  5. #5
    Forbes's Avatar
    Forbes is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Mar 2017
    Posts
    133
    Shell "cmd /c > echo [txtbox]"

  6. #6
    jwhite is offline Competent Performer
    Windows 10 Access 2013 32bit
    Join Date
    Dec 2012
    Location
    North Carolina
    Posts
    349
    Well, of course you can shell out from Access, nothing new there; you want to update a text box on an open form from outside of MS-Access. Totally different animal, and can't be done from a third party application. It may be remotely possible to do it from another MS-Access database.

  7. #7
    Forbes's Avatar
    Forbes is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Mar 2017
    Posts
    133
    What I did was used Batch as string then the print option to create the batch file with the commands I want which then "Echo" to name.txt then the text box echos the results in the text file, once the DB is closed the text files are deleted.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. opening access from vb 6.0 - command line error
    By john1951 in forum Programming
    Replies: 1
    Last Post: 03-20-2013, 06:42 AM
  2. Replies: 6
    Last Post: 09-14-2012, 11:58 AM
  3. Replies: 1
    Last Post: 01-24-2012, 12:47 AM
  4. query Access databases from the command line
    By xinelo in forum Programming
    Replies: 9
    Last Post: 11-09-2011, 09:08 AM
  5. Replies: 2
    Last Post: 10-11-2010, 03:15 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums