Moving attachments within document

Posted on 2006-05-10
Last Modified: 2013-12-18
I have a database where there are sometimes 10 attachments attached to a document.  I'd like to secure access to those attachments by restricting based on userroles.

In order to do that I believe I need to move those attachments to a richtext field in order to take advantage of the 'hide when' feature.

What is the best way to move all of those attachments to a field within the same document when it appears that they were originall attached to the 'body'.

Question by:ITDharam
    LVL 18

    Expert Comment

    You cannot use the hide-when features in a rich-text field, they are unpredictable.

    Instead use subforms, one with the rich text field and the attachments, and one without, or one rich text field per attachment and add or remove subforms.. although the robustness decreases with more subforms (each is an additional hit on the server)

    The subforms can be computed, so when someone of a certain role opens the document, the rich text subform shows, else it doesn't.

    Downside is that refreshing the form doesn't change the subforms, so if someone opens in read mode and switches to edit mode, you have to close and reopen the form to get the subform to load.
    LVL 14

    Accepted Solution

    or use the $V2AttachmentOptions field. set it "0" or "1" to hide or show attachments
    LVL 18

    Assisted Solution

    This is a really nice explanation of $V2AttachmentOptions

    It is, at best, an old chestnut that works and most times does not. :)
    LVL 18

    Expert Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    For Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
    Article by: Rob
    Notes 8.5 Archiving Steps and Tips This article covers setting up a Notes archive, and helps understand some of the menu choices making setting up and maintaining a Notes archive file easier.
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now