AC 2007 Attachments Field

[Carl]

The following question seems straight foreword to me and I would think that
others might find the solution useful in their applications.


Discussion: In Access 2007 when using the Attachment field you can list one
or more (image/icon/text/) files. I have an Attachment field on one of my
data entry Forms that primarily displays a JPG image. Under Properties I have
listed a path to a Default Picture (it works great). Using the Manage
Attachments dialog box (right-clicking in the field) I can add one or more
files of my choice to any given record. Once a file is added it overrides
the Default Picture (as expected). If I list multiple files (in my case
JPG’s) I can view them by use of the Mini Toolbar (left-clicking in the
field) or use the Manage Attachments dialog box. With either function,
whichever JPG I select will be displayed in the field (rendered image or
icon) and will remain displayed as I work in other fields on the form.

Problem: However, when I move to another record or close the Form, the
“displayed†JPG will not be saved as the default file. When revisiting the
record, the underlying binary table will revert back and display the original
JPG (the normal order of ascending file structure; 1.jpg, 1a.jpg, 1b.jpg).
The Manage Attachments dialog box provides the user with a number of useful
options for file manipulation; however it does not provide the user an option
of selecting a specific file, if more than one is available. Perhaps
Microsoft overlooked this issue.

Dilemma: I have a report that is generated from this form that provides
selective fields of data and “hopefully†a specific image file from multiple
choices associated with a record. I really don’t want to manipulate file
structure or create a separate table to store files or use a List/Combo Box
to achieve my desired goal.

Help: I’m new to Access and I know nothing about writing Code. If anyone
knows a way to save a displayed file when exiting the field or at the very
least the record, I would be most appreciative of hearing from you.

Thank you in advance for your time and effort.

Carl

 

[Maurice]

Carl,

Maybe a long shot but have you tried placing a 'save' button on the form.
You can use the wizard create button for this. Just choose [save record] and
try to see if that does what you would like it to do. Maybe it has to saved
specifically. just a thought..

 

[Carl]

Maurice,
Thank you for your reply. In my application, regardless of which form I am
using, data entry is automatically saved when exiting a Field, Record or Form
(with exception of the Attachment field). I did try your suggestion but it
did not solve my prroblem.

Carl

Carl,

Maybe a long shot but have you tried placing a 'save' button on the form.
You can use the wizard create button for this. Just choose [save record] and
try to see if that does what you would like it to do. Maybe it has to saved
specifically. just a thought..
--
Maurice Ausum

The following question seems straight foreword to me and I would think that
others might find the solution useful in their applications.


Discussion: In Access 2007 when using the Attachment field you can list one
or more (image/icon/text/) files. I have an Attachment field on one of my
data entry Forms that primarily displays a JPG image. Under Properties I have
listed a path to a Default Picture (it works great). Using the Manage
Attachments dialog box (right-clicking in the field) I can add one or more
files of my choice to any given record. Once a file is added it overrides
the Default Picture (as expected). If I list multiple files (in my case
JPG’s) I can view them by use of the Mini Toolbar (left-clicking in the
field) or use the Manage Attachments dialog box. With either function,
whichever JPG I select will be displayed in the field (rendered image or
icon) and will remain displayed as I work in other fields on the form.

Problem: However, when I move to another record or close the Form, the
“displayed†JPG will not be saved as the default file. When revisiting the
record, the underlying binary table will revert back and display the original
JPG (the normal order of ascending file structure; 1.jpg, 1a.jpg, 1b.jpg).
The Manage Attachments dialog box provides the user with a number of useful
options for file manipulation; however it does not provide the user an option
of selecting a specific file, if more than one is available. Perhaps
Microsoft overlooked this issue.

Dilemma: I have a report that is generated from this form that provides
selective fields of data and “hopefully†a specific image file from multiple
choices associated with a record. I really don’t want to manipulate file
structure or create a separate table to store files or use a List/Combo Box
to achieve my desired goal.

Help: I’m new to Access and I know nothing about writing Code. If anyone
knows a way to save a displayed file when exiting the field or at the very
least the record, I would be most appreciative of hearing from you.

Thank you in advance for your time and effort.

Carl