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

Kamis, 29 Mei 2014

Re: [MS_AccessPros] Re: List of Attachements

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!! :)