Unanswered: Adding an image to a table, help please
I have a table and I want to add an image to certian entries in the table
the data in the table has groups based on a number (num) in one of the fields, basically I want to search through the table and find the last instance of any number (last one in the group) and add the image as an OLE object to that record
I have my table ready, but am struggeling with, a) finding the last instance on num, and, b) adding my image to the table
Not a good idea to add the Image to the table the Database will get ***** big Quick
What I did is store the File name of the image in a field then got the the onCurrent to add the path. then got to to dispaly the Image
it a bit Slower as it has to load the image each timebut the database Will be heaps smalller.
hope this help
See clear as mud
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
the table's contents are deleted everytime the code runs, and there are only usually 1 - 2 hundred records added, so only 10 - 15 occurances of the image (it is a tiny bmp I am using when producing a set of labels from a report, the image is going to be used to make it very obvoius where one set stops and the next starts, I have linked my OLE object from the table to a bound object frame on my report, and it works perfectly it I manually add the images, but I need to add them via my code....not sure where to start