adding attachments from a form

[nosferatu26]

Hello,

In my database, it isn't a requirement, but I think it would be a cool addition if the user had the option to upload attachments. I have added a new attachment field in my table, but seem to have trouble populating it within a form.

In the table datasheet view, I see the paperclip icon and can click on it and it will prompt me to add an attachment. On my form, I added the attachment control and bounded it to the field in the table. When Im in the form view, however, an empty box appears for the attachment control and when I click on it nothing happens. I cant even get an image(paperclip) to appear for it, indicating to the user what it is..

Ideally, within the form itself I would want that same prompt to appear but for the user to browse and choose file(s) to upload. Is this possible? I am thinking I can do it with VBA and input the file path but if I have to go through all of that I will probably just leave out this attachment functionality all together.

Any help is much appreciated!

 

[JHB]

In my database, it isn't a requirement, but I think it would be a cool addition if the user had the option to upload attachments. I have added a new attachment field in my table, but seem to have trouble populating it within a form.

Don't do that - your database will grow inappropriate.