ACCESS FEED: Re: [MS_AccessPros] Re: List of Attachements

Kamis, 29 Mei 2014

Re: [MS_AccessPros] Re: List of Attachements

One more thing. If you have never used a hyperlink field, just right click in the field if you want to add or edit. Then you will get a file browser to select your file. It is very easy to enter a document that way. Later you may want to add a button for easy viewing so look up the docmd.followhyperlink method.

On Thu, May 29, 2014 at 2:43 PM, Peter Poppe <plpoppe@gmail.com> wrote:

To clarify the code I gave you was not for moving these on to the network, that was only for making a list of time stamps if you continued to store them as attachments. However, you may want to look at the other code provided so that you do not have to manually move the existing attachments.

On Thu, May 29, 2014 at 2:40 PM, Peter Poppe <plpoppe@gmail.com> wrote:

Yes by far this would be the easiest. It will not have a lot of bells and whistles, but you can do this with little coding.
So make your attachment table as described. This is a child table to your main table so that you can set up a one to many. One vendor would have many attachments. But you have the keys backwards. The parent table would have something like "SWA". Each attachment record would have a VendorID foreign key so each would store SWA. The primary key in the attachment table does not really matter. I would just use an autonumber. Set the time stamp fields default property to "now()". Every time you enter a new record it will get time stamped. In this table use a hyperlink path where you will store the hyperlink to the document. You can add a little code later. In your form the attachments table should be a subform so that you can add multiple attachments to a vendor record. They would be joined by VendorID to VendorID_FK or something like that.

On Thu, May 29, 2014 at 2:24 PM, ka0t1c_ang3l <no_reply@yahoogroups.com> wrote:

The users don't add documents or data. I'm the only one who adds the PDFs and fills in the information for each contract. However, the users have read-only permissions, and rather than keep the PDFs stored in the database, I'd rather just provide a "hyperlink" for each of the PDF, so that they can open the contracts to read them.

For example, right now the contract file has an attachment page labeled Contract Attachments, and when the user double-clicks on the PDF icon it opens the Attachment Dialog Box that lists all the PDFs associated with that particular Vendor.

Using the code you gave me, could I use the AttachmenID to tie the PDF to its specific Vendor. (i.e. Southwest Airlines contract documents would have an AttachmentID of SWA1, SWA2, SWA3, depending on how many attachments this vendor has).

As for the timestamp, I could have them all reflect the day I added them to the database, even if it's today's day, it would just be a starting point and from this day on, it would reflect the day a new document was added.

I apologize, I am definitely a novice, and need help with Access!! :)