Access 2010 - Images on Forms

[dluhop]

I'm running Access 2010. I'd like to put a different image on each page of a form or report. Is there a way to do this with OLE objects or links to my hard drive without coding? Everything I read on the internet tells me that I can't in the 2010 version of Access. Any help would be very welcome.

[RuralGuy]

Do you see anything in the Northwind Traders sample that comes with Access similar to what you want? Maybe the employees section?

[dluhop]

I'm not familiar with the Northwind Traders sample. How do I access it? Thanks for quick reply.

[dluhop]

I see the Northwind Traders sample is for Access 2000. I'm led to believe that things that might have worked in 2000 do not work in Access 2010.

[boblarson]

There's a 2010 version. See this linke to see how to get it:
http://social.technet.microsoft.com/...2-4deb4c834f08

[dluhop]

Bob, I got the new Northwind Traders database. The only thing I see that shows my original question is the Employee's Detail form. All the pictures are the same. That I can do. What I want to do is put a different picture on each page of the form. Is this possible?

[dluhop]

You would think this feature would be pretty basic to any database software. I could do it with Lotus software (Approach) in 2000.

[RuralGuy]

Every record can have a different picture if that is what you want. Larry has some examples: http://accdevel.tripod.com/imaging.htm

[dluhop]

If I was a Microsoft MVP, I might be able to understand this stuff. Unfortunately, I'm not. I don't want to rewrite Access. At this point, it seems to me that the answer to my original question is no, you can't have a different image on each page of a form or report without doing extensive coding in Access 2010.

[RuralGuy]

It is real simple code in the Current Event of the form. You keep saying Page of a Form. Do you really mean a multi-page form or just different records in a single form. We can help you write the code. It is just one line.

[dluhop]

O.K., here's what I want to do. I have a collection of airplane cards. There are 200 cards in the set. I've designed a database in Access 2010 to keep track of the cards - where they came from, how much they cost, which plane is on each card, etc. I'd like to create a form or report that has 200 pages (one page for each card) and have a picture of the card on it - maybe multiple images on each page. I'd like to link to the images on my hard drive, rather than embed the images in my database (to save space).

I have both .jpg and .gif files for all 200 cards, front and back. I'd prefer to use .jpgs. I'm not a total dweeb, when it comes to computers. I used to be a programmer about 40 years ago, just recently built my own computer, have designed a few datbases in Approach (used to work for IBM). I got Access 2010 to update my skills and have some fun along the way. I appreciate your help in this endeavor.

[RuralGuy]

It is easy. I have to leave for a few hours but I'll be back and help you get it done.

[RuralGuy]

Do you have these url's in the record your are displaying? Does it include the complete path? c:\...

[dluhop]

Sorry this took so long to answer. I never got an e-mail that you replied. I'm not sure where to put the path to the images. I have the complete path in my "card" table. What goes in the form? I really need a step-by-step. Would it help if I sent you something? What about the Current Event code? How do I do that?

[RuralGuy]

Your form displays all of the details about a card right? The form has a RecordSource of a query or table. Does that table have a relationship with the "card" table?