Run a Macro to Sort a Table in Access 2003

slifer666

Master Duelist
Local time
Today, 15:26
Joined
Oct 20, 2005
Messages
25
Ok,

I have a table that has new data added into it through forms, and i want the data to be sorted when a new record is added.

The person that the database is for is new to Access and therefore is not 100% competant at it.

I wanted to add a button onto the forms that would run a macro that would sort the data. Is there a macro in Access that can do this?

Cheers,

Slifer
 
slifer666 said:
I wanted to add a button onto the forms that would run a macro that would sort the data. Is there a macro in Access that can do this?

Cheers,

Slifer

You don't need a macro to sort your data. Simply bound your form to a query based on your table and with that, you'll be able to sort any data the way you want.

Hth
 
rak said:
You don't need a macro to sort your data. Simply bound your form to a query based on your table and with that, you'll be able to sort any data the way you want.

Hth

Thanks, and how exactly do i do this (its been a while since i used Access!!)
 
Make a query based on your table.
In the query design grid , you can enter sort data functions and put in criteria.
Bind your form to this query and in the form you secondly have the possibility to filter and sort ( records> filter - sort) .

Hth
 
Cheers

That worked brilliantly thanks

Regards
 

Users who are viewing this thread

Back
Top Bottom