Скачать с ютуб MS-Access Browse for Photo Button Add Image Button Using File Dialog- Southern Dog Club DB Solution в хорошем качестве

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: https://tinyurl.com/y5u35o6v 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: https://tinyurl.com/y5u35o6v 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: http://passyworldofict.com/access-sdc/ 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