[AccessD] One Question (Was Two Questions)

I suppose one way would be to create a table of missing numbers then use
this to assign next numbers. Not elegant but it sounds like elegance is not
a word one would associate with this spreadsheet. :-) You could create a
table in Access with all the numbers from 1-100,000. Create a table from the
spreadsheet with the existing numbers. Then create a "find unmatched query"
which will  show the numbers in the large table not present in the existing
table. Use this query to create a table of the missing numbers.
Jim Hale

-----Original Message-----
From: karenr7 at oz.net [mailto:karenr7 at oz.net]
Sent: Wednesday, June 14, 2006 11:29 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] One Question (Was Two Questions)


Yes, that's what has to happen. These dictation codes used to be kept in a
big notebook. Then a spreadsheet was started. But the old numbers are in
use, just not on the spreadsheet. They started numbering at 8000, went to
99999 and then started back at 1. So I want to "fill in the holes" going
forward, but there are odd outlyers, not to mention wholes in the past.

Yuck.

Regards,
Karen Rosenstiel
Seattle WA USA

> Karen:
>
> Why do you need to 'fill in the holes'.  Why not just carry on from the
> last number.  Going forward there won't be any holes to fill.
>
> Rocky
>
>
> Karen Rosenstiel wrote:
>> OK, so with your collective help, this thing is coming along.
>>
>> I want to sort the dictation passwords (a unique 5 digit number)with the
>> highest number on top so that when adding a new dictating provider to
>> the
>> database, I can see what the next highest new number should be.
>> Unfortunately, I inherited this really crappy Excel spreadsheet and
>> there's
>> a bunch of codes out of sequence. I think that people were just being
>> lazy
>> and giving a random high number  to incoming requests because they
>> didn't
>> feel like looking something up. So I can't just have some code to pick
>> the
>> highest number, because it would be out of sequence.
>>
>> Now I've got an unbound text box with the following code:
>>
>> SELECT tStaff.StaffID, [LanierID] & " -- " & [LastName] &
>> IIf(IsNull([FirstName]),"",", " & [FirstName]) AS Lanier FROM tStaff
>> ORDER
>> BY [LanierID] DESC;
>>
>> I think the answer is probably going to be no, but... Is there a way I
>> can
>> mark in the unbound box when the numbers go out of sequence.
>>
>> In other words:
>>
>> 13888
>> -------------------> Is there some way to put a line here or different
>> colored text or some kind of marker
>> so that the users can can see at a glance what the next highest
>> sequential
>> number shuld be?
>> 12347
>> 12346
>> 12345
>>
>> Any ideas?
>>
>> Regards,
>>
>> Karen Rosenstiel
>> Seattle WA USA
>>
>>
>>
>>
>
> --
> Rocky Smolin
> Beach Access Software
> 858-259-4334
> www.e-z-mrp.com
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

***********************************************************************
The information transmitted is intended solely for the individual or
entity to which it is addressed and may contain confidential and/or
privileged material. Any review, retransmission, dissemination or
other use of or taking action in reliance upon this information by
persons or entities other than the intended recipient is prohibited.
If you have received this email in error please contact the sender and
delete the material from any computer. As a recipient of this email,
you are responsible for screening its contents and the contents of any
attachments for the presence of viruses. No liability is accepted for
any damages caused by any virus transmitted by this email.