seminar has several main goals. You will:
Learn about the different types of OLE objects
Discuss the most efficient way to work with images
3. Embed and Link OLE objects into your tables and
4. Work with non-image objects (spreadsheets,
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
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
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.
seminar is perfect for anyone who wants to learn
how to work with images, pictures, or any kind of objects in Microsoft
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.
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.
seminar is available to view online in the Amicron Theater.
click here to watch the first lesson absolutely free.
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
OLE Objects v. Images
Bound v. Unbound OLE
Linking v. Embedding
When and when not to store objects
2. Database Setup (2:41)
3. Table Form Setup
Setup Employee Table
Build Employee Form
4. Bound Embedded OLE
Icons v. Full Images
Edit or Display Object
Changing Registered Program Type
Zoom, Clip, Stretch
OLE Objects (9:42)
Linking to Objects
File Folder Considerations
Editing Linked Copies
6. Non Image Objects
Excel Spreadsheet Fragments
Links to Word and Excel Files
7. Unbound OLE Objects 1 (5:05)
Shared Linked Excel
Sheet Stored in Form
8. Unbound OLE Objects 2 (8:56)
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
an Image when the Form Loads
Empty Image Control Box
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
11. Common Dialog Control (9:52)
Up to Access 2003
Use CD Control to Pick a File
Save Filename in Field
Does Not Work in
12. Common Dialog DLL (9:08)
Use DLL Call to Pick a File
Works With ANY Version of Access
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)
15. Copy Files to Server 3
Determine if File needs copying
16. Copy Files to Server 4 (9:17)
Ask to Copy if File
part of Filename
17. Handling Errors (9:13)
Picking a Non-Image File Type
Image Files Moved or Renamed
Editing Images (6:27)
Creating Your Own Edit Event
19. Embedding OLE with VBA (4:21)
Pick a File
the File in OLE with VBA code
20. Display Images from Web (10:53)
Determining an Images URL
Navigate to a Web URL
21. Attachments (10:57)
Added in Access 2007
Attachments in Table Fields
Pros and Cons
Attachment in Form
VBA to Work with Attachments
Cycle Through them on Form
22. Image Report
Create a Report with Image Control