Can I create sequential numbers for forms?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Twishlist - 18 Dec 2007 04:05 GMT

Need to create a Request for Information form where each request carries the
next number to the previous request. Is there a field by which I can link
to the number used in a previous document (then add 1). Or is there a better
way... Can anyone suggest a method that would be effective? And also offer a
link to the 'how to' page, if required.

Would greatly appreciate any assistance.

Reply to this Message

Jay Freedman - 18 Dec 2007 04:09 GMT

>Need to create a Request for Information form where each request carries the
>next number to the previous request. Is there a field by which I can link
[quoted text clipped - 3 lines]
>
>Would greatly appreciate any assistance.

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

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit.

Reply to this Message

Twishlist - 18 Dec 2007 23:14 GMT

Thanks for your prompt response. I copied the macro and followed the
instructions, replacing "order" with "rfi" (the name of my bookmark), & saved
the template accordingly...but nothing happened when I opened a new doc from
that template...have no previouse experience with VBA, so wondering whether
there was an additional step or something else I should have done.

> >Need to create a Request for Information form where each request carries the
> >next number to the previous request. Is there a field by which I can link
[quoted text clipped - 11 lines]
> Microsoft Word MVP FAQ: http://word.mvps.org
> Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit.

Reply to this Message

Jay Freedman - 19 Dec 2007 00:37 GMT

I'm wondering whether you put the macro in the right place. If not,
the macro may not be run when you make a new document.

Please read http://www.gmayor.com/installing_macro.htm to see whether
you followed the proper procedure.

>Thanks for your prompt response. I copied the macro and followed the
>instructions, replacing "order" with "rfi" (the name of my bookmark), & saved
[quoted text clipped - 11 lines]
>>
>> See http://www.word.mvps.org/FAQs/MacrosVBA/NumberDocs.htm

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit.

Reply to this Message

Twishlist - 29 Jan 2008 02:11 GMT

Thanks for your help, Jay. What I hadn't done was create a .txt file for the
macro to refer to. It now works beautifully.

> I'm wondering whether you put the macro in the right place. If not,
> the macro may not be run when you make a new document.
[quoted text clipped - 23 lines]
> Microsoft Word MVP FAQ: http://word.mvps.org
> Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit.

Reply to this Message