![]() |
|
|
Thread Tools | Display Modes |
#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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
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 |
![]() |
dflockyer | Word | 2 | 06-25-2012 05:24 PM |
![]() |
dbaldwin | Mail Merge | 3 | 04-22-2011 02:50 PM |