Creating a Signature field in Staff Table

[Mr2006]

I have a staff_tbl that I would like to add field in it with everyone's electronic Signatures for later use when they need to print the Signature in the report. I will scan everyone's Signature in a secure folder. I want to be able to select the name from the combobox and the Signature will be placed in the report.

Do you have any idea how to proceed with this.

 

[HarleyQuinn]

Put the path to the signature in a text field, return that when the name is selected and use the path to populate your control with the signature.

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[Mr2006]

Yes, this helps little Since I am not sure how this will work. So in my Staff_tbl, I will have the staffname(Text),StaffID (AutoNumber), Staffsignature (Text). All signitures are scanned as Mr2006.bmp and saved in a secure folder. how will I create the path in the table to open the file and it will pull the signature to the report. Sorry I am not an expert.

 

[HarleyQuinn]

It's totally up to you how you get the path to the .bmp into your table.

Once you have the path in the table, you can put an image on your form and on change of your combobox you would set the images .Picture property to the path of the image corresponding to the selection in the combo, maybe using a DLOOKUP perhaps.

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[Mr2006]

Is there a way that I put a code and the signature just print in the report?