Gasman
Enthusiastic Amateur
- Local time
- Today, 15:23
- Joined
- Sep 21, 2011
- Messages
- 17,082
No, it is just my Access is so old.Are you getting an error? What version of Access are you using? Thanks!

No, it is just my Access is so old.Are you getting an error? What version of Access are you using? Thanks!
Oh, I see it now in your sig: 2007No, it is just my Access is so old.It happens a lot to me. I always get unrecognised DB format.
Hi. Just curious, could you please test this out for me and let me know if you see the same problem? Thanks!
Hi. Thanks for trying. Hope it helps with your current project. Please let me know if you have any questions about using it. Good luck!Hi Dbguy,
The left hand side "display signature using an image file" the signature box is blank.
On the right it works, the one using an attachment field.
Also, im not actually able to sign anything....
Edit :
I can, it seems to work, just needed to make sure it was in a trusted folder , my bad !
@isladogs Hi Colin. I don't have a "retrieve" button on my demo because I automatically display the saved signature using the Form's Current event. So, in effect, I also have a "retrieve" functionality in my demo, but it's sort of automatic - no need to click a button.@theDBguy
Both your app and mine work perfectly for creating and saving a signature
The error that @ahmed_optom mentioned was with code used to retrieve a saved signature file.
No idea yet why that's now an issue (but only after the first time it is clicked)
As far as I can tell, you don't have an equivalent of that functionality in your example app.
Can you confirm whether that is the case.
@ahmed_optom
I thought you wanted to draw on a form. Did you actually want to save signatures?
@theDBguy
Both your app and mine work perfectly for creating and saving a signature
The error that @ahmed_optom mentioned was with code used to retrieve a saved signature file.
No idea yet why that's now an issue (but only after the first time it is clicked)
As far as I can tell, you don't have an equivalent of that functionality in your example app.
Can you confirm whether that is the case.
@ahmed_optom
I thought you wanted to draw on a form. Did you actually want to save signatures?
Hi. I do think you may be over thinking it, because the file is created and deleted in a split second. The chances of someone intercepting it would be very small. Besides, who do you think will try to "steal" the signature? Remember, anyone with access to the table's data, can take a copy of the signature data or the whole thing. If you're really concerned about the image file being stolen in that very narrow window of time, then perhaps you can change the code to create the image file in a network location that no one knows. Hope that helps...Yes, I just wanted to save signatures. Which I think I have a good implementation now thanks to this thread.
The method of "retrieving" in DBGuy's example is outputting the file and then loading that image the control.
The issue I have with DBguys method, is potentially losing control of the file, eg whilst the form is open someone in theory could copy the image file. I may be over thinking it, but Im just working on a way today to try and bypass the output of the file, so there is no possibility of someone "taking" the signature.
Hi. My demo converts the signature (ink image) into gif and converts it back to display in an ink control. If you use a gif image for your background, or convert it to a gif, then maybe you can try my demo.Does anyone know how to load a background picture, and then have the ability to "draw" on it?
Im thinking of using the inkpicture control, I can set it up to catch the drawing, but I cant seem to load a background image , any ideas?
thanks in advance
Hi. My demo converts the signature (ink image) into gif and converts it back to display in an ink control. If you use a gif image for your background, or convert it to a gif, then maybe you can try my demo.
Hi. In that case, maybe Colin's Load method could work for you. Have you tried it?Hi Db guy,
Hope your well.
The issue is that your displaying the ink picture in an image control. This I can do. But I want to display the picture in an inkpicture control, and then I can draw ontop of the picture. This is the problem.
I cant see to find a inkpicture.backgroundpicture type of property that will let me set it and then i can draw on top.
yes, I have been playing with it for hours. His method now also rte. I believe something in access or vba changed over the years that means the code is no longer correct.Hi. In that case, maybe Colin's Load method could work for you. Have you tried it?