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 / General MS InfoPath Questions / December 2005

Tip: Looking for answers? Try searching our database.

AUTONUMBERING IN INFOPATH

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Gene Griffe - 23 Sep 2004 18:19 GMT
I have created our Purchase Request from in InfoPath and need to have the
Requisition Number be automatically generated each time the form is opened.  
Is there an easier way than creating a database just for the Requisition
Number?  Any assistance would be greatly appreciated.

Gene
Josh Bertsch [MSFT] - 23 Sep 2004 18:58 GMT
Without the number being generated from a web service or a database, the
number isn't guarenteed to be unique.  You can probably come close, but it
won't be guarenteed.

If you aren't requring uniqueness, there are a number of ways to generate
almost random numbers.  However, there is no real way within the bounds of
the current form to create an incrementing number.  For that you would have
to, as you say, use a database or a web service.

--josh bertsch

> I have created our Purchase Request from in InfoPath and need to have the
> Requisition Number be automatically generated each time the form is opened.
> Is there an easier way than creating a database just for the Requisition
> Number?  Any assistance would be greatly appreciated.
>
> Gene
Jerry Thomas [MSFT] - 23 Sep 2004 22:43 GMT
Another way to have the number generated, but not sequential, is to use a
combination of date and time and employee ID. (Employee initials might be
duplicated)

If you need sequential, you don't have to use a database. You can accomplish
this with just a seperate XML form that only has the counter. Using code,
you can get the value and then increment it each time. This is a lot more
involved as you have to code retries if the file is locked.

Signature

Jerry Thomas[MSFT]
<Jerryth@online.microsoft.com>
Microsoft Office InfoPath
---------------------------------------
This posting is provided "As Is" with no warranties, and confers no rights.
Use of any included script sample are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
Please do not send email directly to this alias.  This alias is for
newsgroup purposes only.

> I have created our Purchase Request from in InfoPath and need to have the
> Requisition Number be automatically generated each time the form is opened.
> Is there an easier way than creating a database just for the Requisition
> Number?  Any assistance would be greatly appreciated.
>
> Gene
NikV - 22 Dec 2005 18:31 GMT
Jerry;
I am interested in generating a number using the time, date as you indicated
in your previous response to this question.  How would you accomplish this?  
By coding?  If coding is use, please explain in VB.  Thanks!

> Another way to have the number generated, but not sequential, is to use a
> combination of date and time and employee ID. (Employee initials might be
[quoted text clipped - 12 lines]
> >
> > Gene
 
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.