S
Steve
Hi,
I have a table where we store excel or word docs in an OLE Object field. (We
get about 25 a year, so I'm not interested in the obvious response that you
shouldn't store docs in access because of limited size... we do not have an
issue with that! ;-) ).
The documents are stored fine, but I have an issue with them when I work
with the data in the docs table on a Form. Very quickly, what I want to do is
to display the document as an icon - so similar to being in Word and
embedding a document and telling Word to show it as an icon.
When I drop a field for the OLE Object field onto the form, I can size the
field on the form as I can any other text box or label etc and edit it's
properties so that I set the [Display Type] property of the object on the
form to be an Icon.
Regardless of whether I set the Display Type as an Icon or not, when I load
the form the object decides it'll stuff the developper (me) & display the
Contents of the document instead = ARGH ONE! I cannot get round this.
Secondly, when it's set to show display type as Content the content isn't
just shown in the sized object I've placed on the form. (Tell a lie, it does
the first time the form is loaded but on all subsequent times I load it it
covers the area mentioned next). Instead it covers the entire space from the
top left of the object to the bottom right of the form = ARGH TWO!!
I'm using Access 2003 SP3. Is this something I can get round or is it a bug
in Access 03?
Any help much appreciated as always!!
Regards,
Steve D
I have a table where we store excel or word docs in an OLE Object field. (We
get about 25 a year, so I'm not interested in the obvious response that you
shouldn't store docs in access because of limited size... we do not have an
issue with that! ;-) ).
The documents are stored fine, but I have an issue with them when I work
with the data in the docs table on a Form. Very quickly, what I want to do is
to display the document as an icon - so similar to being in Word and
embedding a document and telling Word to show it as an icon.
When I drop a field for the OLE Object field onto the form, I can size the
field on the form as I can any other text box or label etc and edit it's
properties so that I set the [Display Type] property of the object on the
form to be an Icon.
Regardless of whether I set the Display Type as an Icon or not, when I load
the form the object decides it'll stuff the developper (me) & display the
Contents of the document instead = ARGH ONE! I cannot get round this.
Secondly, when it's set to show display type as Content the content isn't
just shown in the sized object I've placed on the form. (Tell a lie, it does
the first time the form is loaded but on all subsequent times I load it it
covers the area mentioned next). Instead it covers the entire space from the
top left of the object to the bottom right of the form = ARGH TWO!!
I'm using Access 2003 SP3. Is this something I can get round or is it a bug
in Access 03?
Any help much appreciated as always!!
Regards,
Steve D