Access 2007-2016
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
 
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  
 
 
 

Microsoft Access Imaging Seminar
Work with Images and Objects in Access

 
This seminar will teach you how all about working with images, pictures, graphics, OLE objects, attachments, and pictures from the Web. You will learn how to store pictures in your database, and how to work with images that are NOT stored in your database. You'll also learn how to work with the new Attachment data type.

This seminar came about because one of my customers had a need to work with a large number of images in his database, but storing pictures in an Access database is NOT a very efficient use of space. Your database gets big and slow very quickly.

So, in this seminar, I will show you a technique for selecting a file by browsing your drives, copying that file to an Images folder, and then displaying that image in your database forms and reports WITHOUT storing it in the database.

But... we don't stop there. Since we're going to learn about images, we might as well learn everything about images. We'll start with basic OLE objects (bound, unbound, linked, embedded, etc.) and move right into VBA coding for Image controls. You'll learn about the new Attachment field type in Access 2007 (but don't worry, almost everything else is perfectly valid for Access 2000 and 2003 users) and lots more.


 

 
Seminars - Access Imaging
Description: Learn how to work with images and other types of objects in your Access databases.
Versions: I will use Access 2007, however most of the lessons are valid for all versions of Access back to 2000 and up to at least 2013. I will show any differences between 2007 and 2003. The lesson on Attachments is specific to 2007. The lessons on selecting files require 32-bit versions of Access. We cannot guarantee compatibility with 64-bit Access. Read this.
Pre-Requisites: Access 101 - 104 a must
Access 201 - 207 highly recommended
Access 301 - 329 very helpful
Running Time: 3 hours, 32 minutes
Cost: $89

 

This seminar has several main goals. You will:

1. Learn about the different types of OLE objects
2. Discuss the most efficient way to work with images
3. Embed and Link OLE objects into your tables and forms
4. Work with non-image objects (spreadsheets, documents)
5. Display external images in your forms & reports
6. Browse your hard drive to select a file
7. Copy files to a central "Shared Images Folder"
8. Display images found on Web sites in your Database
9. Work with the new Attachment type in Access 2007
 

We will begin by learning about all of the different types of objects you can use in Microsoft Access. You'll learn about bound and unbound OLE objects, images, linking vs. embedding, non-image objects, when and when NOT to store images in your database, and you'll learn about the new Attachment data type.

 

Next we'll build a table and form to store embedded OLE objects right in our database tables. This is OK if you don't have a very large number of images to work with. You'll see how easy it is to edit these images in place.

 

In the next lesson, you'll see how easy it is to work with non-image objects in your database. We will embed a Microsoft Excel spreadsheet into a database form and give our users the full functionality of Excel without ever leaving Access.

 

Next you'll see how we can embed a company logo ONCE in a single form, and then use that same image in all of our other forms and reports without making separate copies of it. This saves a lot of space in our database.

 

We will then learn how to work with the Image control. This allows us to specify the path and filename of a picture file on our hard drive (or network) and view the image without having to store it in the database.

 

 

Next we're going to look at the Microsoft Common Dialog Control. This was an ActiveX control that shipped with Access 2003 and earlier, but is no longer available in 2007. It allows you to quickly and easily browse for a file on your hard drive.

 

Don't worry, Access 2007 users. I've got a solution for you. Using a little bit of VBA code, we can access that Common Dialog window without a special ActiveX control.

 

Once we learn how to select a file, now we can copy that file up to a central Shared Images folder (or just your database folder if you prefer). This way we can keep all of our images together in one place, and even rename them if we want. If you're working on a network, you want to put your images where everyone has access to view them. Don't panic... I will explain all of the VBA programming code you need to know to get this to work.

 

Next you'll see how you can give your end-users the ability to actually EDIT those pictures using Microsoft Paint. Even though the images aren't stored in the database, we can launch Paint and load up the pictures with just a few lines of VBA code.

 

If you have a Web site with images on it, you can view those images and use them in your Access database forms and reports. This is especially handy if you already have all of your product pictures online. Just point to them, and voila...

 

Next, Access 2007 users will learn how to use the Attachment data type. You can store multiple objects (pictures, text files, documents, spreadsheets, you name it) as attachments to database records... just like Email attachments.

 

 

This seminar is perfect for anyone who wants to learn how to work with images, pictures, or any kind of objects in Microsoft Access databases.

This seminar is long (over three hours) but it's broken up into easily managed lessons of about 10 minutes each. You can sit down, watch a lesson, review the material, test the code out yourself, and experiment. Do a little bit each day. It's long, but it's comprehensive - you won't miss a single step as I've recorded everything from start to finish. 

All of the sample database files for this seminar are available on my Web site (instructions on where to download them are in the course videos). They are available in Access 2007, 2003, and 2000 formats. Click here to download the sample database files.

This seminar is available to view online in the Amicron Theater. You can click here to watch the first lesson absolutely free.

Of course, if you have any questions about whether or not this seminar is for you, please contact me.
 

 

Access Imaging Seminar Outline

0. Welcome (14:40)

1. Intro to Objects (14:04)
OLE Objects v. Images
Bound v. Unbound OLE Objects
Linking v. Embedding
When and when not to store objects
Access 2007 Attachments

2. Database Setup (2:41)
Creating the Database
Customizing Options
Trusted Locations

3. Table Form Setup (5:41)
Setup Employee Table
Build Employee Form

4. Bound Embedded OLE Objects (10:02)
Insert Object
Icons v. Full Images
Edit or Display Object
Changing Registered Program Type
Zoom, Clip, Stretch

5. Linked OLE Objects (9:42)
Linking to Objects
File Folder Considerations
Shared Network Folders
Editing Linked Copies

6. Non Image Objects (6:55)
Excel Spreadsheet Fragments
Links to Word and Excel Files
Employee Report

7. Unbound OLE Objects 1 (5:05)
Shared Linked Excel Sheet
Editable Sheet Stored in Form

8. Unbound OLE Objects 2 (8:56)
Main Menu
Shared Logo on Forms Reports
Editable Logo in Multiple Places

9. Image Control 1 (11:18)
Inserting an Image Control
Manipulating the Picture Property
Loading an Image from your Drive
Change Image Button
Loading an Image when the Form Loads
Empty Image Control Box

10. Image Control 2 (12:00)
Show Image on Bound Data Form
Change Image for Each Record in VBA
Load Picture from Server or C: drive
Creating Your Own Subroutine in VB

11. Common Dialog Control (9:52)
Up to Access 2003 Users Only
Use CD Control to Pick a File
Save Filename in Field
Does Not Work in Access 2007

12. Common Dialog DLL (9:08)
All Versions of Access
Use DLL Call to Pick a File
Works With ANY Version of Access
Location of Sample Database Files

13. Copy Files to Server 1 (8:22)
Create a SettingsT Table
DLOOKUP Folder Path
Change Display Code
Null vs. Empty

14. Copy Files to Server 2 (11:25)
Separate Filename from Path
GetFilenameOnly Function

15. Copy Files to Server 3 (12:34)
Determine if File needs copying
FileCopy command

16. Copy Files to Server 4 (9:17)
Ask to Copy if File Already Exists
Dir Function
Make EmployeeID part of Filename

17. Handling Errors (9:13)
Cancel on Select File
Picking a Non-Image File Type
Image Files Moved or Renamed

18. Editing Images (6:27)
Creating Your Own Edit Event
Shell Command

19. Embedding OLE with VBA (4:21)
Pick a File
Embed the File in OLE with VBA code

20. Display Images from Web (10:53)
WebBrowser Control
Determining an Images URL
Navigate to a Web URL
LoadPicture Subroutine

21. Attachments (10:57)
Added in Access 2007
Attachments in Table Fields
Pros and Cons
Attachment in Form
VBA to Work with Attachments
Count Attachments
Cycle Through them on Form

22. Image Report (5:22)
Create a Report with Image Control

23. Review (2:55)

 


 

 

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

 

Learn
 
Accessindex
Excelindex
Wordindex
Windowsindex
PowerPointindex
Photoshopindex
Visual Basicindex
ASPindex
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Free Upgrades
Insider Circle
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Articles
Search Our Site
Waiting List
Production Schedule
Collapse Menus
Help
 
Live Chat
Customer Support
WalkThru Tutorials
Troubleshooting
FAQs
TechHelp
Consulting Services
About Us
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Gift CDs
Contact
 
Live Chat
General Info
Support Policy
Contact Form
Email Us
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

Google Plus    LinkedIn

Blog RSS Feed    YouTube Channel
Richard Rost Microsoft MVP