[AccessD] Unbound image on continuous form

My steamed colleagues,

In a semi-related issue.......I am having a problem creating an unbound 
object frame (thru code) on a report and setting the SourceDoc, etc more or 
less like this...(I am getting more and more bizarre in the way I am trying 
to inform the code about the control name...but it doesn't seem to make a 
diff) The code craps out on the .Action = acOLECreateLink - strRef contains 
a fully qualified path to a .Doc file which works fine if I use the 
Whizz-ard to create the control.

   rpt.Section(0).Controls("ss0").Class = "word.document.8"
   rpt.Section(0).Controls("ss0").OLETypeAllowed = acOLELinked
   rpt.Section(0).Controls("ss0").SourceDoc = strRef
   rpt.Section(0).Controls("ss0").Action = acOLECreateLink
   rpt.Section(0).Controls("ss0").SizeMode = acOLESizeZoom

the error is 2771 "the Bound or Unbound frame you are attempting to edit 
does not contain an OLE object"

Your thoughts?
_D
"Things are only free to the extent that you don't pay for them".-Don 
Elliker





>From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "Joshua B" <lists at jbsolutions.com.au>, <accessd at databaseadvisors.com>
>Subject: Re: [AccessD] Unbound image on continuous form
>Date: Wed, 06 Aug 2003 10:15:18 +1000
>
>On 6 Aug 2003 at 9:54, Joshua B wrote:
>
> > Hi Group
> >
> > I have a client who scans documents into their Access database (not
> > made by me). They have a continuous form set up which shows thumbnails
> > of these images (*.tifs stored in an OLE container). They came to me
> > because now, with 600-odd records, their database has (of course)
> > grown to 600meg. I have recommended storing the images on the system,
> > only storing the image name in the db, and inserting the image into an
> > unbound image holder on the fly. Only problem with this is, with
> > continuous forms this cannot be done. Has anyone come up with a
> > solution to this in the past? I've been thinking filtered recordsets
> > and temp tables storing current images, but was hoping there may be an
> > easier way I havent thought of. TIA.
> >
>
>You could try putting an  unbound image control in the header or
>footer  or  embed the continuous form in a parent form and put an
>unbound image control on the parent form. Then set the source of the
>image in the continuous form's on_current event.
>
>You can't see more than one image at a time that way, but you can
>scroll through them easily.
>
>Alternatively use a combined approach. Create small thumbnails images
>which are stored in the table with the full sized original stored on
>disk.
>
>
>--
>Lexacorp Ltd
>http://www.lexacorp.com.pg
>Information Technology Consultancy, Software Development,System
>Support.
>
>
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.  
http://join.msn.com/?page=features/virus