MS-Access Browse for Photo Button Add Image Button Using File Dialog- Southern Dog Club DB Solution

Subscribe to our Channel to get regular Video Lessons for Developing Solutions in Microsoft Access.

Because we are a slow talker, we recommend you use the YouTube "Tools Cog" on the player bar to watch the video at a speed of 1.5x or even 1.75x.

In this Lesson we show How to Add a Photo Button onto a Screen Form, making it very easy to pick and click a specific Photo to go onto the Form.

The Lesson Support Materials mentioned in the video can be quickly downloaded on our Website at the link below:

If you are a Teacher watching this video then click the downloads link and get all of the lesson materials for your students.
These Downloads include a detailed Step by Step Instructions PDF, VBA Code, and both a Start and Finish MS-Access database for the Lesson.

Give these resources to your students and we think you will find that some of them will "get it" very quickly. The other students need to watch this video which goes through everything in full detail slowly step by step with repetition of examples.

As this is a Long and Detailed Video, there is a Video Timeline Index included below.

VIDEO TIMELINE INDEX

00:00 to 05:41 Lesson Intro and Demo of Finished Product
05:41 to 06:37 Getting the Lesson Downloads
06:37 to 09:13 The 10 Steps for Making the Photo Button
09:13 to 09:36 Other Lessons You Need to Have Done
09:36 to 10:51 Finding these Lessons on our Website
10:52 to 11:58 Database Startup for Ribbon and Side Bar
11:58 to 13:10 Access Form View Modes
13:10 to 14:28 Step 1 - Making Application Folder
14:29 to 15:15 Step 2 - Copy DB and Images into Folder
15:15 to 19:31 Step 3 - Load ? image as the Form Default Image
19:32 to 23:59 Step 4 - Add a New “Photo” Button to existing Buttons
23:59 to 26:17 Step 5 - Add the Image Location Field onto the Form
26:17 to 29:19 Step 6 - In VBA Import the MS Office Object Library
29:19 to 36:18 Step 7 - Write the VBA Code for the Photo Button
36:18 to 38:17 Step 8 - Test the Photo Button and Verify Link Saving
38:17 to 40:09 Step 9 - Make Image Location on the Form Not Visible
40:09 to 45:10 Step 10 - Regression Test - Add New Member and Photo
45:10 to 46:11 Challenge Task - Make a Photo Button for the Dogs Form
46:11 to 46:42 Saving the Finished Database
46:42 to 47:25 Where to Next
47:25 to 47:41 Our Website Access Course
47:41 to 48:22 Video Wrap Up and Outro

This video will be useful for anyone learning Computing, especially students doing VCE Applied Computing or VCE Data Analytics or HSC Computing high school courses in Australia, and GCSE in the UK.

Check with your Teacher or Instructor before getting any Downloads from our Website, as they may already have these materials for you.

You can download a hard copy of the Step By Step Instructions, the VBA Code, Member and Dog Images, as well as the Start and Finish Databases, at the following link:

Check with your Teacher or Instructor first, as they may already have these Download materials for you.

You can check out our MS-Access Beginners Course at the following link:

We are planning to make a number of Video Lessons that will be a great course for people to learn how to build Database Applications using Microsoft Access.

Like this video if you found it helpful.

Subscribe to our Channel to get notified of our video updates.

Enjoy,
Passy