Access Imaging Seminar

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)