Dates are shuffled

  • Thread starter Thread starter C Tate
  • Start date Start date
C

C Tate

I work with a large and rather complex database which is used by a number of
organisations. I didn't make it and some its workings are a mystery to me.
Sometimes very odd things happen. For example, there are a number of
different 'forms' in it. One of them requires the user to enter various bits
of information starting with a date. Many records will be entered and the
user can scroll back and forth between them using the standard scroll bar
with the arrows etc.

Normally all the records are in date order but some users (not all)
experience a situation where all the records are shuffled up and not in date
order! What could be the problem here?
 
There are different possibilities. How are the records being displayed? On a
form, in a listbox or what? How is the form or listbox loaded, via a query, a
table or in VB code? You need to check if the dates are indeed being sorted
or if its just a happy accident that they are mostly in order.

Dorian
 
Hmmm, well the records are displayed on a form but I'm not sure how the form
is loaded. It's a table I think.
 
In the form designer, Click 'View--Properties' then click the Data tab and
look at 'Record Source' and 'Order By'. If it's a table, the records are
unsorted unless there is something in 'order by'. If it's a query, you will
have to look at the query to see if it is sorting (has an ORDER BY clause).

Dorian
 
Back
Top