I have a Form, which will display anywhere form 2 to 200 hits at a time. I understand that to have a unique thumbnail image for each of these hits, I will have to use an OLE, that I first link into my table. If i prepare a field with the path to that photo, is there any way to wirte some code that will let me link all of my photos into my table quicker? I have over 10,000 photo's to link. I know this will cause bloating, but I have to get these photos in, and other methods of linking don't work. My photos are only 16kb each, total of 160 meg for the bloat (could be worse). Any help would be great. Thanks
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
10,000 OLE Links 1
- Thread starter DedCat
- Start date
- Thread starter
- #3
- Thread starter
- #4
If anyone can help, I'm looking for a bit of VBA code that I could launch with my table already open that would basicly:
Imbed an OLE Object with a picture (linked) who's address is available in a nebighoring cell of the table.
then go to the next record and loop... like 10000 times.
something like [pic] = [PicPath]
where [pic] is the colum where the OLE will be inserted, and [PicPath] is an address like (c:\pics\12345.bmp)
I need code that would tell the table to import the image as a linked OLE image, and from a spacific path in the same record of the table. I could import each pic manualy, but I think I could research this for 3 months and still save time on the deal. Anyway, VBA programmers, this ones for you.
Imbed an OLE Object with a picture (linked) who's address is available in a nebighoring cell of the table.
then go to the next record and loop... like 10000 times.
something like [pic] = [PicPath]
where [pic] is the colum where the OLE will be inserted, and [PicPath] is an address like (c:\pics\12345.bmp)
I need code that would tell the table to import the image as a linked OLE image, and from a spacific path in the same record of the table. I could import each pic manualy, but I think I could research this for 3 months and still save time on the deal. Anyway, VBA programmers, this ones for you.
-
1
- #5
TheAceMan1
Programmer
The above is certainly a gray area . . .perhaps if you expand on this our insight will be raised a few levels? ;-)DedCat said:
- Thread starter
- #6
I should start by saying that this db is used to search for "B-roll" clips in a video post production house. (b-roll is video that covers other video. ex. when you hear a news reportor talking about a fire, and you see footage of the fire, the fire footage is b-roll).
Basicly it works like this. I have one giant table. the user opens a form, which runs a query (on a key word like 'fire') and returns the results on yet another form. this 'results' form can return any number of records with a scroll bar on the side, and displays the clip name, a hyperlink to a quicktime version of the clip, and thumbnail pics of all hits.
I have determined that I have to use OLE image objects to get the pics to display on the form.
I have to use a form and not a report b/c the user will put a check in a 'keep' field next to the clips they want, and then run another search on a different key word.
all i really need to know, is there some way to get these photos into my giant table, without draging each one individualy into the table, i.e. can anyone tell me the VBA code that will allow me to do this.
I can easly add a field to my table with the address of each individual photo, for the purpose of pointing some repeting code loop to the correct photo for each record, I just don't know how to program VBA.
I hope that clears it up a bit. Thanks
Basicly it works like this. I have one giant table. the user opens a form, which runs a query (on a key word like 'fire') and returns the results on yet another form. this 'results' form can return any number of records with a scroll bar on the side, and displays the clip name, a hyperlink to a quicktime version of the clip, and thumbnail pics of all hits.
I have determined that I have to use OLE image objects to get the pics to display on the form.
I have to use a form and not a report b/c the user will put a check in a 'keep' field next to the clips they want, and then run another search on a different key word.
all i really need to know, is there some way to get these photos into my giant table, without draging each one individualy into the table, i.e. can anyone tell me the VBA code that will allow me to do this.
I can easly add a field to my table with the address of each individual photo, for the purpose of pointing some repeting code loop to the correct photo for each record, I just don't know how to program VBA.
I hope that clears it up a bit. Thanks
TheAceMan1
Programmer
DedCat . . .
Excellent info! . . . now if you could just give your definiton of a [blue]Hit![/blue] . . . I think I could pull this together.
Understand, its not so much that this is complex, its a matter of understanding things close to what [blue]you[/blue] see/want!
I understand your need to get away form OLE (forced by continuous form view). I belive you definition of hits will open the door . . . so be patient . . .
[blue]Your Thoughts?[/blue] . . . and I hope there's not a deadline involved here . . .
See Ya! . . . . . .
Excellent info! . . . now if you could just give your definiton of a [blue]Hit![/blue] . . . I think I could pull this together.
Understand, its not so much that this is complex, its a matter of understanding things close to what [blue]you[/blue] see/want!
I understand your need to get away form OLE (forced by continuous form view). I belive you definition of hits will open the door . . . so be patient . . .
[blue]Your Thoughts?[/blue] . . . and I hope there's not a deadline involved here . . .
- Thread starter
- #8
I Found several people with this same problem of trying to import many photos into thier tables. And most people agree that it is a bad idea b/c it causes bloat. It is important to note, that b/c many pictures have to be displayed on the same form, linking photos to an image command won't work. if you try, each image box displays the image linked to the record currently highlighted. It is therefore nessacary to add all pics to the table using an OLE.
In my db, i need to be able to quickly scan the pictures of all the records that were returned by my qury(or "Hits"). I also have links to low rez quicktime files to further invistigate weather or not I like the clip I have found. Those hyperlinks work great.
So I find myself manualy dragging in each pic onto my table. I have a total of 9721 records, and I've dragged in about 5800 of them. my db is now about 400 mb. It lives on a server of 1Tb. This is the same server that stores every full rez clip we use for b-roll that is not stored on tape, about 9721 of them, each about 350 mb.
I am trying to automate the proccess of getting the pics into the table. Thanks to all.
In my db, i need to be able to quickly scan the pictures of all the records that were returned by my qury(or "Hits"). I also have links to low rez quicktime files to further invistigate weather or not I like the clip I have found. Those hyperlinks work great.
So I find myself manualy dragging in each pic onto my table. I have a total of 9721 records, and I've dragged in about 5800 of them. my db is now about 400 mb. It lives on a server of 1Tb. This is the same server that stores every full rez clip we use for b-roll that is not stored on tape, about 9721 of them, each about 350 mb.
I am trying to automate the proccess of getting the pics into the table. Thanks to all.
TheAceMan1
Programmer
DedCat . . .
I knew I remembered something in my library . . . try here:
How to Load OLE Objects from a Folder into a Table
See Ya! . . . . . .
I knew I remembered something in my library . . . try here:
How to Load OLE Objects from a Folder into a Table
- Status
Similar threads
- Locked
- Question
