Solved Is it possible to fetch a pic of signature in a report. And can be changed through a table/query or any other means.

[sbaud2003]

Actually I want tp print a report under the signature of some officials. But if the officer get transfered to other section of duty, other officer will take charge.

 

[The_Doc_Man]

Without discussing any of the implied legality or propriety, I'll answer the technicality.

Assuming the printer is capable and assuming that you have a file with the person's actual signature, the file specification of the file containing the image of that signature can be loaded to an image control. This will work for a form or a report.

Image.Picture property (Access)

Office VBA reference topic

learn.microsoft.com

 

[arnelgp]

you can put the signature (image) in an Attachment field.
see Form1 on this demo.

 

[sbaud2003]

you can put the signature (image) in an Attachment field.
see Form1 on this demo.

That is functioning, but what, if report is connectec with another table

 

[ebs17]

You could include the signature in the report via a subreport. You can load the content of the subreport depending on the case.

 

[arnelgp]

you can put in sub-report and you can also put it in the query, together with your table.
since it will only return 1 record (one signature), it will not create extra records.

 

[GPGeorge]

That is functioning, but what, if report is connectec with another table

"... what, if report is connectec with another table..."

Why would a report connect to different tables? It seems to me that there's more to this than has been discussed so far.

 

[sbaud2003]

you can put in sub-report and you can also put it in the query, together with your table.
since it will only return 1 record (one signature), it will not create extra records.

Thank you so much sir, No words to express. I am obliged as you understand my problem exectly, what I am facing.