[pic1] is the name of the picture control, [text1] is the name of the textbox
on the form or report that has the path. I would make the table with a text
or memo (if you could have real long path names). for the on current click
the form properties, event tab, click in the on current event, click the
three dots, and select event procedure. Do something simular on the report
but on the details section, events tab and on format.
Gary S said:
Do I store the path in a Text field, OLE field, Link field ?
Define your code? What is [Pic1] and [text1] Me. and .picture?
Where does this code go in the field properties or the form properties?
Can you say what you said simplier for a non-programer?
Thank you,
:
If it is just pictures, you can store the path to the picture in your table.
Then use the image contol on your forms and reports. In your form in the on
current event put some code like:
Me![Pic1].picture= Me![text1]
You can hide the text box that is holding the path. You will also want to
put that code where you are setting the path. On reports put that code in
the on format of the details section.
:
Is there a better way for non-programers to store and veiw .jpg photos in
Access and on reports. I have seen solutions using specialized programs,
which I have downloaded and looked at, but I don't understand how to use them
in my databases. I need to see the photos in the forms and print them on
reports. Everything works fine but the database gets real big.