Show signature on report

[injanib via AccessMonster.com]

I have a form that has two unbound fields besides all the other fields.

The unbound fileds are txtName and oleSignature. The oleSignature field is an
unbound image field.

I have scanned and saved some signatures in a directory on my local drive.
What I would like to do is that once I select a name from the txtName field,
based on the name the oleSignature field display the signature corresponding
to that name. I don't want any of these signatures to be saved anywhere in my
database to avoid increasing the size of it.
What I do like is to be able to show the signatures on the report when it is
printed.

Thanks in advance.

 

[fredg]

I have a form that has two unbound fields besides all the other fields.

The unbound fileds are txtName and oleSignature. The oleSignature field is an
unbound image field.

I have scanned and saved some signatures in a directory on my local drive.
What I would like to do is that once I select a name from the txtName field,
based on the name the oleSignature field display the signature corresponding
to that name. I don't want any of these signatures to be saved anywhere in my
database to avoid increasing the size of it.
What I do like is to be able to show the signatures on the report when it is
printed.

Thanks in advance.

No oleSignature field needed.
And why is txtName unbound?

Store each signature image in a file outside of the database.
The file should be stored as a .bmp or a .jpg image (same as though it
was a picture of Aunt Tillie).

Name each signature with the name of the signer, including the .jpg or
..bmp extention, i.e. BJSmith.jpg.

Then all you need do is store the name of the signer, i.e. "BJSmith",
in the txtName field in your database table.

Add an Image control to the report.
You will need to set the Image control's Picture property to ANY
picture.
After saving the image control, reopen the report in design view and
delete the Image's Picture property. You will be prompted. Say OK.
Save the change. The Images picture property line should read "none".

Code the Report's Detail Format event (assuming the signature is in
the detail section):

Me.ImageName.Picture = "c:\MySignatureFolder\" & txtName & ".jpg"

 

[injanib via AccessMonster.com]

Thanks for your quick response.
Just a few more notes. Is it possible to have the image control on the form
and have it show on the report later? because this is how it works. The form
is to create invoices. Once an invoice is created, it is signed by one of
three people. Then a button is pressed to filter for the current record and
print to a pdf format. This pdf file is then attached to an email.
The txtName field can be bound. I dont want to have to open the report and do
anything more with it. I only want to print it with everything already on it.

I have a form that has two unbound fields besides all the other fields.

[quoted text clipped - 10 lines]

Thanks in advance.

No oleSignature field needed.
And why is txtName unbound?

Store each signature image in a file outside of the database.
The file should be stored as a .bmp or a .jpg image (same as though it
was a picture of Aunt Tillie).

Name each signature with the name of the signer, including the .jpg or
.bmp extention, i.e. BJSmith.jpg.

Then all you need do is store the name of the signer, i.e. "BJSmith",
in the txtName field in your database table.

Add an Image control to the report.
You will need to set the Image control's Picture property to ANY
picture.
After saving the image control, reopen the report in design view and
delete the Image's Picture property. You will be prompted. Say OK.
Save the change. The Images picture property line should read "none".

Code the Report's Detail Format event (assuming the signature is in
the detail section):

Me.ImageName.Picture = "c:\MySignatureFolder\" & txtName & ".jpg"