Results 1 to 2 of 2
  1. #1
    ninachopper is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2010
    Posts
    25

    attachment help!

    hello


    If anyone has help on attachments, it would be great. I have numerous facilities that had monitoring and results taken from(for air quality), and numerous pdf files to be attached to each facility. What I am trying to do is to make a table with each facility and their numerous attachments, and link it to my main tables with the testing data, so that when you run a report, the pdf's are accessible for each record.
    Otherwise, I will have to keep readding these pdf's and the size of my database will be HUGE!
    Any advice would really help!

    I am a newbie and have taught myself access. I have a pretty good idea of what I am doing, but still am new to this
    Thanks!!

  2. #2
    pkstormy's Avatar
    pkstormy is offline Access/SQL Server Expert
    Windows XP Access 2003
    Join Date
    Mar 2010
    Location
    Madison
    Posts
    682
    I'd store the folder/filename to the pdf in a field in the table.

    You could then use code as such on your form to open them (in acrobat itself):

    Dim strFileName as variant
    strFileName = me!MyFieldStoringTheFolderFileName
    Application.FollowHyperlink strFileName

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 0
    Last Post: 07-06-2010, 08:12 AM
  2. How do I insert an attachment using a form?
    By mitcheljp in forum Access
    Replies: 1
    Last Post: 06-18-2010, 08:53 AM
  3. Emailing - Attachment is Blank
    By Benfieldf in forum Access
    Replies: 2
    Last Post: 05-10-2010, 08:03 AM
  4. Attachment Field problems
    By freds in forum Database Design
    Replies: 1
    Last Post: 12-15-2009, 06:37 AM
  5. email attachment from Access
    By Gandalf in forum Queries
    Replies: 0
    Last Post: 01-22-2009, 10:03 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums