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

Hi Arthur:

I have worked with building a full interface for an excel spreadsheet before
and my experience though limited to a couple of projects may be of some
help. 

The best way I found hold the position on a spreadsheet is save the current
position, though code and then hop back when a particular process is
finished. If the row is re-sorted then saving the particulars of the row and
doing a search, row by row is best. Seeing that you only have a maximum of
65,000 odd rows the performance can be fairly fast.

The process your client wants can be set by re-sorting the row/columns/range
and then re-positioning yourself. You could just add another button to the
sheet that would allow the client to just press it to start the code/macro.
If dates and times of record creation are needed but the client does not
want that information shown just auto-set it in a couple of hidden columns.

I left you some code samples on the DBA-Tech list on adding and deleting and
hope you will find it useful.

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Monday, December 24, 2007 12:48 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] The Command underlying the AZ and ZA buttons on the
Access 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