Re: Record Sequence

Why? What difference does it make in what order they're saved?

All you really should care about is that you can retrieve them in alphabetic
order when you need to refer to them. To do that, create a query with an
appropriate ORDER BY clause, and use the query wherever you would otherwise
have used the table.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Shar" <Shar@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9216538C-A3D5-4691-9EE5-66199D430F43@xxxxxxxxxxxxxxxx
I am trying to figure out if there is a way to keep records in alphabetical
order during record entry in a database form? If a person adds a new
record
or several new records, I would like those records to be saved in
alphabetical order. Is that possible?
--
Thanks, Shar


.

Relevant Pages

  • Re: On ADSI and LDAP
    ... the problem is how can I retrieve the value for myuser using the ... would be more efficient to use ADO to query AD for the attributes values. ... For more on using ADO, ... Dim adoCommand, adoConnection, strBase, strFilter, strAttributes ...
    (microsoft.public.scripting.vbscript)
  • Re: Internet class differences...
    ... The database and web interface to the server is produced by a different ... Initially a WebClient class was used. ... This worked fine for submitting the query. ... retrieve the results but, instead, is sent to a login page from which it ...
    (microsoft.public.dotnet.general)
  • Re: Column Order Problem
    ... I understand the reasons for not using the BLOB data types but as I ... >> I'm working on required extending an existing query to retrieve some ... The query is written correctly and returns the ...
    (microsoft.public.data.ado)
  • Re: Returning only a subset of groups in AD
    ... Output.WriteLine "There are no members in this group." ... I assume that ADSICommand is an ADO command object, ... value assigned to the CommandText property, which is the ADO query. ... ' Comma delimited list of attribute values to retrieve. ...
    (microsoft.public.scripting.vbscript)
  • Re: Record source at runtime
    ... Clause, but is in the data requested, so it will return the PKs ... retrieve indexes for Lastname and Firstname. ... had I written the query: ...
    (microsoft.public.access.formscoding)