This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I intend to use the Asset Tracking template available in Access. I do not want to make many changes with the exception of currency. I do wish to include photographs of the assets but find that when I click Attachments" button nothing happens. Maybe I am being a bit silly but do I need to upload the attachments somehow and how do I get the database to locate them?
A family of Microsoft relational database management systems designed for ease of use.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Might be worth getting some more information first Scott to narrow down what is being affected. It works exactly as it should for me and has no missing attachment field in the assets table.... No problems whatsoever. the following is my install details:
Answer accepted by question author
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 51%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Yes I was aware of that. But you really should mark my response as not resolved until we research this more.
I downloaded the template into my 2016 installation and encountered the same behavior. When I tried further I got an error message that a macro command wasn't available. Further research found there was an error in the template design. The Assets table has no Attachments field! That's why it doesn't work. So you need to go into Design mode of the Assets table and add the Attachments field. Next you need to go into Design Mode of the Assets Details form. Select the Attachments control and make sure the ControlSource is set to the Attachments field. It should work then.
Scott, Thank you very much that seems to have solved the problem. I may require assistance again as I progress with building and amending the database for my purposes. Once again thank you for your help.
Peter
Hi Scott, The database is one offered when logging into access. Within the database when selecting a new item a form appears and within that form the option to "Add or Remove Attachments". When pressed this does not open a dialog box. I am afraid I do not know how to repair my installation.
Hi Peter, I'm an independent adviser and will try to help.
Are you using a form to select attachments? What should happens when you click on a control bound to an attachment data type is a dialog box should open so your can select the file you want to attach. If that is not happening you should try and repair your office installation.
If that doesn't work, let me know and I'll look into it further.