Sorting

J

John Vinson

How do I disable sorting?
Click to expand...

Please explain.

Records must be presented in SOME order. There is no "overprint" or
"all at once" option on most computer screens!

Note that records in an Access Table are stored and presented in
whatever order Access finds convenient. If you want to see them in the
order in which they were entered, it's best to include either a
sequential autonumber field or a timestamp field with a default value
of Now(), and use a query sorted by this field.

John W. Vinson[MVP]
 
A

alaskahawk

I have a datasheet form that brings up a record in another form when the user
double-clicks on a record. Both forms have to be sorted the same way
otherwise Access does not open the correct record. I want to disable the
sort so that users do no mess up the orders. Make sense?
 
J

John Vinson

I have a datasheet form that brings up a record in another form when the user
double-clicks on a record. Both forms have to be sorted the same way
otherwise Access does not open the correct record. I want to disable the
sort so that users do no mess up the orders. Make sense?
Click to expand...

If you're making assumptions about the order of records in a table to
find records in another table, you're on the wrong track. Relational
databases don't work that way!

I'd VERY strongly recommend - insist even <g> - that you should have
some matching unique field in the two tables, and link the two tables
by the value of that field. That's how relational databases are
designed to work.

Could you post your doubleclick code?

John W. Vinson[MVP]
 
A

alaskahawk

Yes, I understand how relational databases work, thanks. This is 2 FORMS
using the same table data. One in datasheet view, then double-click to get
to columnar view for a single record.

Double-click code:

Private Sub Form_DblClick(Cancel As Integer)
Dim num As Long

num = Me.CurrentRecord

DoCmd.OpenForm "T_Request"
DoCmd.GoToRecord acDataForm, "T_Request", acGoTo, num

End Sub

Thanks for your assistance.
 
J

John Vinson

Yes, I understand how relational databases work, thanks. This is 2 FORMS
using the same table data. One in datasheet view, then double-click to get
to columnar view for a single record.

Double-click code:

Private Sub Form_DblClick(Cancel As Integer)
Dim num As Long

num = Me.CurrentRecord

DoCmd.OpenForm "T_Request"
DoCmd.GoToRecord acDataForm, "T_Request", acGoTo, num

End Sub

Thanks for your assistance.
Click to expand...

As opposed to

DoCmd.OpenForm "T_Request", WhereCondition:= "[ID] = " & Me![ID]

which doesn't depend on the order of records in the table?

John W. Vinson[MVP]
 
A

alaskahawk

Thanks! That works much better, I didn't even think about the wherecondition
option.

John Vinson said:
Yes, I understand how relational databases work, thanks. This is 2 FORMS
using the same table data. One in datasheet view, then double-click to get
to columnar view for a single record.

Double-click code:

Private Sub Form_DblClick(Cancel As Integer)
Dim num As Long

num = Me.CurrentRecord

DoCmd.OpenForm "T_Request"
DoCmd.GoToRecord acDataForm, "T_Request", acGoTo, num

End Sub

Thanks for your assistance.
Click to expand...

As opposed to

DoCmd.OpenForm "T_Request", WhereCondition:= "[ID] = " & Me![ID]

which doesn't depend on the order of records in the table?

John W. Vinson[MVP]
Click to expand...
 
Top