require a method to input images corresponding to unique images

    I would appreciate the best method to input images corresponding to unique images.


    Product name:
    Product code:


    Each product code, has 3 images
    1 image in GIf
    2 image in Jpeg


    If I establish a table with fields:


    Product name
    Product code
    Image name (format) xxxxxx.gif or xxxxxx.jpeg
    Image code


    How do I get it to equate the correct image to the correct product name and code?


    Preferably I would like to do this with hyperlinks and not stick the image directly into the


    Access database.


    based on my understanding:
    a) I have to create a folder and stick the images into it
    b) stick hyperlinks into Excel and link this to Access table


    I need a method where hundreds of these images will be processed.


    thanking you in advance

    Re: require a method to input images corresponding to unique images


    have you had a response on this ?


    I have a similar issue and would be very interested to hear

    Re: require a method to input images corresponding to unique images


    I am not quite sure what you are trying to do.


    Do you want to have a form that displays information on the products and also displays a picture?


    Or are you simply trying to build a catalogue of pictures?


    A.

    Re: require a method to input images corresponding to unique images


    thanks for coming back


    i'd like to create a list of products which i can filter and displays the appropriate picture in the cell next to the name


    eg


    product a :rock:
    product b

    Re: require a method to input images corresponding to unique images


    The only method I use would not work for a continuous form. It works for a single form, but it sounds like this is not what you want.


    I have seen screen shots of Acccess making this work, but have never got it to work effectively myself. Access seems to always store a copy of the picture in the data base and therefore the file grows very very quickly.


    If you simply want to see one image on the screen at a time then:
    Insert an unbound picture on the form.
    Then edit the OnCurrent event such that with each new record the picture for the image is updated. I will try to find the code if you want this solution. However, as I sadi it will not work for continuous forms.


    A.

    Re: require a method to input images corresponding to unique images


    got a way....of sorts :


    Another good use for Cell Comments is to add pictures to them. After adding a Cell Comment, right click in the cell and choose Edit comment. Now double click the dotted outline of the Comment where the size handles are, and then click the "Colors and Lines" page tab. From this page click the drop arrow from the "Color" box and then "Fill Effects" and finally "Picture" then "Select Picture". A good one to add is a picture of a chart!


    Does this help you - it gets partly through my issues
    .

    Re: require a method to input images corresponding to unique images


    What application are you working in? This is an Access forum and it sounds to me like you are using Excel. In which case your solution is quite a smooth way of displaying a picture when you enter a cell.


    However this requires each picture to be added manually. I suspect that you would like to have the name of the file in a cell and then to automatically open the picture. A macro would be able to create the comments for you and do all of the shading. If you need help with that then I suggest that you post to the Excel forum.


    Cheers,


    A.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login