Adding PDF file in Form as attachment

[SuddathAL]

I am trying to add an item in my main info entry form in Access 2007, to allow me to attach PDF files of scanned documents to a record. I have added the field in the appropriate table and can add the items in the table, but am unable to do so in the form view.

the "Asset" template has exactly what I want on the "Asset Details" form, but i cannot duplicate it in my DB.

What am I missing?

 

[Xander117]

The asset details does have a command button associated with it, and an on click macro associated with that button.

I assume your attachement field in your database is set as an "attachment" and that you have added an attachment control on your form?

 

[SuddathAL]

I have tried adding an attachment control (from the paper clip icon on the deign ribbon), and adding a control button with an macro. Neither of them work. In the table, the field is set as attachment (with paper clip icons in every cell).

 

[Xander117]

So when you click on the attachment window you dont even get the attachment(s) control window (2 arrows and paperclip)? Is your control source for the attachment, the attachment field from your table? The easiest way to add it to the form, is to go to add exsisting fields, and double click on your attachment field. From there you should just be able to click on it.

I cant think of any reason off my head why you can't if all that doesnt work. Maybe someone with more access knowledge can help out.

 

[SuddathAL]

I am going to close the program and then try it again. when I do it from "add from existing" if just brings up a dead, blank box. Thanks for the effort though.

 

[SuddathAL]

got it. i just close the program, then opened it back up and did add exisiting field. thanks for the help

 

[Xander117]

Good deal, glad that worked for you.