[AccessD] The Command underlying the AZ and ZA buttons on theAccess toolbar

http://office.microsoft.com/en-us/access/HA010345631033.aspx?pid=CL100570041033

William ...the philistine lout :)

----- Original Message ----- 
From: "Arthur Fuller" <fuller.artful at gmail.com>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Monday, December 24, 2007 3:47 PM
Subject: [AccessD] The Command underlying the AZ and ZA buttons on theAccess 
toolbar


> My client is giving me so much aggravation on this! She wants the detail
> records to show up most recent first, meaning that after a detail row is
> added, it automatically drifts to the top of the subform, rather than
> remaining on the bottom. This is easy enough to do, just by clicking the 
> ZA
> button on the toolbar after adding the new record, but what is the VBA
> command constant that represents this command?
>
> I guess I'll try building a macro and see what code gets generated. If
> anyone already knows how to code this, and has nothing better to do on
> Christmas Eve, let me know. I can't recall ever building a macro in 
> Access,
> but what the hell, I'll give it a shot.
>
> Well, I gave it a shot, and I have no idea what this weird interface is
> about. Excel macros are soooo much easier! I need to relocate that list of
> Access command things and give that a try instead. The client is adamant
> that she wants the most recent transactions on top, and I can see her 
> point,
> since there could be hundreds per master  record and they show the 
> balance,
> which is the item of most immediate interest, and the transactions of
> immediate interest are those within the last few days to month, so that's
> why they should be on top not at the bottom.
>
> But I am having a most difficult time arranging this. Any advice 
> greatfully
> appreciated.
>
> TIA.
> Arthur
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com