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

Arthur Fuller fuller.artful at gmail.com
Mon Dec 24 14:47:50 CST 2007


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



More information about the AccessD mailing list