|
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 and later 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. I generally don't recommend storing files inside your database, but the option is available.
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.
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)
|
