By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,369 Members | 966 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,369 IT Pros & Developers. It's quick & easy.

Build list from bottom to top

P: n/a
Hi guys,

At the request of the end user, I am trying to build a main search
screen for an access 97 database that graphically replicates "in
trays". I have a table that has a field that records which "tray" the
record is in, and I can move it about no problem (built a nifty little
right-click menu for the movement). The problem that I have is that
access builds lists and tables from the top down. I want to have the
graphics for the trays at the bottom of the page, 4 or 5 different
trays. Then I want to replicate the folders above these trays,
looking like a stack of work. I can do this using set of continuous
forms, with a background that looks like a file, so the graphics are
not a problem. However, because the sub forms are going to be a set
size, where there are few jobs in the trays, they will look like they
are floating, unless I put the trays at the top of the page.

I want it to behaive like this;
Job10
Job3 Job9
Job2 Job5 Job8
Job1 Job4 Job6 Job7
Tray1 Tray2 Tray3 Tray4
But it will however behaive like this;

Job3 Job5 Job6 Job10
Job2 Job4 Job9
Job1 Job8
Job7
Tray1 Tray2 Tray3 Tray4
So, is it possible to reverse the direction of how the form is built,
so that it always starts at the bottom of the page? I don't think
that going to the last record will help, becuase won't this still put
the list at the top of the form? Are there perhaps any controls that
will do this kind of thing?

Thanks in advance!

May 18 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.