By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,602 Members | 994 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,602 IT Pros & Developers. It's quick & easy.

Photo Catalog

blyxx86
100+
P: 256
I am attempting to design a database that will let me create dynamic catalogs for various products. I have photos that will go with each product. I have attempted to create a database using an OLE object.

I have been able to get the OLE Object to display in the report but I am having a problem getting the photo to center in the bound image object.

Also, there seems to be plenty of problems using Access and images so I am wondering if there is a better program to develop catalogs for products? I had hoped to use a database since there are various customers each with various products.

Any suggestions?
May 1 '07 #1
Share this Question
Share on Google+
5 Replies

Rabbit
Expert Mod 10K+
P: 12,441
What about just storing the path to the image?
May 1 '07 #2

blyxx86
100+
P: 256
What about just storing the path to the image?
I have found this code:
Expand|Select|Wrap|Line Numbers
  1. Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
  2.     Me![Imageframe].Picture = Me![Imagepath]
  3. End Sub
This would allow me to show the photo based on the path stored, but how would I create a form that would let me save the image path to a table without me having to manually type in the path?
May 1 '07 #3

Rabbit
Expert Mod 10K+
P: 12,441
There's a way to bring up a file dialog but I've never done that before. I know some of the other experts on this site have though so you might want to make a new post asking how to use that. But first you'll want to do a search.
May 1 '07 #4

puppydogbuddy
Expert 100+
P: 1,923
see these links:

http://support.microsoft.com/kb/279508


free download BrowseAndOpenFiles.mdb with source code
http://www.candace-tripp.com/pages/a...wnloads.aspx#8
May 5 '07 #5

puppydogbuddy
Expert 100+
P: 1,923

Post your reply

Sign in to post your reply or Sign up for a free account.