Ask for Password whe Yes/No Box is used

[kobiashi]

Hi

I am trying to create a digital signature function, not a complex, what i want to do is, when the user chooses his name, from a drop down box, then ticks a yes/no box, a popup box appears asking for the users password, when he enters his own password, it adds an image of his signature into another box.

Table 1
User_ID | UserName | Password | Signature


Form 1

Combo Box (Name Select)
Yes/No Box (tick to add signature)
Image box ( input signature here)

So when the user chooses his/her name in combo box, then ticks yes/no box, popup box appears asking for password, if entered password is correct, then signature image is applied to signature box.


I'm new to VBA so, i have no idea where to start with this function, any help would be most greatfully recieved

 

[bastanu]

Have a look at the attached sample. Please make sure you update the path to the signature file in the table (recommend storing paths to the files and not the images themselves in the table).

Cheers,
Vlad

 

[kobiashi]

thank you, thats awesome!!!

 

[kobiashi]

is there any way i can use attachments with this code, instead of storing the images in a folder?

 

[isladogs]

You might also be interested in the example files I uploaded here
https://www.access-programmers.co.uk/forums/showpost.php?p=1560092&postcount=14

I also do not recommend using attachment fields. Your database will rapidly become very large and performance will suffer.

 

[kobiashi]

You might also be interested in the example files I uploaded here
https://www.access-programmers.co.uk/forums/showpost.php?p=1560092&postcount=14

I also do not recommend using attachment fields. Your database will rapidly become very large and performance will suffer.

Thanks for the help, however waaayy beyond my skill level at access.


But if yo have any suggestions on handling images within an access database, i would be more than greatful for the help

 

[isladogs]

I posted the wrong link. It should have been an earlier one from the same thread.
https://www.access-programmers.co.uk/forums/showpost.php?p=1560062&postcount=4

If it's any use, you can just copy it to your own database.

As for storing images, save the image paths in your database, then set the control source for an image control to the saved path

 

[kobiashi]

thanks for the advice, but when it comes to access, im a novice, so im learning as i go, up until now, i have been storing images in an attachment, but as ive been reading, its not a good idea, and storing the file path is better, but as i dont know anything about that method, and im struggling to find anything, i assume my search criteria isnt right, and although i appreciate your help, i dont really understand the method.

 

[isladogs]

You have been given advice on handling images by two people in your other similar thread. No point adding further solutions here.

 

[Uncle Gizmo]

I'm struggling to find anything, i assume my search criteria isnt right ----

You are correct! It is difficult to search and find something without the correct search terms... However it's difficult to know what the correct search phrases should be until you've got experience so it's the typical chicken and egg situation.

You can utilise the excellent abilities of Google to search this very forum --- "AWF" (Access World Forums) This should help no end, because by restricting your search to be within AWF, then your results are going to be honed in on previous questions answered by experts.

I provide instructions in a YouTube video see "Searching For Answers" I also provide a ready-made URL to affect your search on my blog here:-

http://www.niftyaccess.com/vba-beginner/

Sent from my SM-G925F using Tapatalk

 

[Pat Hartman]

Just FYI, it may seem convenient to allow people to choose their userID from a list but security wise, it is better to have them type it. Having to come up with two pieces of data is more difficult for hackers than having to come up with only one.