Results 1 to 11 of 11
  1. #1
    tobydobo is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Sep 2011
    Posts
    169

    How to launch and application or file from a command button

    Hello newbie here!



    I just created a new db using Microsoft's Contact List db as a template. I have modified the fields and imported all my data, now I just need to tweak it to make it more functional.

    One thing I am looking at doing is putting command buttons on my forms to launch various apps, websites, and email templates. Seems simple enough but there isnt an option for these in the commmand button wizard so I assume some coding is involved. Any help would greatly be appreciated.

  2. #2
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529

  3. #3
    tobydobo is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Sep 2011
    Posts
    169
    Thanks! So for a website...would I just enter the same code except use an URL in the place of the app location?

  4. #4
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    Code:
    Private Sub cmdOpenLink_Click()
    
    Application.FollowHyperlink _
        "http://www.liberty1st.org"
    
    End Sub

  5. #5
    tobydobo is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Sep 2011
    Posts
    169
    Thanks Alan! Where do I mark solved?

  6. #6
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    Click on Thread Tools above your original posting.
    Alan

  7. #7
    tobydobo is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Sep 2011
    Posts
    169
    oh just remembered....I also need a button that resorts my contact list form from A to Z for a specific column. Currently when I try to remove a filter from a search, it resorts out of order.

  8. #8
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    Is your list in a query or a datasheet in a form?

  9. #9
    tobydobo is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Sep 2011
    Posts
    169
    im using the standard contact list template...its in the form view currently. I save the db with one of columns sorted. Any time I do a quick search on the form itself, then remove the filter afterwards, the list is all out of order.

  10. #10
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    Look at this video. Access saves tables in the order they were entered.
    http://www.datapigtechnologies.com/f...tingtrick.html
    Alan

  11. #11
    tobydobo is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Sep 2011
    Posts
    169
    thats got it ! thanks Alan.

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

Similar Threads

  1. Command Button to Find .doc file
    By cg1465 in forum Forms
    Replies: 8
    Last Post: 09-15-2010, 08:28 AM
  2. Replies: 1
    Last Post: 07-27-2010, 02:27 PM
  3. Command Button
    By nashr1928 in forum Forms
    Replies: 2
    Last Post: 07-05-2010, 08:02 PM
  4. Create a command button to Browes for file
    By sawill in forum Programming
    Replies: 3
    Last Post: 03-15-2009, 05:02 PM
  5. Replies: 0
    Last Post: 08-26-2008, 09:22 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