link pdf

[odun]

Hello all,

I created a table and linked a pdf file to one of the fields, but when I created a form to display the table contacts, I could not see the attachment or icon or any reference to the linked object. The field in my access table is an OLE object.

Thanks for helping out.

 

[ghudson]

Do not store the actual file in your db for it will quickly bloat. Store the path to the file so that the user can either open or print the file. Search around for there are plenty of threads discussing your quest. This link might also help you... Browse [Find a directory or file]

Searching the forum is a great way to discover and learn the answers to your Access programming questions.

 

[odun]

ghudson,
Thanks.

I looked at the browsing db you have in the other post and I think the fFindOpenImportFile would do the trick.
But how do I include this as one of the components in my form. My access form has other fields, e.g Customer Name, Number, State, how do I include this open import File in the form along with the other fields.

Thanks a lot!

 

[ghudson]

Just copy and paste the parts from my form that you want [need] into your form. You will have to ensure the object names are correct so that my objects and code work with your form.

 

[odun]

hi Ghudson,

Do you mind walking me through how to copy your fFindOpenImportFile unto my existing form. Here is what I did and it did not work. I went to the form tab on your access database, right clicked and copied and then opened my databases and right click on my form to paste, but it did not work. Please help, it's urgent.

Thanks a lot!

 

[ghudson]

Not sure why but that is what you need to do. Select my form and press the copy button, go to the forms tab in your db and press the paste button.

You can use the import function to import my form into your db.

Ensure that you also copy/import the class modules [if needed] since they might have a public function that my form uses.

 

[odun]

Hi,

thanks. But I want the function in your form to work in my form, I don't want another form in my db. I want to be able to open my form and when I click on the attachment field, your function would ask me to browse, select open file e.t.c. Is this possible?

 

[ghudson]

Just copy and paste the text boxes and buttons and code [private and public] that make it work. Just dig in and you will figure out what you need to make it work in your db. When it errors you will be notified of what is missing.