Calculate sequential number in a protected form.

[gtc@idl]

I have a protected form that users will fill in fields and then save it under
a new name. This form replaces a 7 part carbon form that is sequentially
numbered.
I am looking for information on how to have the form open with the next
number each time it is accessed. Any help would be greatly appreciated.

 

[Jay Freedman]

See http://www.word.mvps.org/FAQs/MacrosVBA/NumberDocs.htm.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[Graham Mayor]

See also http://www.gmayor.com/automatic_numbering_documents.htm. The macros
may be used as presented with a protected form, if saved in the form
template and new documents are created from it. You will need to add a
toolbar/qat buttons to the template to run the SaveCertificateAs and
ResetStartNo macros and add your form password to the line
Const sPassword As String = "" 'The password to edit the form
and set any leading text before the number in the line

Const sText As String = "Certificate No. "

If you want to change the save name and save path then do so at



..Name = "Certificate " _
& Format(oVars("varSaveNo"), _
sFormat)
..Show

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>