Share via

Creating a database of image files

Anonymous
2012-06-30T12:22:14+00:00

Hi.

I am trying to create a database of image files where I can search/sort by other fields (eg. year, type...). After finding the images I want I then want the database to form a file (word/pdf or other) that has all these images in that I can then print. Even better would be if I could select individual images to input and then change my sort fields to add other images.

I am not to sure if this is possible. But I do not even know where to begin and any help would be really appropriated. Thank you a lot!

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2012-07-01T12:20:46+00:00

    hI

    For the second time this week . .  check out http://www.ammara.com/

    this little add-in will give you great control over the images - JPG . .

    But you still need to put together a table structure to create your index.

    for printting these pics - in any combination . . create reports and add the pics in as controls on the report.

    if you download the DBPix program ( free with a watermark ) it has sample DBs to see how to use it.

    These samples may give you the info to create your index DB

    cheers

    PaulG

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2012-07-01T13:29:45+00:00

    Although it is possible to store images and it can be done in several ways in the later version, it is not adnisable to do so. Even with the Ammara control (which does work well) the database will fill quickly and both individual and network performance can suffer. I have a free utitlity on my website that will traverse a directory and save the path of every image file in a table. There are also demos of displaying in a form or report. All of this is free for you to import into your own database:

    http://www.datastrat.com/Download/Picture2K.zip

    --

    Arvin Meyer, MCP, MVP

    http://www.datastrat.com

    http://www.accessmvp.com

    http://www.mvps.org/access

    co-author "Access Solutions" published by Wiley

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2016-02-18T16:02:59+00:00

    That's an exceptionally handy little tool. 

    I've been puzzling this very problem for some time and trying to fiddle some sort of data app/report together.

    Thank you for sharing!

    0 comments