|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how to create a box in word document that takes a password to open an access field
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.
|
#2
|
||||
|
||||
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 |
#3
|
|||
|
|||
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. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to Open a Word Document from ACCESS VBA | PosseJohn | Word VBA | 3 | 12-06-2013 04:33 PM |
Password protected file no longer offers password dialog on Open | htaylor | Word | 0 | 10-15-2013 12:35 PM |
How to open a password-protected word document? | navalava | Word | 1 | 07-01-2012 12:15 PM |
MS WORD takes forever to open .. | dflockyer | Word | 2 | 06-25-2012 05:24 PM |
Access password blocking Word mail merge | dbaldwin | Mail Merge | 3 | 04-22-2011 02:50 PM |