Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Numbering / August 2006

Tip: Looking for answers? Try searching our database.

Increment Quote Number only when save as completes successfully

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Divercem - 15 Aug 2006 19:26 GMT
A small group of users want to create a form which increments the Quote
number only after they click a control button named cmdSaveQuote to avoid
losing Quote numbers if a user decides to cancel out of a quote.  It is a
responsibility 1-2 people will share, but only 1 person at a time will be
responsible for the quotes, so very little code needs to be in place to avoid
duplicate quote numbers

Unfortunately, I've only scratched the surface for macros and vbs coding.  
Any help would be greatfully appreciated.

Thanks in advance,

Charlie
Doug Robbins - Word MVP - 15 Aug 2006 20:52 GMT
Use a variation of the code in the article "Creating sequentially numbered
documents (such as invoices)" at:

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

In a macro named FileSaveAs
Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>A small group of users want to create a form which increments the Quote
> number only after they click a control button named cmdSaveQuote to avoid
[quoted text clipped - 10 lines]
>
> Charlie

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.