Iinserting a picture into a Form

[djclntn]

I'm having issues with inserting a image/picture into my Forms, The issue being, say I have 5-Forms in which I want to insert 5-different pic for each indiv Form. When I insert a pic in Form-1 it also appears in all of the other 4-Forms also. Likewise, when I change the pic in Form-2, than that pic appears in all of my other forms. Can anyone give me any direction as to how I can insert 1-pic into just 1-Frm without it "copying" into the rest of my Forms which seems to be the problem?

Thanks

[June7]

How are you inserting the image? Is this a link in a field of table? Are the forms bound to the same table?

If you would like to provide the project for analysis, I will look at.

[djclntn]

June,

I'm sending you my database/project, but you must understand some things. I shared with someone on this forum my situation & I strongly believe it might have been with you. I don’t work being severely disabled, but for some reason I have this great passion with Access & databases which I barely know the tip of the iceberg. Therefore, it’s important to know that my Databases are not “real”, but I have a great imagination & I create these, “mock” databases as 1) a challenge, 2) a learning experience for me, & 3) entertainment. Enough said.


This database which I’m sending you is purely make-believe; it’s me managing a used car dealership. I have a form with each used car info & I wanted to include a picture of the vehicle within the form. I find these used vehicles on the Internet. Aside from trying to insert pictures into my Forms, I’m also having great trouble with rationing my Tables & I can’t pull data from more than one table. Feel free to take a peak if you might have time.

In closing, I hope that you aren’t finding me as a freak or a weirdo; I do this to occupy myself with being totally homebound at this time.

Thanks for your interest in wanting to look.

Dave…

[djclntn]

June,

I'm resending you the database with the pics; I forgot & left them out in the fiirst dbs I sent you

[June7]

Doesn't matter to me why you are creating these databases. It offers a puzzle challenge and learning experience for me as well. If you think your products would be useful to others, could post them in the Sample Databases forum.

I downloaded the second file but I don't see any images nor any controls on forms for images.

[djclntn]

Ok June, please excuse my mishaps, but I made sure that the pics are in this dbs. I also sent you the pics of the different vehhicles in the zip file.

What this "Sample Database Form" you mentioned; I;'m definatelyy have to check this out for my own beneifit in learning some things. As a matter of fact I've been thinking about posting a question in the "General Discussion Forum" if there vwas any sites which gave sample databases just to get some ideas. You must of read my mind :-)

Thanks

[June7]

Nope, still don't see any pictures on any forms nor any control for an image and no image files in the zip folder. I was able to download the thumbnail image. If I can't see what you tried to do can't tell you what went wrong.

Sample databases are all over the place. When you open Access to start a new project you will see a selection of templates. Google Access database templates for more. The main page of this site has a forum called 'Sample Databases' - toward bottom of the page. Many tutorials (by MS and other parties) use one called Northwind. It has been around for ages. Many other sites offer databases for free download. Developers can submit templates to MS, review http://blogs.office.com/b/microsoft-...ffice-com.aspx

[djclntn]

One lastt ry

[June7]

Okay, the Vehicle Inventory form has a control with a picture. You originally stated the problem was that the same picture shows on 5 forms. Perhaps you meant to say the same picture shows for every record on the Vehicle form? That is because it is a static image, not dynamic. Make the image dynamic by having a field in table that either has the image in an Attachment field or in a text field has path to the image stored outside the database. Then set the ControlSource property of image control to that field. A ControlSource property for image control was an upgrade with Access 2007.

[djclntn]

June, thanks, it worked!

Listen, I hate to lean on you or take advantage, but I can't/don't know how to relate these tables. I'm doing a lot of double typing/imputing which I know can be elimited if I had these tables properly related. Or, "Joined"

Let me give you some examples:

In my Vehicle Inventory Table I wish to have the customerID & the SalesRepID.

In my Sales Rep Table (formerly my Employees Infor Table) I want to see all of the VehiclesID assigned to each SalesRepID

When I attempt to run queries with more than 1-table i get no results in return. My Tables are just NOT related & this is something that I really struggle with & I must of read how to relate tables, but I'm just not getting it.

Might you take a peak & offer some suggestions?

[June7]

Answer these questions:

Will Employer have many Customers? Will Customers have many Employers? Why is customer employer relevant?

Answer these questions for other relationships: vehicles/customers, vehicles/employees.

Anytime there is a many side to a relationship, a junction table is needed so as to avoid repetitive entry of data.

Say each employee can have many vehicles:
EmployeeVehicles
EmployeeID (foreign key)
VehicleID (foreign key)

Now when you want to view the related vehicle and employee detaiils, do a query that joins these three tables.

Data entry would be simplified with form/subform arrangement. Assuming the above relationship, main form bound to Employees, subform bound to junction table.

Review this http://forums.aspfree.com/microsoft-...es-208217.html

[djclntn]

I'm sorry June -- I'm REALLY sorry, I can't learn by reading; it's been my downfall all of my life which is why I bombed out of college shortly after 3-semesters. If I can "watch/see" somebody do something I can pick I up in a span & expand on the concept. Unfortunately this is not a situation where I can be "visable" shown what to do step-by-step.

To address your questions above, I'm going to throw a twist in the fire & change "Employee" to "Sales Rep" since this is a "Sales" oriented database. Here are some facts:

1. One customer only has one sales rep & lets say for now only has vehicleID (purchase) fo now.
2. Each VehicleId has of course 1-CustomerID & is assign to 1-Sales RepID.
3. A SalesRepID has multiple CustomersID as well as multiple VehiclesID.

Now, granted maybe Iwant to see too much duplicate data in my Tables/Forms, but that's probably just my obsessiveness

[djclntn]

Here's the rest of my message:

On each of my Vehicle inventory Form aside from the “Vehicles info & pic I also want to see the CusmerID (who purchased the vehicle) & the salesRep who sold the vechicleID. Why you ask, I don’t know. Now, in a query, I was able to take ALL of the vehicleID info I wanted & from my Customers Info table I was able to pull the customerID which coinside with the vehicleID (the vehcle they purchased. However, on this form I also want to see which SaleRepID sold the vehicleID which after 2-hours of trying everything possible I could think of just isn’t happening. Can I send you back my database & maybe you can take a gander?

I really ought to take a break, relax & watch the Super Bowl which I just may do.

As always, thanks for your time

[June7]

This thread from the same site as the other tutorial has demo videos in http://forums.aspfree.com/microsoft-...os-197463.html

I haven't looked at them so don't really know what they cover. In that thread is another link to a demo/tutorial at http://www.developerbarn.com/microso...-database.html

Need to get the data structure correct. I suggest you not proceed until you fully understand relational database concepts. When you can identify the entities of your data and how they relate, you will be able to properly set up tables. The link I offered earlier on database concepts is very good and with the graphical description, I should think a little concentrated study and you will get a grasp.

And when you get beyond the introductory stuff, check out these http://datapigtechnologies.com/AccessMain.htm

[orange]

IN addition to June7's comments and links

If you google for videos "normalization langer" you will find a series of free videos by Dr.Art Langer. These are quite good for learning by Watching/Listening
rather than reading.

I have listed the videos in sequence

http://www.youtube.com/watch?v=IiVq8M5DBkk Logical data modeling

http://www.youtube.com/watch?v=BGMwuOtRfqU Candidate key

http://www.youtube.com/watch?v=ZiB-BKCzS_I Normalization

http://www.youtube.com/watch?v=pJ47btpjAhA Normalization example

http://www.youtube.com/watch?v=q3Wg2fZENK0 1st Normal form

http://www.youtube.com/watch?v=vji0pfliHZI 2nd Normal form

http://www.youtube.com/watch?v=HH-QR7t-kMo 3rd Normal form

http://www.youtube.com/watch?v=q1GaaGHHAqM E_R Diagramming

You can go back and watch these as often as you want.

Good Luck