"The code is exactly
how I would like to write code and the algorithms used are very
efficient and well-documented."
Van T. Dinh, Microsoft MVP
|
|
|
Category:
|
Database : Access/Jet
|
|
Description:
|
Microsoft Access Jet databases and their objects (MDB and ACCDB database formats)
|
Module: modAttachmentFields
Working with Attachment fields in Access ACCDB databases
|
Procedure Name
|
Type
|
Description
|
|
(Declarations)
|
Declarations
|
Declarations and private variables for the modAttachmentFields module
|
|
AddAttachmentsFromFolder
|
Procedure
|
Loads all files in a folder (directory) into an Attachment field.
Loads the files for every record that matches the Where clause.
|
|
AddAttachmentsToRecords
|
Procedure
|
Loads multiple files into an Attachment field for every record specified
|
|
AddAttachmentToField
|
Procedure
|
Add one file into an Attachment field of a record that's in edit mode
|
|
AddAttachmentToRecords
|
Procedure
|
Add one file into an Attachment field. Loads the files for every record that matches the specified filter.
|
|
DeleteAttachments
|
Procedure
|
Removes the specified attachment(s) from a field across all the filtered records
|
|
DeleteAttachmentsFromField
|
Procedure
|
Delete (remove) the specified attachment(s) from a field in one record
|
|
ExportAttachments
|
Procedure
|
Export (save) the attachments to files in a specified folder (directory)
|
|
ExportAttachmentsFromField
|
Procedure
|
Save (export) the attachments to files in a specified folder (directory)
|
|
GetAttachmentFieldFileNames
|
Procedure
|
Fill an array with an attachment field's list of file names
|
|
GetAttachmentTableFileNames
|
Procedure
|
List all the attachments of the specified attachment field in the first record of a table using this filter
|
|
IsFieldAttachment
|
Procedure
|
Checks if the specified field in a table in the specified database is of attachment type
|
|
PrintAttachmentFileInfo
|
Procedure
|
List the information of all the attachments of the specified field in a table to the immediate window
|
Overview of Total Visual SourceBook
The source code in Total Visual
SourceBook includes modules and classes for Microsoft Access, Visual
Basic 6 (VB6), and Visual Basic for Applications (VBA) developers. Easily
add this professionally written, tested, and documented royalty-free code
into your applications to simplify your application development efforts.
Additional Resources
|
|
All Our Microsoft Access Products
(885K)
