Re: Pop Up Form To Show Next Number

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Depending on how many, it might be (?considerably?) faster to just
"manually" add those sequence numbers directly in that table. After all, it
IS a one-time need, right?

Regards

Jeff Boyce
Microsoft Office/Access MVP


"hobbit2612 via AccessMonster.com" <u27332@uwe> wrote in message
news:99830cc049669@xxxxxx
Bruce,

You have fair comment, it isn't usual to assign a new record to a lower
value.
But it's something that I really need to try and do.

Many thanks and regards

Chris

BruceM wrote:
My wondering was because if the numbers are arbitrary references the
actual
values don't matter, and if they are sequential it is not usual to assign
a
new record a value lower than an older record.

Hi Bruce thanks for getting back to me.

[quoted text clipped - 19 lines]

Chris

--
Message posted via http://www.accessmonster.com



.

Relevant Pages

  • Re: Design qq
    ... in sequence, it doesn't really matter, and depending on the size of ... question is to answer outright. ...
    (comp.lang.java.help)
  • Re: Count/Sum data with date entries.
    ... If I go back to my original posting & question, I'm trying to go down 3 ... columns and depending on the sequence of dates entered, ... KBW's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=32730 ...
    (microsoft.public.excel.worksheet.functions)
  • Re: PHP mt_srand no longer seeds same number!!!!! aaarrrg
    ... Your problem is you are depending on the ability to repeat a sequence. ... If you need to be able to repeat the sequence, I would suggest you write your own pseudo-random number generator. ...
    (comp.lang.php)
  • Re: J4 - presentation/discussion on "Future of the COBOL Standard"
    ... I believe that OCCURS DEPENDING ON is useful for tables that can have ... a variable number of entries and are in sequence for searching using ... I suspect the savings you might think is there is illusory. ...
    (comp.lang.cobol)
  • Re: Dating with DNA? Problems and Current Approaches
    ... Adcock et al did a sequence of LM3 and claimed it was as divergent from humans as Neandertals. ... The core eastern/east african mtDNA sequence is present in LM3 sequence but many other substitutions are present. ... published it did nothing more than assume a rate of mutation. ... We so commonly use the word generation but there are several different lengths for it depending upon the context in which it is used. ...
    (sci.archaeology)