Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
 
Home   Courses   Seminars   Templates   Help   TechHelp   Forums   Contact   Join   Order   Logon  
 
 
Access Open Other Programs Seminar
By Richard Rost   Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   7 years ago

Have you ever wanted to build a database to store an unlimited number of documents or other file attachments with each record? Perhaps you'd like to double-click on any of those files and have them automatically open up in the appropriate program? Open a Word document representing the employee's resume, or automatically have an Excel spreadsheet open up for the client's purchase order. Perhaps you'd like to click on a button next to the customer's address and have your web browser open up directly to that address into Google Maps?

This Access Open Other Programs Seminar will teach you how to open other programs, documents, and custom web page addresses from inside your Microsoft Access databases. Topics include:

1. How to display external images in Access Forms
2. Build a database to allow unlimited external attachments per customer
3. Use the SHELL function to open external files of known type
4. How to determine which application to open
5. Use SHELLEXECUTE to open file in default Windows handler app
6. Open a Web page to a custom URL in default browser
7. Load Google Maps to a Specific Address

This seminar is 1 hour and 19 minutes long. Click here for more information on the <Access Open Other Programs Seminar, including a complete course outline, sample video, and lots more.

Opening Applications Upload Images   Link 
Jim Baldner 
3 days ago
Morning Folks,

I would like to attach to a form button the ability to open a second-party application.  Is there a simple vba code to do so?

Thx in advance..
Brent Rinehart
3 days ago
Richard has some code in the code vault that might work, I have never used but might work for you called Shell Execute to open another application
Brent Rinehart
3 days ago
Code Vault: Shell Execute
Add a Reply
Opening an image Upload Images   Link 
Colin Smyth 
11 days ago
I recently used Richard's browse VBA programme to find a photo and then link it to my database and show on the form.
Is there a way that I can then open that image in Microsoft Photos so that I can zoom in so see more details of the photo. I have tried different options but none have worked. Read More...
Colin Smyth
11 days ago

Colin Smyth
11 days ago
So Can I either click on the photo or the pathway or set up a button such as open File etc ?
Add a Reply
Problem with open PDF files Upload Images   Link 
Sohail Samson 
31 days ago
Hello,

I have purchased "Open External Programs, Web URLs" and by following it I was trying to open my pdf files but it doesn't let me do that. I do have created a new system path "C:\Program Files (x86)\Adobe\Acrobat Reader DC\Reader" to open "AcroRd32.EXE" but still unable to open pdf files. Read More...
Alex Hedley
31 days ago
Are you using Shell or ShellEx?

The path to Adobe has spaces in it, have you double quoted the path string?

What error do you get when you try an open the document?
Sohail Samson
30 days ago
Hi Alex,

Thanks for your help.

I'm using "Shell" as per Richard Rost's video. I'm very new to VB coding but it's been a while working with access. Yes, I have double quoted the path string too. it is sampling doing nothing.

If Right(Attachments, 4) = ".PDF" Then
    Shell """C:\Program Files (x86)\Adobe\Acrobat Reader DC\Reader\AcroRd32.exe"" """ & Attachments & """", vbNormalFocus
End If

I don't know where I am making mistake.
Add a Reply
MP4 as an attachment Upload Images   Link 
Carol Herriot 
2 months ago
I have finished watching the Open Other Programs Class.  You talked about opening .docx, .txt, .xslx, .jpg and .pdf files. There also is an attachment called C:\attachments\00.mp4   Read More...
Richard Rost
2 months ago
The ShellExecute function should open ANY file regardless of type. Lesson 3.
Add a Reply
Compile Error Upload Images   Link 
Carol Herriot 
2 months ago
I am in Open Other Programs Seminar, Lesson 3  at 6:34.
I have followed Ricks instructions.  When I attempt to open the attachment, I get the following error message:

The code in this project must be updated for use on 64-bit systems.  Please review and update Declare statements and then mark them with the PtrSafe attribute. Read More...
Add a Reply
Coding Error Upload Images   Link 
Carol Herriot 
2 months ago
I am attempting to reproduce the Open Programs Database while watching the video.

The first line of the coding is highlighted in yellow so I am assuming that needs attention???  I have been staring at the coding for about 30 minutes and cant figure out what is wrong!! Maybe I can't see for looking. Read More...
Adam Schwanz
2 months ago
If Right(Attachment, 4) = ".TXT" Then
        Shell "NOTEPAD.EXE """ & Attachment & """", vbNormalFocus
Adam Schwanz
2 months ago
That's how I make mine, this could also be helpful to you Double Double Quotes
Add a Reply
Specific Folder Settings Upload Images   Link 
Richard Lanoue 
14 months ago
I've tried saving the settings on how I'd like to view specific folders (Extralarge Icon, List View, sorted by date descending...)  It never stays for very long. Is there a code to assign View (like Extra Large Icon) to Folder and Subfolders when opened using vba code? Shell Exec....
Richard Rost
14 months ago
I don't believe so. That's not something stored in Access, so unless the program you're opening has startup parameters or can be modified with a Windows Registry setting, then you really can't do much about it from Access. Alex, any ideas?
Alex Hedley
14 months ago
Maybe something in the Open post I made, I've never needed it so would need to research a bit first.
I thought windows usually remembers what view you had.
Add a Reply
Windows Explorer Upload Images   Link 
Richard L 
2 years ago
No, unfortunately.  These don't stay for long.  I was hoping there was a code.
Add a Reply
Windows Explorer Upload Images   Link 
Richard Lanoue 
2 years ago
My Problem:  Some folders I open with the Shell command I'd like to have an Extra Large Icon View and sort alphabetically.  Some folders I'd like to have when opened, List view and sorted Last Date Modified Desc.  Since these files are on an external drive, the setting I set them to, do not stay for very long.  Is there and Can you show me some code that once a specific file is open, the view and sort is set to a specific setting always?   Read More...
Add a Reply
Access Open Other Programs Seminar Upload Images   Link 
Musab Hawsawi 
3 years ago
what about word automation i want to export data (dates,numbers,text ..etc) from access table in to a specific three tables (withe multi rows and columns) on ms word
Add a Reply

Show Older Comments...
View in Table Format

Start a NEW Conversation
 
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.
 
Subscribe
 

You may want to read these articles from the 599CD News:

9/17/2021Overlapping Windows
9/16/2021Inventory
9/10/2021Benefits of Access
9/10/2021Access on a Phone
9/5/2021Prevent Deletion
9/4/2021Booklet Template
9/4/2021Inspections Template
8/29/2021What is Microsoft Access?
8/27/2021Union Query
8/24/2021Navigation
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Keywords: access open other files opening shell shellexec shellexecute  Page Tag: whatsnew  PermaLink