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)

|