View Single Post
 
Old 08-12-2015, 07:24 PM
Guessed's Avatar
Guessed Guessed is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,990
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
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