Thanks Shawn. I'll checkout the thingy Mike
"Shawn K. Hall" <[EMAIL PROTECTED]> wrote: Hi Mike, > I don't want (if possible) to have the user unprotect > the form to update the database and then remember to > NOT protect the form again. But if they do I want to > make sure the information is not lost. Is this > possible? I would suggest trapping Document_Close to force the "protect." In the 'ThisDocument' module click on the drop-down thingies at the top and play with them until you see this: Private Sub Document_Close() End Sub Then add your protection code inside. > Actually is it possible to do the above without messing > with the protect/unprotect stuff. That is, headquarters > reviews the form and makes changes (if necessary) and > then executes the database update macro. Depends on the controls you're using and what type of input they're doing. Generally, the best thing to do is leave it protected and have the code process the database stuff. If you show us your procesing code we can probably help you figure out why it's not working when the form is protected. Also, a much better place for Word coding help is the Word_VBA group: http://groups.yahoo.com/group/word_vba/ Regards, Shawn K. Hall http://ReliableAnswers.com/ '// ======================================================== "If you want more of something, subsidize it. If you want less of it, tax it." -- Jack Kemp '// ======================================================= Rules : http://ReliableAnswers.com/List/Rules.asp Home : http://groups.yahoo.com/group/vbHelp/ ======================================================= Post : [EMAIL PROTECTED] Join : [EMAIL PROTECTED] Leave : [EMAIL PROTECTED] '// ======================================================= Yahoo! Groups SponsorADVERTISEMENT --------------------------------- Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/vbhelp/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/k7folB/TM --------------------------------------------------------------------~-> '// ======================================================= Rules : http://ReliableAnswers.com/List/Rules.asp Home : http://groups.yahoo.com/group/vbHelp/ ======================================================= Post : [EMAIL PROTECTED] Join : [EMAIL PROTECTED] Leave : [EMAIL PROTECTED] '// ======================================================= Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/vbhelp/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
