How do I sort records in Runtime ?????

[deaconj999]

Hi All,

I have designed a database that pulls records of fire inspections and
frequencies. When you add a new record to it in Access 2003 it sorts
the records in order by location.


However when used on Runtime it performs differently. Lets say you
already have records on it for location A B and C and they are in
that
order i.e 6 records for location A 4 for B, 7 for C


A A A A A A B B B B C C C C C C C


they would be sorted like the above as you search through them,


If you added 2 records for A they Would slot in Nicley when you
scroll
through them


A A A A A A A A B B B B C C C C C C C


BUt in Runtime they would be placed


A A A A A A B B B B C C C C C C C A A


Why Is this, How DO I get around it more inportantly and Ive noticed
that runtime hasn't got the same toolbars as the full Version of
Access.


Iis it Possible to create a button on my form to sort the records in
order, so that when you scroll through them the additional entries
are
slotted in by location.


Please Please Help


Joe

 

[Ken Snell \(MVP\)]

Runtime sorts the same way full ACCESS does -- but you cannot depend upon a
sort order unless you use a query that imposes an ORDER BY clause on the
data so that you get the sort order that you want.

Runtime does not provide access to any toolbars or menus that would allow
you to create/edit/modify the design of any object in the database. It's
strictly for use as a way for users to see and enter/modify data using forms
and reports that you programmed into the database.