Hi fellow programmers, I am completing a college subject project where they want to add a signature to the document using VBA and they don't want to use a digital certificate from a third party! they want me to add the signature myself using VBA and retrieve it from an access database. moreover my supervisor wants me to insert a password box inside the document to take a password to start this procedure. I am not even sure that this is possible.. can you help me with this.. ? thanks a lot.

A password box is simple enough. If you want to display this as a dialog then you can use something along the lines of
Dim sPass as String
sPass = InputBox("Give me your password")

To get a graphic out of Access you might explore using a mailmerge field although that is possibly not in the spirit of the assignment. The best source I ever used for learning VBA automation of other office programs was the code samples provided by Helen Fedemma which can still be found here http://www.helenfeddema.com/Code%20Samples.htm
Those code samples may be old but if you pick over those bones you should learn enough to complete your assignment and perhaps ask more focused questions to get over any hurdles you may encounter.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

Hi, thank you for your answer

how is it effectively used? Because I used these two lines,and it made a window pops up every time i click anywhere in the document. but I don't really have any clue how I could use it properly. I really appreciate your help. I am really a beginner in VBA.