Re: Do not want data to auto sort

Tables do not reliably sort data. You should not be using the tables as an
interface anyway, so you should not even know if the data is sorted or not.
Tables are buckets for storing records. Forms, queries, and reports are
user interfaces. You should be working with these items.

Now, the data in those items must be sorted some how. You will have to pick
a field in your data by which to sort. Record Number is not available for
sorting. If the order in which you enter data is important, then make sure
you have a sequential field upon which you can sort. In this case, an
autonumber field would probably work since it will increment each time a
record is added. BUT, there will be gaps in this number from time to time,
so don't expect it to look nice and contain no gaps.

--
Rick B



"Rod" <Rod@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:61261D06-FA00-455C-B537-12ECB4CE2786@xxxxxxxxxxxxxxxx
> When I enter data in a table I expect the last record entered to be the
last
> recoed in the table. Access appears to be rearranging my records. How
can I
> stop this rearranging me my records so I see them in the list as I input
them?


.

Relevant Pages

  • Re: implementing roles in OOP......
    ... everything should be driven by abstracting the problem ... my draft interfaces define what sort of thing I would ... All I need is the Composite relationships to navigate, ... IEnumerator is an interface defined by my environment, we can put, ...
    (comp.object)
  • Re: LW9 running FIXED. hub problem found (i think)
    ... Well, this was all good news, sort of LOL ... I know its capable of some REALLY cool imagery, but why such an utterly goddam amateur interface? ... As for this part, I had to bust out laughing, as this was just too funny LOL ... I was able to start creating cool and FUN scenes pretty much right out of the shoot! ...
    (comp.graphics.apps.lightwave)
  • Re: IInterfaceList and Sort
    ... Unfortunately there is no Sort method. ... {descend from this interface for specific uses ... localCompare:=.asInteger; ... TQuickSort = class(TInterfacedObject, ISorter) ...
    (borland.public.delphi.language.objectpascal)
  • Re: Fast D/A ?
    ... I'm after sorting out a toy 'scope of some sort ... I am wondering about maybe building at least part of my own interface, ... You may find it a lot simpler to build a convert and store unit, with a fairly simple interface for transferring the stored data to the PC. ... The "homebuilt computer" part of the project then becomes fairly trivial, as the transfer is neither real-time, nor timing-critical. ...
    (uk.comp.homebuilt)
  • Re: Nemethis Tablelist widget vs. Hobbs Tktable widget
    ... > An Cobol man would say - if I must be quickly I sort using ... >> Csaba's Tablelist widget, and I'm looking for some feedback from ... concentrate more on interface specification then interface users can ... encapsulates a certain functionality. ...
    (comp.lang.tcl)
Loading