Re: Number sequence
- From: "tina" <nospam@xxxxxxxxxxx>
- Date: Sat, 18 Aug 2007 18:20:37 GMT
looks like a custom function: GenNextSequence(). assuming that this is
where the number assignment is actually coming from, we'd need to see the
function procedure in order to make recommendations.
open your database, and open any module on the Modules tab. from the menu
bar, click Edit | Find. in the Find dialog, type "Function GenNextSequence("
only without the double quotes. in the Search section below, choose Current
Project, then click Find Next.
you should find the function procedure, which starts with the line you typed
in (Function may be preceded by Public), and ends with "End Function" -
again, sans quotes. copy the entire procedure from beginning to end, and
paste it into a post, so we can see it.
hth
"Mark G" <MarkG@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:585481AD-82D6-44E9-85B4-BE8570063882@xxxxxxxxxxxxxxxx
We have a field in one of our forms in our database that automaticallyis
generates a run number for fire calls in sequence. The format that we use
07-999. Everything was working fine until we hit what should have beensequence
07-1000. Now when it is supposed to assign the next number in the
it displays 07.0000. Any help would be greatly apreciated. I just dabbleis
with access and have no formal training which is more than the rest of the
department, and since I do I kind of inherited this database we are using.
This code is in a tab labeled "calculations" on a subform. I think this
what is telling the field what to do.transition
=GenNextSequence("daylog3","RUN#","05-0001"). I would like it to
from 07-999 to 07-1000 just as it did for the first 999 numbers.
Thanks
Mark
.
- Follow-Ups:
- Re: Number sequence
- From: Mark G
- Re: Number sequence
- Prev by Date: Re: Access Chinese?
- Next by Date: Multiple columns
- Previous by thread: Re: Fill out name fields if record exists
- Next by thread: Re: Number sequence
- Index(es):
Relevant Pages
|
Loading
