R
roger
I just read, but did not really understand "How To Read and Write BLOBs Using
GetChunk and AppendChunk" in the KB.
I have several (thousands) of little PNG incons.I need to display them in
continous forms, so I'm using a OLE field. I have working sub that imports
the PNGs though a bound OLD control, one at a time, through the GUI. But its
way too slow.
currently these two lines import the PNG:
Me.LibItemIconOLE.SourceDoc = Me.LibItemPNGFilePath
Me.LibItemIconOLE.Action = acOLECreateLink
Then it loops though each record in the table.
I have an earlier function the steps though each record in ADO. (the one
that sets LibItemPNGFilePath) If I could import the PNG then, I would save a
lot of time.
The probelm is that in "How To Read and Write BLOBs Using GetChunk and
AppendChunk" they give several conflicting examples, all involvling photos
that are in some ".DAT" format (which i've never heard of) and it sez
somthing about all the photos have to be exact same size, and mine are not.
Is a BLOB even what I'm looking for?
I've also read somthing about having to "package" an OLE item, with info
about what app reads the data. And I no idea how to do that, and even less
about how to do that for a PNG.
If someone could point me to some example code that is more specific to my
situation, that would really help.
aha tia roger
GetChunk and AppendChunk" in the KB.
I have several (thousands) of little PNG incons.I need to display them in
continous forms, so I'm using a OLE field. I have working sub that imports
the PNGs though a bound OLD control, one at a time, through the GUI. But its
way too slow.
currently these two lines import the PNG:
Me.LibItemIconOLE.SourceDoc = Me.LibItemPNGFilePath
Me.LibItemIconOLE.Action = acOLECreateLink
Then it loops though each record in the table.
I have an earlier function the steps though each record in ADO. (the one
that sets LibItemPNGFilePath) If I could import the PNG then, I would save a
lot of time.
The probelm is that in "How To Read and Write BLOBs Using GetChunk and
AppendChunk" they give several conflicting examples, all involvling photos
that are in some ".DAT" format (which i've never heard of) and it sez
somthing about all the photos have to be exact same size, and mine are not.
Is a BLOB even what I'm looking for?
I've also read somthing about having to "package" an OLE item, with info
about what app reads the data. And I no idea how to do that, and even less
about how to do that for a PNG.
If someone could point me to some example code that is more specific to my
situation, that would really help.
aha tia roger