How can I insert digital signature on a report?

[BobC]

I am using Access 2007.
I have created a 1 page report in which I would like to be able to
insert digital signatures at various locations (text boxes).
I am thinking that I can use "OLE Objects" in a table to store the
signatures? (I am **not** familiar with using OLE objects however!)

I was hoping to use a combo box in the form that I use to create the
report such that I could select the appropriate signature to insert
into a text box.

I assume I could have a table that contained the digital signatures?

I could certainly use some guidance on how to do this!
Thanks!
Bob

 

[Tony Toews [MVP]]

I have created a 1 page report in which I would like to be able to
insert digital signatures at various locations (text boxes).

What kind of a file are these digital signatures? Are they jpg scans
of someone's hand written signature? If so use an image control and
some VBA code.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[BobC]

Tony,
I only have one at the moment(for test purposes), and it is a scan of
signature in bitmap format. I can convert them to most any format.
I just want to keep the process simple so it did not take special
training to create a report with signatures.
I had noticed that a MS ACCESS file could have fields of type 'OLE Object'.
Bob

 

[Tony Toews [MVP]]

I only have one at the moment(for test purposes), and it is a scan of
signature in bitmap format. I can convert them to most any format.
I just want to keep the process simple so it did not take special
training to create a report with signatures.

Using the Toolbox drop an image control on the reports detail section.
Note that you will have to follow the dialog and actually insert an
image. But then go to the Picture property on the Format tab in the
property sheet and delete the actual file. You will probably want to
set the Size Mode from clip to zoom. And rename the control.

Then in the report detail section in the On Print event you want to
add the following lines of code

If <logic if file available to view> Then
Me.PhotoImage.Picture = PhotoFilePath
Else
Me.PhotoImage.Picture = ""
End If

You don't want to do this logic in the Format event as Microsoft has
told us, via Stephen Lebans, that using that event can lead to memory
leak problems. Or use BMP images.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[BobC]

Tony,

Thanks for your help and also for taking the time to do so!
Question: What do you mean by the statement "Or use BMP images."
Are you saying that it is better to use BMP images?
Also, is there a place that I can do some reading on this topic without
you having to type it all out?

Thanks,
Bob

 

[Tony Toews [MVP]]

Thanks for your help and also for taking the time to do so!
Question: What do you mean by the statement "Or use BMP images."
Are you saying that it is better to use BMP images?

Very marginally. You can use the onFormat event but to avoid memory
leaks you have to use BMP files in that event. So you're better off
using the OnPrint event.

Also, is there a place that I can do some reading on this topic without
you having to type it all out?

For more info see the Image Handling Tips page at my website.
http:\\www.granite.ab.ca\access\imagehandling.htm

Besides I just found my previous posting on this topic and pasted in
place. <smile>

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[BobC]

Tony,

I'm going to try your recommendations tomorrow.
Thanks Again!

Bob