[AccessD] Is it possible to use VBA to clear out the "Order By" property of a Query in Access 2002?

Brad Marks BradM at blackforestltd.com
Mon Nov 29 16:59:39 CST 2010


We are making minor changes to an Access 2002 application.

We would like to always clear any fields in the "Order By" property of a
specific query so that each time the query is opened fresh, the sort
reverts back to the sort fields specified in the query itself.

We would like to still allow sorting when the query is opened, but we
would like to wipe out any "Order By" fields that someone may have
accidently saved when they were exiting the application.


Thanks,
Brad




More information about the AccessD mailing list