Is it possible to freeze "rows" in Microsoft Access?

[(PeteCresswell)]

Per (e-mail address removed):

a) my solution freeze rows
2 datasheets
1) frozen rows (at the top, as in unfrozen rows)
2) unfrozen rows (at the bottom)

so when you click the freeze button on the bottom; it makes the record
zap up to the top; shit you could do it with a NOW() statement and sort
things in the order you added them

That's a *lot* better than my half-assed notion of populating .Caption in
labels.

Besides preserving the format, it opens the possibility of hiding it altogether
as long as the user has never clicked the 'Freeze' button.

 

[aaron.kempf]

i just dont understand your label thing pete

i mean-- what are you talking about?

labels for each record? setting the caption for a label for each frozen
record? why can't you just set the locked property instead?

 

[TC]

Yes, good point!

TC

 

[TC]

Hey Einstein:

Show me the code to freeze rows IN TABLE VIEW.

^^^^^^^^^^^^^^^^^^^^

If you don't know what "table view" is, I can recommend a good book on
getting started with Microsoft Access.

TC

 

[(PeteCresswell)]

Per (e-mail address removed):

i just dont understand your label thing pete

i mean-- what are you talking about?

labels for each record? setting the caption for a label for each frozen
record? why can't you just set the locked property instead?

It's probably not worth understanding.

I was proposing the creation of a label for each field in the continuous list.
The labels located above the list, like column headers.

Then when the user clicks "Freeze", the label captions would be populated with
data from each of the current record's fields.

Lousy idea in light of yours.

 

[aaron.kempf]

uh you do this in table view.. by having 2 different table views, duh

one for frozen records, one for unfrozen records