Re: [MS_AccessPros] Unbound Attachment control

 

Hello Crystal and all,

Where could I find example VBA that I could look at as a starting point for storing attachments outside of the Access database as described in Crystal's note below?

Thanks.

Steve

On 1/22/2016 4:34 PM, crystal 8 strive4peace2008@yahoo.com [MS_Access_Professionals] wrote:

 

Hi Steve,

My preference would be to store the filename and if it an image, use the
image control which can have a control source that renders to a path and
filename. Otherwise, there are the unbound and bound OLE object
controls (I do not use them)

I don't like the attachment data type. Instead of storing attachments
in the database, I hang a directory (or directories) below the database
where they all go -- and they stay in external files where they are more
manageable and can be referenced on multiple records without duplicating
them. Store path and filename and use Application. FollowHyperlink
sPathfile to open files ~

warm regards,
crystal

~ have an awesome day ~

On 1/21/2016 6:06 PM, Steve5 thaw5@suddenlink.net
[MS_Access_Professionals] wrote:
> I am unable to make an unbound attachment control function on a form. Is
> an unbound attachment control a no-no?
>
> Steve
>
>
> ------------------------------------
> Posted by: Steve5 <thaw5@suddenlink.net>
> ------------------------------------
>
>
> ------------------------------------
>
> Yahoo Groups Links
>
>
>

__._,_.___

---

Posted by: Steve thaw5 <thaw5@suddenlink.net>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (3)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

SPONSORED LINKS

.

__,_._,___