I have a continuous form that I want to sort by the column (field) when the lable is clicked. If the field is currently in DESCENDING then I want to reverse the sort when clicked. If no sort is currently on then sort Ascending.
What is the best way to do this?
me.orderBy or DoCmd.runcommand ascmdsortascending?
assuming the field you want to sort by is LastName and the the label is LastName_label
private sub LastName_Label_click()
if me.orderby="LastName desc" then
Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Learn how to number pages in an Access report over each group.
Activate two pass printing by referencing the pages property:
Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …