Macro Button to Sort Field A-Z

rdirosato · #1 03-11-2010, 08:51 AM

Hello,

Say I have a report or form with some columns like below

Name.........Number........Phone
Rob............222..............222
Joe.............111..............333

What I'm trying to do is create a macro that when the title name (Name Number Phone) is clicked it will sort the column a-z

Thanks in advance for your help

ajetrumpet · #2 03-11-2010, 07:32 PM

i believe you do this using the ORDERBY property. so on the click on each label that holds the field names, put something like this on the click event property:

Code:


			
=sortfield("fieldname", "formname")

then write a universal function like this:

Code:


			
public function sortfield(fld as string, frm as string)

forms(frm).orderby = fieldname
forms(frm).orderbyon = true
forms(frm).requery

end function

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Submit Button:How can I assign a button to go to the next record and its first field?	nitinrao	Forms	6	02-09-2010 04:53 AM
How to sort by three sort orders	captgnvr	Access	4	11-09-2009 04:30 AM
Macro tools wizard / making a button to open a form	oddsteven	Forms	3	10-16-2009 05:54 AM
Macro to Run RemoveFilter/Sort	Ryan	Access	0	08-29-2009 11:41 PM
Sort	mmp97	Access	1	12-18-2008 07:14 PM