Adding Pictures into Table

[VanillaAwesome]

I have been all over the internet and the forum looking for this answer but everyone
seems to have a different way of doing things. So far, none of them
work.

What I really need to do is to display a bitmap image in an access
table. I dont want to create a link to the table I need to physically
see the image when the table loads. This is for a final project and its
the last thing I need to do.The project calls for 15 state flags to be
displayed with their state name in a table. Here is what I have so far.

Save data type as OLE object
Right click and select insert object
choose create from file
Select my Bitmap image of the state flag

My issue is that all that shows up is text reading Bitmap image shows
up. If I click on it it say paintbrush image and loads MS paint. I have
read all about how to code the picture in a separate file and how to
integrate it as a BLOB but this is all overly complicated and time
consuming for this little project.



If I can clarify something, let me know. Please and thank you for the help.

[June7]

I don't think can show the image in table. Build a report and bind an OLE or Image control to the field.

The image is embedded in the table or just a path to external file?

[orange]

I agree with June, you won't see the image in the table.
Here's a video on adding OLE object to a table and displaying that Object (Picture/image) on a form.

http://www.youtube.com/watch?v=QFUDt0cpIi0

[VanillaAwesome]

June7- right now it is just a path to an external file. If you click on where it says Bitmap image MS paint launches and it shows the image. I believe I am supposed to embed the image for viewing in the table.

Orange- Okay, so i used the form wizard to see what my flag field displayed if I I had a bitmap image stored and it does display the image. Here is what the sylabus says in regards to the image of the flag.

Select 15 fields from the list of for each state – you will be using the same fields for all of the states. These fields should be based on the categories in the 50states web site. This flag of each state will be one of the fields.

She goes on to say...
Create a database with the appropriate fields and properties.
(One field in the table must contain a flag of the state.)

I will contact her to make sure I am interpreting this correctly but I believe she wants the image viewable in the table. If not I could just hide that column and it will display in the Form portion of the final.

[VanillaAwesome]

Okay, Honestly I think that teacher is confused about what she wants. She just told another student in our forum to make data type an attachment. Can someone explain how this would be different from OLE Object?

[June7]

I have never used the OLE Object type but think the field is limited to one embedded file. An attachment data type is actually a multi-value kind of field and allows multiple files to be stored in the same field and that field really stores links to a hidden table where the values are actually stored.

The appropriate application launches when you click on the OLE field in table. Build a report and bind control to the field and depending on the file type it will display within the control.

Review https://www.accessforums.net/reports...eld-30861.html

[VanillaAwesome]

thank you everyone for your help. Sorry that this was, in a way, a waste of time.

[orange]

?? Just which part was the waste of time??
You had an issue; you did some internet searching; you found and told us some of the trends you found; you got some suggestions, some links, some opinions; and I think you discovered you didn't have all the info for the project (teacher telling slightly different stories of requirements (or students only hearing the pieces they clearly could identify with) ...
and you seem to have made some decision about how you will proceed (just didn't tell us).

Seems like a pretty good hour and a half to me.

Good luck with your project.