Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2010
    Posts
    5

    Unanswered: Possible to "run application" from access 2010?

    In access 2005, I used to be able to create buttons that would open up programs from the database. The wizard would come up, and under "appliation" it gave options of word, excel, or "run application" where I'd go find the location of the program. With the 2010 access version, whenever I use the command button wizard and choose "application" the only option is "quit application". Is there any way to be able to launch an application like word, or excel from the database? I have a mailing service application that I'd like to put on the database. thanks.

  2. #2
    Join Date
    May 2010
    Posts
    601
    Try using the Shell() command.

    The is what the command button wizard creates in 2003:

    Code:
        Dim stAppName As String
    
        stAppName = "c:\full_path\app.exe"
        Call Shell(stAppName, 1)
    Hope this helps ...
    Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

  3. #3
    Join Date
    Jul 2010
    Posts
    5
    That did it, thanks a million!

  4. #4
    Join Date
    May 2010
    Posts
    601
    Quote Originally Posted by lycialive View Post
    That did it, thanks a million!
    You're welcome.

    Glad I could assist.
    Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

Posting Permissions

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