If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Images for each product in a pop-up window
I need to find a way to display the picture for each record in a form already
built in Access 2000. The pictures are stored on the server and I built a table with the record ID and the link to the picture. I do not know how to display the image of each product on a pop-up window when look up for product by ID. Not quite sure if it possible to display the image on a pop-up window and how to do it. Many thanks! |
#2
|
|||
|
|||
Images for each product in a pop-up window
See the Categories form in the sample Northwind database (Help, Sample
Databases). Sprinks "CC" wrote: I need to find a way to display the picture for each record in a form already built in Access 2000. The pictures are stored on the server and I built a table with the record ID and the link to the picture. I do not know how to display the image of each product on a pop-up window when look up for product by ID. Not quite sure if it possible to display the image on a pop-up window and how to do it. Many thanks! |
#3
|
|||
|
|||
Images for each product in a pop-up window
Hi Sprinks,
Thank you for your answer! I checked the Categories form in the sample Northwind database. Looks great but I need to dipslay the product image in a separate window not in the main form. I've already built the form for the application and after that I was asked to display the image for each product, like an online Catalog. There are more than 2000 products in database. The image are .bmp strored on the server. In the form I created a combo box to retrieve information about each product and there are two subforms too. So there is no enough space on the form to display the image the way it shows in the Northwind that's why I thought a solution could be to dipslay the images in a pop-up window when click a command button or something like that. Not sure if it possible to do this in Access, but I really have to find a way to display the images, I cannot think of something else and my boss wants it right away. Please any idea could help! Many Thanks! "Sprinks" wrote: See the Categories form in the sample Northwind database (Help, Sample Databases). Sprinks "CC" wrote: I need to find a way to display the picture for each record in a form already built in Access 2000. The pictures are stored on the server and I built a table with the record ID and the link to the picture. I do not know how to display the image of each product on a pop-up window when look up for product by ID. Not quite sure if it possible to display the image on a pop-up window and how to do it. Many thanks! |
#4
|
|||
|
|||
Images for each product in a pop-up window
CC,
Create a second form, based on the same query as the main form, or a subset thereof, that includes the image. Then open the 2nd form as a popup, using the optional Where clause and WindowMode parameters: Dim stDocName As String Dim stLinkCriteria As String stDocName = "Your2ndForm" stLinkCriteria = "[ProductID]=" & Me![ControlOn1stFormWithProductID] DoCmd.OpenForm stDocName, , , stLinkCriteria, , acDialog Hope that helps. Sprinks "CC" wrote: Hi Sprinks, Thank you for your answer! I checked the Categories form in the sample Northwind database. Looks great but I need to dipslay the product image in a separate window not in the main form. I've already built the form for the application and after that I was asked to display the image for each product, like an online Catalog. There are more than 2000 products in database. The image are .bmp strored on the server. In the form I created a combo box to retrieve information about each product and there are two subforms too. So there is no enough space on the form to display the image the way it shows in the Northwind that's why I thought a solution could be to dipslay the images in a pop-up window when click a command button or something like that. Not sure if it possible to do this in Access, but I really have to find a way to display the images, I cannot think of something else and my boss wants it right away. Please any idea could help! Many Thanks! "Sprinks" wrote: See the Categories form in the sample Northwind database (Help, Sample Databases). Sprinks "CC" wrote: I need to find a way to display the picture for each record in a form already built in Access 2000. The pictures are stored on the server and I built a table with the record ID and the link to the picture. I do not know how to display the image of each product on a pop-up window when look up for product by ID. Not quite sure if it possible to display the image on a pop-up window and how to do it. Many thanks! |
#5
|
|||
|
|||
Images for each product in a pop-up window
Hi Sprinks,
Thank you for your answer! I checked the Categories form in the Northwind database, looks great! I tried this example but the problem is I need to use a Hyperlink to the file where the product's picture is stored. The form has two subforms and there is not enough room to display the picture on the form, that's why I thought to find a way to display the images on a pop-up window for each product. There are more than 2000 products and the bmp images are strored on the server. Not quite sure if it is possible to do it in Access 2000, but I do not have other ideas. Any suggestion could help, please! Many Thanks! "Sprinks" wrote: See the Categories form in the sample Northwind database (Help, Sample Databases). Sprinks "CC" wrote: I need to find a way to display the picture for each record in a form already built in Access 2000. The pictures are stored on the server and I built a table with the record ID and the link to the picture. I do not know how to display the image of each product on a pop-up window when look up for product by ID. Not quite sure if it possible to display the image on a pop-up window and how to do it. Many thanks! |
#6
|
|||
|
|||
Images for each product in a pop-up window
Thank you again! I'll try it. I've already created a new form to display the
images but don't know how to open it from the main form. "Sprinks" wrote: CC, Create a second form, based on the same query as the main form, or a subset thereof, that includes the image. Then open the 2nd form as a popup, using the optional Where clause and WindowMode parameters: Dim stDocName As String Dim stLinkCriteria As String stDocName = "Your2ndForm" stLinkCriteria = "[ProductID]=" & Me![ControlOn1stFormWithProductID] DoCmd.OpenForm stDocName, , , stLinkCriteria, , acDialog Hope that helps. Sprinks "CC" wrote: Hi Sprinks, Thank you for your answer! I checked the Categories form in the sample Northwind database. Looks great but I need to dipslay the product image in a separate window not in the main form. I've already built the form for the application and after that I was asked to display the image for each product, like an online Catalog. There are more than 2000 products in database. The image are .bmp strored on the server. In the form I created a combo box to retrieve information about each product and there are two subforms too. So there is no enough space on the form to display the image the way it shows in the Northwind that's why I thought a solution could be to dipslay the images in a pop-up window when click a command button or something like that. Not sure if it possible to do this in Access, but I really have to find a way to display the images, I cannot think of something else and my boss wants it right away. Please any idea could help! Many Thanks! "Sprinks" wrote: See the Categories form in the sample Northwind database (Help, Sample Databases). Sprinks "CC" wrote: I need to find a way to display the picture for each record in a form already built in Access 2000. The pictures are stored on the server and I built a table with the record ID and the link to the picture. I do not know how to display the image of each product on a pop-up window when look up for product by ID. Not quite sure if it possible to display the image on a pop-up window and how to do it. Many thanks! |
#7
|
|||
|
|||
Images for each product in a pop-up window
Perhaps this link will help. And be sure to add Access Web to your list of
favorite Access resources. There is a lot of vital information there. Sprinks "CC" wrote: Hi Sprinks, Thank you for your answer! I checked the Categories form in the Northwind database, looks great! I tried this example but the problem is I need to use a Hyperlink to the file where the product's picture is stored. The form has two subforms and there is not enough room to display the picture on the form, that's why I thought to find a way to display the images on a pop-up window for each product. There are more than 2000 products and the bmp images are strored on the server. Not quite sure if it is possible to do it in Access 2000, but I do not have other ideas. Any suggestion could help, please! Many Thanks! "Sprinks" wrote: See the Categories form in the sample Northwind database (Help, Sample Databases). Sprinks "CC" wrote: I need to find a way to display the picture for each record in a form already built in Access 2000. The pictures are stored on the server and I built a table with the record ID and the link to the picture. I do not know how to display the image of each product on a pop-up window when look up for product by ID. Not quite sure if it possible to display the image on a pop-up window and how to do it. Many thanks! |
#8
|
|||
|
|||
Images for each product in a pop-up window
Sorry, which link? I created the new form and created an unbound object
frame. I am stucked on how to display the image for each record. Probably it is very easy but right know I cannot see how it should be done. Thanks! CC "Sprinks" wrote: Perhaps this link will help. And be sure to add Access Web to your list of favorite Access resources. There is a lot of vital information there. Sprinks "CC" wrote: Hi Sprinks, Thank you for your answer! I checked the Categories form in the Northwind database, looks great! I tried this example but the problem is I need to use a Hyperlink to the file where the product's picture is stored. The form has two subforms and there is not enough room to display the picture on the form, that's why I thought to find a way to display the images on a pop-up window for each product. There are more than 2000 products and the bmp images are strored on the server. Not quite sure if it is possible to do it in Access 2000, but I do not have other ideas. Any suggestion could help, please! Many Thanks! "Sprinks" wrote: See the Categories form in the sample Northwind database (Help, Sample Databases). Sprinks "CC" wrote: I need to find a way to display the picture for each record in a form already built in Access 2000. The pictures are stored on the server and I built a table with the record ID and the link to the picture. I do not know how to display the image of each product on a pop-up window when look up for product by ID. Not quite sure if it possible to display the image on a pop-up window and how to do it. Many thanks! |
#9
|
|||
|
|||
Images for each product in a pop-up window
CC,
Sorry. http://support.microsoft.com/kb/323033 Sprinks "CC" wrote: Sorry, which link? I created the new form and created an unbound object frame. I am stucked on how to display the image for each record. Probably it is very easy but right know I cannot see how it should be done. Thanks! CC "Sprinks" wrote: Perhaps this link will help. And be sure to add Access Web to your list of favorite Access resources. There is a lot of vital information there. Sprinks "CC" wrote: Hi Sprinks, Thank you for your answer! I checked the Categories form in the Northwind database, looks great! I tried this example but the problem is I need to use a Hyperlink to the file where the product's picture is stored. The form has two subforms and there is not enough room to display the picture on the form, that's why I thought to find a way to display the images on a pop-up window for each product. There are more than 2000 products and the bmp images are strored on the server. Not quite sure if it is possible to do it in Access 2000, but I do not have other ideas. Any suggestion could help, please! Many Thanks! "Sprinks" wrote: See the Categories form in the sample Northwind database (Help, Sample Databases). Sprinks "CC" wrote: I need to find a way to display the picture for each record in a form already built in Access 2000. The pictures are stored on the server and I built a table with the record ID and the link to the picture. I do not know how to display the image of each product on a pop-up window when look up for product by ID. Not quite sure if it possible to display the image on a pop-up window and how to do it. Many thanks! |
#10
|
|||
|
|||
Images for each product in a pop-up window
Hi Sprinks,
Thanks a lot for the link! seems more complicated than I thought. It looks as I have to built a new Web page. What I've done so far is just to open the folder where the images are stored. From there I have to look up for the image for the product and to click on it to display it. Personally I don't mind but they won't like it,... I don't know how to go to the image for that record selected form list when click the button and open it up in a pop-up window. Probably, I have to give up,... Cheers, CC "Sprinks" wrote: CC, Sorry. http://support.microsoft.com/kb/323033 Sprinks "CC" wrote: Sorry, which link? I created the new form and created an unbound object frame. I am stucked on how to display the image for each record. Probably it is very easy but right know I cannot see how it should be done. Thanks! CC "Sprinks" wrote: Perhaps this link will help. And be sure to add Access Web to your list of favorite Access resources. There is a lot of vital information there. Sprinks "CC" wrote: Hi Sprinks, Thank you for your answer! I checked the Categories form in the Northwind database, looks great! I tried this example but the problem is I need to use a Hyperlink to the file where the product's picture is stored. The form has two subforms and there is not enough room to display the picture on the form, that's why I thought to find a way to display the images on a pop-up window for each product. There are more than 2000 products and the bmp images are strored on the server. Not quite sure if it is possible to do it in Access 2000, but I do not have other ideas. Any suggestion could help, please! Many Thanks! "Sprinks" wrote: See the Categories form in the sample Northwind database (Help, Sample Databases). Sprinks "CC" wrote: I need to find a way to display the picture for each record in a form already built in Access 2000. The pictures are stored on the server and I built a table with the record ID and the link to the picture. I do not know how to display the image of each product on a pop-up window when look up for product by ID. Not quite sure if it possible to display the image on a pop-up window and how to do it. Many thanks! |
Thread Tools | |
Display Modes | |
|
|