Dynamic Images

[Silvera]

I have been using Access for years now and basically self-taught with Forum help. My current project is to set up a database for my firm's details. I am an architect and we have literally thousands of details with no real search method other than general categories. I want to take advantage of the search function where you can type in parameters like window, sill, wood frame and get a list of details that meet those general parameters. From there they could get a list of file names that meet those parameters. With that information they could type in a file name and a GIF for the detail would be displayed for them. Doing a recent Google search I saw a video that seemed to do that but the simple code crashed, "Compile error" "Method or data member not found":



Private Sub Form Current ()
DetailNumb.Picture - DetailNumb
End Sub

DetailNumb is the field name with the path to the wanted GIF.
Any suggestion will be realty appreciated

[ranman256]

you cant subtract photos... maybe = sign.

[June7]

Why do you have a '-' instead of '=' character?

Referencing field name is not appropriate. Picture is property of Image control. So what is the name of the Image control on form or report?

Image control has a ControlSource property (introduced with Access 2007). All you really need to do is set that property to an Attachment type field with embedded images OR set it to path of external file. So assuming the file name (without .gif extension) is stored in a field, ControlSource can be like:

="C:\Images\" & [fieldname] & ".gif"

Now apply filter criteria to find that record.

[Silvera]

Yes "-" was a typo. I have the path with the ".GIF" in a table. Thanks for the quick response! I'll give it a go when I get home later today. I recognize your logo from the past. It's great to have folks like you and ranman256 available. I really appreciate what you folks do for the rest of us duffers!