Sorting feature (seemingly) disabled - help!

E

eire

I'm still learning. Thought I was making progress! Now, the sorting feature
(when in an Access table) appears to be disabled. Can anyone help me figure
out what I've done?
 
S

Steve

Do your sorting in a query based on your table. You can sort on any field in
the table and turn sorting on and off in the query design grid.

Steve
 
E

eire

Thank you. I do use the querys quite a bit. Just wondering why it seems
like the sort feature is disabled in the table view. It seems like it wasn't
like that last week, but possibly I'm having a senior/blonde moment.
 
S

Steve

Just to comment .... You should use queries ALWAYS to sort your data or to
work with a selected set of data!

You don't say what version of Access you have so I am presuming Access2003
or earlier. Open your table where you can see the data in your table. There
are two sorting buttons in the menu at the top of the screen. One has AZ
with a down arrow for sorting ascending and one with ZA and a down arrow for
sorting descending. You can sort on any column in your table by selecting a
column then clicking one of these buttons. Once you sort your table, neither
button will undo the sort. To unsort your table, click on Records - Remove
Filter/Sort in the menu at the top of the screen.

Steve
 
E

eire

Thank you Steve. I'm using Access 2007. I figured it out...I had it locked.
Went into access options & miraculously everything is back to the way it
was. I definitely feel blonde.

The reason I felt it important to have this feature in the table view, is
because I'm doing double duty now. Checking math on invoices in excel, then
re-entering them into the Access table. The querys are wonderful...my reason
for wanting to use Access. But because I'm entering info twice, I need it
sorted when I enter it into the table to make sure I'm not re-entering the
same invoice.

I realize it is possible to import...just haven't made it there yet. Still
learning. :)
Do you have any tips on how to set up the "Invoice No." field to
automatically check to make sure I'm not duplicating any? That would be
wonderful. Thanks again.
 
S

Steve

Re: not duplicating "Invoice No." field
1 In your table you could set the Index property to Yes(No
Duplicates). Open your table in design view, select the "Invoice No." field
and set the property in the bottom part of the design grid. Access would
throw up an error message any time you tried to save a duplicate invoice#.
OR
2 In your form where you enter Invoice No., put the following code in
the Before Update event of the "Invoice No." field:
If DCount("[Invoice No]","NameOfYourTable","Forms!NameOfYourForm![Invoice
No]") > 0 Then
MsgBox "Duplicate Invoice No Not Allowed"
Cancel = True
End If
The message will appear if you try and enter a duplicate Invoice No and you
will not be allowed to continue until you change the Invoice No.

I provide help with Access applications for a modest fee. I could set up
your database so that the math on invoices would automatically be checked as
you enter them in Access. Excel would be eliminated and your doing double
duty would be eliminated. My fee would be very reasonable. Contact me at
[email protected] if you are interested.

Steve
 
Top