Displaying Pictures for products on a Search Result

mikey222

Registered User.
Local time
Yesterday, 23:51
Joined
Nov 4, 2008
Messages
40
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

productformvk3.jpg
searchenginetd8.jpg


Thanks and looking forward for some assistance :o:o
 
is it impossible??
 
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!
 
You could use the on Double click event to open a pop up form that shows the related image.

Code:
    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.
 
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

searchbuttonhl8.jpg


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

searchengine1pj0.jpg


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

Thanks
 
I'm a novice on access hope you dont mind i'm asking so many questions and appreciate the effor to help out! ^^
 
Have a look at the attached sample which is just Oldsoftboss's Sample DB from here, with an additional form, hope that helps.
 

Users who are viewing this thread

Back
Top Bottom