On 05 Oct 2003 Trevor Best <bouncer@localhost> wrote in
news:m6********************************@4ax.com:
On Sun, 05 Oct 2003 14:46:11 +0100 in comp.databases.ms-access,
Graham Drabble <gr************@lineone.net> wrote:
Sounds like a solution to what I'm trying to do at the moment.
Unfortunatly I can't open the db in that archive as it says it is
saved in a later version that what I'm using (2000). Would it be
possible for you to convert it back and then either put it on the
web again or e- mail it to me?
sure, no problem :-)
http://www.trevor.easynet.co.uk/down...Images2000.zip
I've just realised that I broke a report doing this. The paths are
for scans of signiturs that can be used on certificates. Not everyone
has a signiture scanned so it can be null.
What I've got is a report showing all the adults. As part of that I
want to show the signitures for those that had them. With the OLE
field that was easy, I simply used a Bound Object Frame. With this
method I can't do it.
The table is called 'leaders' and the field 'SignitureFile'. What
I've tried so far is to put a picture object (called 'pic') in the
report with (none) in the Picture attribute. I'm then going to set
pic.picture using OnOpen.
Private Sub Report_Open(Cancel As Integer)
pic.Picture = [SignitureFile]
End Sub
Gives the error
"Run error 2465
Can't find the field SignitureFile referred to in your expression
"
I also have a text box on the report called "SigFile" that has =IIf
([SignitureFile],[SignitureFile],"(none)") as a Control Source.
Private Sub Report_Open(Cancel As Integer)
pic.Picture = [SigFile]
End Sub
gives
"Run Time error 13
Type mismatch
"
and
Private Sub Report_Open(Cancel As Integer)
pic.Picture = "'" & [SigFile] & "'"
End Sub
gives
"Run time error 2427
You entered an expression that has no value"
Any suggestions as to the right way of doing this would be gratefully
accepted.
--
Graham Drabble
If you're interested in what goes on in other groups or want to find
an interesting group to read then check news.groups.reviews for what
others have to say or contribute a review for others to read.