Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

Can I add a word attachment (resume) to an Access contact?

Discussion in 'Information Technology' started by New to Access, Jul 28, 2006.

  1. New to Access

    New to Access
    Expand Collapse
    Guest

    I am a recruiter that is starting a database of contacts. I would like to be
    able to attach a Word format resume, to their contact information. I am not
    familiar with Access. Is that possible?
     
  2. Loading...


  3. Graham Mandeno

    Graham Mandeno
    Expand Collapse
    Guest

    Yes, this is possible, but I recommend you do not try to store the Word
    document inside your database. Instead, store only the path to the file on
    your hard disk.

    When you want to open the document you can use the FollowHyperlink method,
    which will open your document in a standalone instance of Word.
    --
    Good Luck!

    Graham Mandeno [Access MVP]
    Auckland, New Zealand

    "New to Access" <New to Access@discussions.microsoft.com> wrote in message
    news:3CB36864-2E50-46F9-8E22-49B1C9D35D4D@microsoft.com...
    >I am a recruiter that is starting a database of contacts. I would like to
    >be
    > able to attach a Word format resume, to their contact information. I am
    > not
    > familiar with Access. Is that possible?
     
  4. Also New to Access

    Also New to Access
    Expand Collapse
    Guest

    I'm trying to do exactly the same thing. Thanks Graham, it's great to know
    that it's possible, but I'm afraid that I'm such a novice that I don't even
    know how to do what you suggested. I tried playing with adding a Hyperlink,
    but it seems to want to link to the same file for every record, whereas I
    need to link to a different resume each time.

    Any very simple advice for a complete beginner?
    Words of 1 syllable would be nice ;-)
     
  5. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Tue, 11 Jul 2006 06:56:03 -0700, Also New to Access <Also New to
    Access@discussions.microsoft.com> wrote:

    > I'm trying to do exactly the same thing. Thanks Graham, it's great to know
    >that it's possible, but I'm afraid that I'm such a novice that I don't even
    >know how to do what you suggested. I tried playing with adding a Hyperlink,
    >but it seems to want to link to the same file for every record, whereas I
    >need to link to a different resume each time.
    >
    > Any very simple advice for a complete beginner?
    > Words of 1 syllable would be nice ;-)


    Too bad "hyperlink" has three... let's call it a Hyp! <g>

    You need a field in your Table with a datatype of Hyp. Each row in the
    Table should have its own Hyp. If you just put a Hyp box on a Form it
    will not work, you need the Table.

    (There, only "Table" violated the one syllable rule... thanks for the
    challenge!)

    John W. Vinson[MVP]
     
  6. Also New to Access

    Also New to Access
    Expand Collapse
    Guest

    Thanks John,

    Turns out the problems I was having were more down to 'idiot at keyboard'
    rather than not being able to follow your original instructions. Your nice
    simple instructions helped me realise that though.

    "John Vinson" wrote:

    > On Tue, 11 Jul 2006 06:56:03 -0700, Also New to Access <Also New to
    > Access@discussions.microsoft.com> wrote:
    >
    > > I'm trying to do exactly the same thing. Thanks Graham, it's great to know
    > >that it's possible, but I'm afraid that I'm such a novice that I don't even
    > >know how to do what you suggested. I tried playing with adding a Hyperlink,
    > >but it seems to want to link to the same file for every record, whereas I
    > >need to link to a different resume each time.
    > >
    > > Any very simple advice for a complete beginner?
    > > Words of 1 syllable would be nice ;-)

    >
    > Too bad "hyperlink" has three... let's call it a Hyp! <g>
    >
    > You need a field in your Table with a datatype of Hyp. Each row in the
    > Table should have its own Hyp. If you just put a Hyp box on a Form it
    > will not work, you need the Table.
    >
    > (There, only "Table" violated the one syllable rule... thanks for the
    > challenge!)
    >
    > John W. Vinson[MVP]
    >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page