Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-12-2015, 12:00 PM
kawtharz kawtharz is offline how to create a box in word document that takes a password to open an access field Windows 7 32bit how to create a box in word document that takes a password to open an access field Office 2013
Novice
how to create a box in word document that takes a password to open an access field
 
Join Date: Aug 2015
Posts: 3
kawtharz is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 08-12-2015, 07:24 PM
Guessed's Avatar
Guessed Guessed is offline how to create a box in word document that takes a password to open an access field Windows 7 32bit how to create a box in word document that takes a password to open an access field Office 2010 32bit
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 2,434
Guessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to behold
Default

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
Reply With Quote
  #3  
Old 08-13-2015, 12:43 AM
kawtharz kawtharz is offline how to create a box in word document that takes a password to open an access field Windows 7 32bit how to create a box in word document that takes a password to open an access field Office 2013
Novice
how to create a box in word document that takes a password to open an access field
 
Join Date: Aug 2015
Posts: 3
kawtharz is on a distinguished road
Default

Hi, thank you for your answer

Quote:
Originally Posted by Guessed View Post
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")
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.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to create a box in word document that takes a password to open an access field 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
how to create a box in word document that takes a password to open an access field MS WORD takes forever to open .. dflockyer Word 2 06-25-2012 05:24 PM
how to create a box in word document that takes a password to open an access field Access password blocking Word mail merge dbaldwin Mail Merge 3 04-22-2011 02:50 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 07:41 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft