Changing and controlling order of attachments

  • Thread starter Thread starter Richard U.
  • Start date Start date
R

Richard U.

Hello,

If I add an attachment to a field that already has an attachment, is there a
way to tell it to be first in the list, so it is the one shown by default in
the form's attachment window?

Also, how would I create a label that says "Showing attachment 1 of 3"
(with real numbers, of course). I would have expected there to be a property
such as AttachmentNumber which could be accessed and changed
programmatically, but I don't see it.

Thanks,
R
 
On Sat, 20 Sep 2008 15:25:01 -0700, Richard U.

The multivalue fields are supported by a hidden table. See the help
topic "How to: Work With Attachments In DAO".
No, you cannot (re-)sort them. If you have such requirements,
implement your own 1:M solution.

Me.MyAttachmentControl.AttachmentCount will give you the number of
items.

-Tom.
Microsoft Access MVP
 
Tom van Stiphout said:
On Sat, 20 Sep 2008 15:25:01 -0700, Richard U.
Me.MyAttachmentControl.AttachmentCount will give you the number of
Click to expand...

Ah, the above let me find what I think is the proper reference material for
what I want to do. We also have available the following

Me.MyAttachmentControl.CurrentAttachment (integer, not sure yet if 1 or 0
based)
Me.MyAttachmentControl.Forward
Me.MyAttachmentControl.Back

Those three along with AttachmentCount should let me do everything I want to
do.

R
 
Back
Top