Re: Setting AutoNumber back

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

From: Jeff Boyce (JeffBoyce_IF_at_msn.com-DISCARD_HYPHEN_TO_END)
Date: 02/13/04 

Date: Thu, 12 Feb 2004 17:41:50 -0800

Ed

I'll assume to interpret Tim's reply -- you DON'T use Autonumber to count
the records (that's what queries are for). And you don't use the Navigation
information to sequence/count (that's what queries are for). And you don't
want to use Autonumbers as anything other than a "behind the curtain" row
identifier (if you believe the general consensus of this newsgroup). 

-- 
Good luck
Jeff Boyce
<Access MVP>

Relevant Pages

  • Re: Query multiples values
    ... Not sure why your queries didn't work. ... Transaction ID - Autonumber ... To Suburb - Text (uses cbo from tblPostcode) ... >> TblTransactions ...
    (microsoft.public.access.queries)
  • RE: Multiple Table Query
    ... Because these are make-table queries it deletes the existing ... table before running the query (Iwould like to reuse these queries in case it ... happens again) so each time it inherits the autonumber property. ... > and just deleted all records where there is no match in the Frame table. ...
    (microsoft.public.access.queries)
  • RE: Links in Query results
    ... Queries do not have events which would open another table. ... You might be able to make it happen with a form in datasheet view using the ... each with an autonumber field. ...
    (microsoft.public.access.queries)
  • Re: Links in Query results
    ... Queries, as far as I know, don't "drill down". ... Jeff Boyce ... Microsoft Access MVP ... each with an autonumber field. ...
    (microsoft.public.access.queries)
  • Re: a union is always a join!
    ... Queries are interpreted exactly the same as always. ... resulting relation was produced before we can interpret it. ... you could allow non-query expressions but not queries in NOT ... Expressions that cannot be recast using MINUS and UNION instead of NOT ...
    (comp.databases.theory)