Welcome to SPN

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

Sign Up Now!

images stored as .doc files

Discussion in 'Information Technology' started by Mike Smith NC, Jul 28, 2006.

  1. Mike Smith NC

    Mike Smith NC
    Expand Collapse
    Guest

    Is there a way to have .doc image files displayed on forms and reports
    without bloating the database size? I know I can go through each image and
    put it through paint but is there an easier way to see these.
    Thanks for any help
     
  2. Loading...

    Similar Threads Forum Date
    1984 Images Revisited - YouTube History of Sikhism Nov 2, 2016
    He’s The World’s Best Water Photographer… And He’s Just Released These Haunting Images. Sikh Sikhi Sikhism Aug 30, 2015
    Nature Caterpillars Morph into Butterflies in Amazing 3D Images Breaking News May 15, 2013
    SciTech Rare images beyond the naked eye Breaking News Oct 23, 2010
    Heritage Old Paintings and Images of Lahore (British Library Collection) History of Sikhism Sep 29, 2010

  3. Wayne-I-M

    Wayne-I-M
    Expand Collapse
    Guest

    Hi Mioke

    You can store your doc's on your hard drive and link to them from a form

    Or embed a thumbnail of the doc in a form.

    For details of how to do this check out the answer I gave a few hours ago
    answering the question "i cant embed a .bmp file in access"

    I would suggest linking to the doc's rather than embeding but this depends
    on what you're going to do with the Datbase.

    Hope you find it helpful

    --
    Wayne
    Manchester, England.



    "Mike Smith NC" wrote:

    > Is there a way to have .doc image files displayed on forms and reports
    > without bloating the database size? I know I can go through each image and
    > put it through paint but is there an easier way to see these.
    > Thanks for any help
     
  4. Mike Smith NC

    Mike Smith NC
    Expand Collapse
    Guest

    Wayne-I-M
    The images in the .doc files are inserted as links but when the graphs
    actually show up the size increase to a ridiculous amount. I have been
    changing them to icons and this reduced the size. I just go to the convert
    linked image selection.
    Since they are linked why does it balloon the size so much? What can I do?
    Thanks for the time.

    "Wayne-I-M" wrote:

    > Hi Mioke
    >
    > You can store your doc's on your hard drive and link to them from a form
    >
    > Or embed a thumbnail of the doc in a form.
    >
    > For details of how to do this check out the answer I gave a few hours ago
    > answering the question "i cant embed a .bmp file in access"
    >
    > I would suggest linking to the doc's rather than embeding but this depends
    > on what you're going to do with the Datbase.
    >
    > Hope you find it helpful
    >
    > --
    > Wayne
    > Manchester, England.
    >
    >
    >
    > "Mike Smith NC" wrote:
    >
    > > Is there a way to have .doc image files displayed on forms and reports
    > > without bloating the database size? I know I can go through each image and
    > > put it through paint but is there an easier way to see these.
    > > Thanks for any help
     
  5. Wayne-I-M

    Wayne-I-M
    Expand Collapse
    Guest

    Hi Mike was a bit disturbed to hear that you're having problems so used the
    same method myslef on a backup DB and found that (after adding 25 Doc's) the
    file size was increased by only 10kb (almost nothing)

    Try this

    Open the “table†you will use as a base for the form.
    Select the OLE field the will hold the “link†to the word doc
    Right click
    Select insert object
    Select “Create from Fileâ€
    Check the “link†box – this is important
    Browse to your Word Doc
    This should open the access Brouse Box. Select your Doc from this list
    Click OK (this will close the box)
    Mark the “display as icon†box
    Click OK
    Bring the OLE into the form (it will be displayed as the standard Word Doc
    logo)
    Click the logo to go to the doc.

    This method should not increase the size of your DB field by more than
    another small logo type (about 4kb per item)

    Hope this helps

    --
    Wayne
    Manchester, England.



    "Mike Smith NC" wrote:

    > Wayne-I-M
    > The images in the .doc files are inserted as links but when the graphs
    > actually show up the size increase to a ridiculous amount. I have been
    > changing them to icons and this reduced the size. I just go to the convert
    > linked image selection.
    > Since they are linked why does it balloon the size so much? What can I do?
    > Thanks for the time.
    >
    > "Wayne-I-M" wrote:
    >
    > > Hi Mioke
    > >
    > > You can store your doc's on your hard drive and link to them from a form
    > >
    > > Or embed a thumbnail of the doc in a form.
    > >
    > > For details of how to do this check out the answer I gave a few hours ago
    > > answering the question "i cant embed a .bmp file in access"
    > >
    > > I would suggest linking to the doc's rather than embeding but this depends
    > > on what you're going to do with the Datbase.
    > >
    > > Hope you find it helpful
    > >
    > > --
    > > Wayne
    > > Manchester, England.
    > >
    > >
    > >
    > > "Mike Smith NC" wrote:
    > >
    > > > Is there a way to have .doc image files displayed on forms and reports
    > > > without bloating the database size? I know I can go through each image and
    > > > put it through paint but is there an easier way to see these.
    > > > Thanks for any help
     
  6. Mike Smith NC

    Mike Smith NC
    Expand Collapse
    Guest

    Thanks again for your help.
    I did what you suggested and it has helped a great deal but is there a way
    for the images in the .doc files to print when I create a report.

    "Wayne-I-M" wrote:

    > Hi Mike was a bit disturbed to hear that you're having problems so used the
    > same method myslef on a backup DB and found that (after adding 25 Doc's) the
    > file size was increased by only 10kb (almost nothing)
    >
    > Try this
    >
    > Open the “table†you will use as a base for the form.
    > Select the OLE field the will hold the “link†to the word doc
    > Right click
    > Select insert object
    > Select “Create from Fileâ€
    > Check the “link†box – this is important
    > Browse to your Word Doc
    > This should open the access Brouse Box. Select your Doc from this list
    > Click OK (this will close the box)
    > Mark the “display as icon†box
    > Click OK
    > Bring the OLE into the form (it will be displayed as the standard Word Doc
    > logo)
    > Click the logo to go to the doc.
    >
    > This method should not increase the size of your DB field by more than
    > another small logo type (about 4kb per item)
    >
    > Hope this helps
    >
    > --
    > Wayne
    > Manchester, England.
    >
    >
    >
    > "Mike Smith NC" wrote:
    >
    > > Wayne-I-M
    > > The images in the .doc files are inserted as links but when the graphs
    > > actually show up the size increase to a ridiculous amount. I have been
    > > changing them to icons and this reduced the size. I just go to the convert
    > > linked image selection.
    > > Since they are linked why does it balloon the size so much? What can I do?
    > > Thanks for the time.
    > >
    > > "Wayne-I-M" wrote:
    > >
    > > > Hi Mioke
    > > >
    > > > You can store your doc's on your hard drive and link to them from a form
    > > >
    > > > Or embed a thumbnail of the doc in a form.
    > > >
    > > > For details of how to do this check out the answer I gave a few hours ago
    > > > answering the question "i cant embed a .bmp file in access"
    > > >
    > > > I would suggest linking to the doc's rather than embeding but this depends
    > > > on what you're going to do with the Datbase.
    > > >
    > > > Hope you find it helpful
    > > >
    > > > --
    > > > Wayne
    > > > Manchester, England.
    > > >
    > > >
    > > >
    > > > "Mike Smith NC" wrote:
    > > >
    > > > > Is there a way to have .doc image files displayed on forms and reports
    > > > > without bloating the database size? I know I can go through each image and
    > > > > put it through paint but is there an easier way to see these.
    > > > > Thanks for any help
     

Share This Page