Displaying Pictures for products on a Search Result

[mikey222]

Hi Folks i created a product database that includes forms of different products and a search engine that allows users to search under different criteria.

My goal is to allow users to check out the pictures of the products on the search page, possibly a pop up picture when during roll over mouse on a product link

Thanks and looking forward for some assistance

 

[mikey222]

anyone??? thank you

 

[mikey222]

is it impossible??

 

[John Big Booty]

There is a search function on this forum.

But as you haven't found it yet try here or here

 

[mikey222]

Thank John for replying, i already have picture displays without storing them to the access file. I'm trying to find a way to display those pictures after the users perform a search (second picture). Since the search results are all text and i need to find a way where users could click on a link on the search page to check out the picture of the products.

Thanks!

 

[John Big Booty]

You could use the on Double click event to open a pop up form that shows the related image.

    Dim stDocName As String
    Dim stLinkCriteria As String

    stDocName = "FRM_Name"
    
    stLinkCriteria = "[LinkID]=" & Me![LinkID] ' Replace LinkID with the name of the field you wish to link on.
    DoCmd.OpenForm stDocName, , , stLinkCriteria, , ,

You would also need to put a test in the On Load event of the form that would close the form an pop up a message box to advise if there was by chance no image available for a particular product.

 

[mikey222]

Thanks for replying again John

I've input

Private Sub OpenForm_Click()

End Sub

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "FRM_Name"

stLinkCriteria = "[C:\Users\Michaelluk\Desktop\A\A0834.jpg]=" & Me![C:\Users\Michaelluk\Desktop\A\A0834.jpg] ' Replace LinkID with the name of the field you wish to link on.
DoCmd.OpenForm stDocName, , , stLinkCriteria, , ,


to the button openform

but then i have so many products how can i assign the button to show different picture paths

in addition, when i try to click on the button it gives me an error

Thanks

 

[mikey222]

I'm a novice on access hope you dont mind i'm asking so many questions and appreciate the effor to help out! ^^

 

[John Big Booty]

Have a look at the attached sample which is just Oldsoftboss's Sample DB from here, with an additional form, hope that helps.