M
MS
Is it possible to freeze "rows" in Microsoft Access?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Tom Wickerath
No. You can freeze columns in table view, but not records (rows).
Tom
http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
:
Is it possible to freeze "rows" in Microsoft Access?
Tom
http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
:
Is it possible to freeze "rows" in Microsoft Access?
A
aaron.kempf
well you can do some pretty crazy stuff with conditional formatting
i argue that i could conditionally freeze a row without writing a
single line of code (well less than a half-dozen lines of code)
i argue that i could conditionally freeze a row without writing a
single line of code (well less than a half-dozen lines of code)
T
TC
Tell us precisely how you would freeze a row in table view - with or
without any code.
TC
without any code.
TC
C
Chris2
MS said:Is it possible to freeze "rows" in Microsoft Access?
MS,
May I ask what you mean by "freeze rows in MS Access"?
Sincerely,
Chris O.
L
Larry Linson
TC said:Tell us precisely how you would freeze
a row in table view - with or
without any code.
Tom just said that you CANNOT freeze a row in table view.
I will add... "with or without code."
When someone says it is not possible to do what you first asked about,
asking for specifics of how to do it is not likely to make it possible.
Larry Linson
Microsoft Access MVP
J
John Vinson
Tom just said that you CANNOT freeze a row in table view.
I will add... "with or without code."
When someone says it is not possible to do what you first asked about,
asking for specifics of how to do it is not likely to make it possible.
I think TC was trying to show up Aaron's bluster and pretension for
what it is, challenging him to "put up or shut up".
John W. Vinson[MVP]
T
TC
Um - like John said!
TC
TC
T
Tom Wickerath
Aaron has been challanged to "put up or shut up" MANY times in the past,
frequently when he uses the term "Excel dork". He's never put up with
satisfactory solutions. He also never shuts up.
Tom
http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
:
I think TC was trying to show up Aaron's bluster and pretension for
what it is, challenging him to "put up or shut up".
frequently when he uses the term "Excel dork". He's never put up with
satisfactory solutions. He also never shuts up.
Tom
http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
:
I think TC was trying to show up Aaron's bluster and pretension for
what it is, challenging him to "put up or shut up".
P
(PeteCresswell)
Per TC:
I don't think it's possible either.
But one might simulate it.
Have a "Freeze" button.
When somebody clicks "Freeze", take the data from the currently-selected row and
blow it up into the .Caption values of the form's header labels.
However, I'm having trouble envisioning a situation where that would be
useful...
I'd think a hierarchical list would probably be a better solution where a data
set is ordered by, for instance, Firm/Fund and one wanted to avoid cluttering up
the scrolling form with that information.
how you would freeze a row in table view
I don't think it's possible either.
But one might simulate it.
Have a "Freeze" button.
When somebody clicks "Freeze", take the data from the currently-selected row and
blow it up into the .Caption values of the form's header labels.
However, I'm having trouble envisioning a situation where that would be
useful...
I'd think a hierarchical list would probably be a better solution where a data
set is ordered by, for instance, Firm/Fund and one wanted to avoid cluttering up
the scrolling form with that information.
A
aaron.kempf
when you say freeze, you mean disable right??
A
aaron.kempf
cuz i freeze rows ALLL THE TIME via conditional formatting for this
point of sale system i've got
i'll try to cut it down to a couple of lines; but i mean.. come on---
continuous form
text1 text2 text3 text4 (uneditable) (covered by cmdInvisible)
text5 text6 (editable)
you have text1-text4 as disabled, locked; and a transparent button on
top of it. this button well 'select this row as the current row'.
have the what.. beforeInsert, AfterInsert-- something-- on text5 and
text6 so that when you enter cell 5 and 6 you call cmdInvisible_OnClick
Public Sub cmdInvisible_onClick()
Me.text5.enabled = Me.isEditable
Me.text6.enabled = Me.isEditable
End Sub
I mean-- pretty cut and dry
if you really mean freeze; we could figure something out with subforms
that would do what you wanted
forms and subforms are pretty friggin powerful.. especially if you know
vba; and this is what sets access on a level above crappy apps like
Excel for example
if you mean freeze-- like you want to scroll down and keep certain rows
at the top; i mean-- shit -- it's doable..
I mean
MyForm
FIRSTNAME LASTNAME EMPLOYEEID EMAIL
BIRTHDATE
AARON KEMPF 000-00-0000 (e-mail address removed)
6/19/1974 <FREEZE>
MARTHA STEWART 000-00-0000 (e-mail address removed)
4/20/1940 <FREEZE>
MATT KEMPF 000-00-0000
<FREEZE>
LARRY YOUNG 000-00-0000
<FREEZE>
MDB SISSY 000-00-0000
<FREEZE>
so what you want to do is click on the freeze button for Larry Young
and Aaron Kempf; and these would show up at the TOP of the form... so
that you could then scroll down to see the rest?
i mean-- do i really need to fill in the blanks?
a) take your form and turn it into this
FIRSTNAME LASTNAME EMPLOYEEID EMAIL
BIRTHDATE
AARON KEMPF 000-00-0000 (e-mail address removed)
6/19/1974 <FREEZE>
MARTHA STEWART 000-00-0000 (e-mail address removed)
4/20/1940 <FREEZE>
MATT KEMPF 000-00-0000
<FREEZE>
LARRY YOUNG 000-00-0000
<FREEZE>
MDB SISSY 000-00-0000
<FREEZE>
and turn it into this
FIRSTNAME LASTNAME EMPLOYEEID EMAIL
BIRTHDATE
AARON KEMPF 000-00-0000 (e-mail address removed)
6/19/1974 <FREEZE>
LARRY YOUNG 000-00-0000
<FREEZE>
FIRSTNAME LASTNAME EMPLOYEEID EMAIL
BIRTHDATE
MARTHA STEWART 000-00-0000 (e-mail address removed)
4/20/1940 <FREEZE>
MATT KEMPF 000-00-0000
<FREEZE>
MDB SISSY 000-00-0000
<FREEZE>
b) Then you delete the lables from the 2nd section
c) scooch the 2nd section up a little bit
d) change the recordsources to work off of a db-driven variable named
'isFrozen'
or soemthing along those lines
im sure we could do something other than a simple db-driven variable
but this would act just like freezing-- you could lock certain rows at
the top of your datasheet; and it woudln't be that hard to do
ps - you guys are a bunch of assholes for giving me a hard time. MDB
is crap and you guys are all a bunch of wimps. I spit in your face,
MDB sissies
point of sale system i've got
i'll try to cut it down to a couple of lines; but i mean.. come on---
continuous form
text1 text2 text3 text4 (uneditable) (covered by cmdInvisible)
text5 text6 (editable)
you have text1-text4 as disabled, locked; and a transparent button on
top of it. this button well 'select this row as the current row'.
have the what.. beforeInsert, AfterInsert-- something-- on text5 and
text6 so that when you enter cell 5 and 6 you call cmdInvisible_OnClick
Public Sub cmdInvisible_onClick()
Me.text5.enabled = Me.isEditable
Me.text6.enabled = Me.isEditable
End Sub
I mean-- pretty cut and dry
if you really mean freeze; we could figure something out with subforms
that would do what you wanted
forms and subforms are pretty friggin powerful.. especially if you know
vba; and this is what sets access on a level above crappy apps like
Excel for example
if you mean freeze-- like you want to scroll down and keep certain rows
at the top; i mean-- shit -- it's doable..
I mean
MyForm
FIRSTNAME LASTNAME EMPLOYEEID EMAIL
BIRTHDATE
AARON KEMPF 000-00-0000 (e-mail address removed)
6/19/1974 <FREEZE>
MARTHA STEWART 000-00-0000 (e-mail address removed)
4/20/1940 <FREEZE>
MATT KEMPF 000-00-0000
<FREEZE>
LARRY YOUNG 000-00-0000
<FREEZE>
MDB SISSY 000-00-0000
<FREEZE>
so what you want to do is click on the freeze button for Larry Young
and Aaron Kempf; and these would show up at the TOP of the form... so
that you could then scroll down to see the rest?
i mean-- do i really need to fill in the blanks?
a) take your form and turn it into this
FIRSTNAME LASTNAME EMPLOYEEID EMAIL
BIRTHDATE
AARON KEMPF 000-00-0000 (e-mail address removed)
6/19/1974 <FREEZE>
MARTHA STEWART 000-00-0000 (e-mail address removed)
4/20/1940 <FREEZE>
MATT KEMPF 000-00-0000
<FREEZE>
LARRY YOUNG 000-00-0000
<FREEZE>
MDB SISSY 000-00-0000
<FREEZE>
and turn it into this
FIRSTNAME LASTNAME EMPLOYEEID EMAIL
BIRTHDATE
AARON KEMPF 000-00-0000 (e-mail address removed)
6/19/1974 <FREEZE>
LARRY YOUNG 000-00-0000
<FREEZE>
FIRSTNAME LASTNAME EMPLOYEEID EMAIL
BIRTHDATE
MARTHA STEWART 000-00-0000 (e-mail address removed)
4/20/1940 <FREEZE>
MATT KEMPF 000-00-0000
<FREEZE>
MDB SISSY 000-00-0000
<FREEZE>
b) Then you delete the lables from the 2nd section
c) scooch the 2nd section up a little bit
d) change the recordsources to work off of a db-driven variable named
'isFrozen'
or soemthing along those lines
im sure we could do something other than a simple db-driven variable
but this would act just like freezing-- you could lock certain rows at
the top of your datasheet; and it woudln't be that hard to do
ps - you guys are a bunch of assholes for giving me a hard time. MDB
is crap and you guys are all a bunch of wimps. I spit in your face,
MDB sissies
T
TC
The post to which you originally replied, said:
"No. You can freeze columns in table view, but not records (rows)."
^^^^^^^^^^^^^^^^^^
You replied:
"well you can do some pretty crazy stuff with conditional formatting
i argue that i could conditionally freeze a row without writing a
single line of code (well less than a half-dozen lines of code)"
As I said before, and say again now:
"Show me how you can freeze a row in table view - with or without any
code."
^^^^^^^^^^^^^^^^^^^^
TC
"No. You can freeze columns in table view, but not records (rows)."
^^^^^^^^^^^^^^^^^^
You replied:
"well you can do some pretty crazy stuff with conditional formatting
i argue that i could conditionally freeze a row without writing a
single line of code (well less than a half-dozen lines of code)"
As I said before, and say again now:
"Show me how you can freeze a row in table view - with or without any
code."
^^^^^^^^^^^^^^^^^^^^
TC
T
TC
Hey Einstein:
The post to which you originally replied, said:
"No. You can freeze columns in table view, but not records (rows)."
^^^^^^^^^^^^^^^^^^
You replied:
"well you can do some pretty crazy stuff with conditional formatting
i argue that i could conditionally freeze a row without writing a
single line of code (well less than a half-dozen lines of code)"
As I said before, and say again now:
"Show me how you can freeze a row in table view - with or without any
code."
^^^^^^^^^^^^^^^^^^^^
TC
The post to which you originally replied, said:
"No. You can freeze columns in table view, but not records (rows)."
^^^^^^^^^^^^^^^^^^
You replied:
"well you can do some pretty crazy stuff with conditional formatting
i argue that i could conditionally freeze a row without writing a
single line of code (well less than a half-dozen lines of code)"
As I said before, and say again now:
"Show me how you can freeze a row in table view - with or without any
code."
^^^^^^^^^^^^^^^^^^^^
TC
L
Larry Linson
John Vinson said:I think TC was trying to show up Aaron's bluster and pretension for
what it is, challenging him to "put up or shut up".
Then possibly he should have quoted just a bit. I did not and do not see
aaron's posts because he is in my twit-filter / blocked-sender list, so it
appeared to me that his response was to Tom. Sorry for the misunderstanding.
Larry Linson
Microsoft Access MVP
A
aaron.kempf
I JUST DESCRIBED HOW TO DO IT FUCKNUT
DO YOU WANT ME TO WRITE AN EXAMPLE FOR YOU?
DO YOU WANT ME TO WRITE AN EXAMPLE FOR YOU?
A
aaron.kempf
oh larry
oh.. no-- you blocked me
go play with your MDB you sissy
oh.. no-- you blocked me
go play with your MDB you sissy
A
aaron.kempf
TC
cuz i freeze rows ALLL THE TIME via conditional formatting for this
point of sale system i've got
i'll try to cut it down to a couple of lines; but i mean.. come on---
continuous form
text1 text2 text3 text4 (uneditable) (covered by cmdInvisible)
text5 text6 (editable)
you have text1-text4 as disabled, locked; and a transparent button on
top of it. this button well 'select this row as the current row'.
have the what.. beforeInsert, AfterInsert-- something-- on text5 and
text6 so that when you enter cell 5 and 6 you call cmdInvisible_OnClick
Public Sub cmdInvisible_onClick()
Me.text5.enabled = Me.isEditable
Me.text6.enabled = Me.isEditable
End Sub
I mean-- pretty cut and dry
if you really mean freeze; we could figure something out with subforms
that would do what you wanted
forms and subforms are pretty friggin powerful.. especially if you know
vba; and this is what sets access on a level above crappy apps like
Excel for example
if you mean freeze-- like you want to scroll down and keep certain rows
at the top; i mean-- shit -- it's doable..
I mean
MyForm
FIRSTNAME LASTNAME EMPLOYEEID EMAIL
BIRTHDATE
AARON KEMPF 000-00-0000 (e-mail address removed)
6/19/1974 <FREEZE>
MARTHA STEWART 000-00-0000 (e-mail address removed)
4/20/1940 <FREEZE>
MATT KEMPF 000-00-0000
<FREEZE>
LARRY YOUNG 000-00-0000
<FREEZE>
MDB SISSY 000-00-0000
<FREEZE>
so what you want to do is click on the freeze button for Larry Young
and Aaron Kempf; and these would show up at the TOP of the form... so
that you could then scroll down to see the rest?
i mean-- do i really need to fill in the blanks?
a) take your form and turn it into this
FIRSTNAME LASTNAME EMPLOYEEID EMAIL
BIRTHDATE
AARON KEMPF 000-00-0000 (e-mail address removed)
6/19/1974 <FREEZE>
MARTHA STEWART 000-00-0000 (e-mail address removed)
4/20/1940 <FREEZE>
MATT KEMPF 000-00-0000
<FREEZE>
LARRY YOUNG 000-00-0000
<FREEZE>
MDB SISSY 000-00-0000
<FREEZE>
and turn it into this
FIRSTNAME LASTNAME EMPLOYEEID EMAIL
BIRTHDATE
AARON KEMPF 000-00-0000 (e-mail address removed)
6/19/1974 <FREEZE>
LARRY YOUNG 000-00-0000
<FREEZE>
FIRSTNAME LASTNAME EMPLOYEEID EMAIL
BIRTHDATE
MARTHA STEWART 000-00-0000 (e-mail address removed)
4/20/1940 <FREEZE>
MATT KEMPF 000-00-0000
<FREEZE>
MDB SISSY 000-00-0000
<FREEZE>
b) Then you delete the lables from the 2nd section
c) scooch the 2nd section up a little bit
d) change the recordsources to work off of a db-driven variable named
'isFrozen'
e) sorry-- programmatically set the height of the top session to
simulate having locked rows at top
or soemthing along those lines
im sure we could do something other than a simple db-driven variable
but this would act just like freezing-- you could lock certain rows at
the top of your datasheet; and it woudln't be that hard to do
ps - you guys are a bunch of assholes for giving me a hard time. MDB
is crap and you guys are all a bunch of wimps. I spit in your face,
MDB sissies
cuz i freeze rows ALLL THE TIME via conditional formatting for this
point of sale system i've got
i'll try to cut it down to a couple of lines; but i mean.. come on---
continuous form
text1 text2 text3 text4 (uneditable) (covered by cmdInvisible)
text5 text6 (editable)
you have text1-text4 as disabled, locked; and a transparent button on
top of it. this button well 'select this row as the current row'.
have the what.. beforeInsert, AfterInsert-- something-- on text5 and
text6 so that when you enter cell 5 and 6 you call cmdInvisible_OnClick
Public Sub cmdInvisible_onClick()
Me.text5.enabled = Me.isEditable
Me.text6.enabled = Me.isEditable
End Sub
I mean-- pretty cut and dry
if you really mean freeze; we could figure something out with subforms
that would do what you wanted
forms and subforms are pretty friggin powerful.. especially if you know
vba; and this is what sets access on a level above crappy apps like
Excel for example
if you mean freeze-- like you want to scroll down and keep certain rows
at the top; i mean-- shit -- it's doable..
I mean
MyForm
FIRSTNAME LASTNAME EMPLOYEEID EMAIL
BIRTHDATE
AARON KEMPF 000-00-0000 (e-mail address removed)
6/19/1974 <FREEZE>
MARTHA STEWART 000-00-0000 (e-mail address removed)
4/20/1940 <FREEZE>
MATT KEMPF 000-00-0000
<FREEZE>
LARRY YOUNG 000-00-0000
<FREEZE>
MDB SISSY 000-00-0000
<FREEZE>
so what you want to do is click on the freeze button for Larry Young
and Aaron Kempf; and these would show up at the TOP of the form... so
that you could then scroll down to see the rest?
i mean-- do i really need to fill in the blanks?
a) take your form and turn it into this
FIRSTNAME LASTNAME EMPLOYEEID EMAIL
BIRTHDATE
AARON KEMPF 000-00-0000 (e-mail address removed)
6/19/1974 <FREEZE>
MARTHA STEWART 000-00-0000 (e-mail address removed)
4/20/1940 <FREEZE>
MATT KEMPF 000-00-0000
<FREEZE>
LARRY YOUNG 000-00-0000
<FREEZE>
MDB SISSY 000-00-0000
<FREEZE>
and turn it into this
FIRSTNAME LASTNAME EMPLOYEEID EMAIL
BIRTHDATE
AARON KEMPF 000-00-0000 (e-mail address removed)
6/19/1974 <FREEZE>
LARRY YOUNG 000-00-0000
<FREEZE>
FIRSTNAME LASTNAME EMPLOYEEID EMAIL
BIRTHDATE
MARTHA STEWART 000-00-0000 (e-mail address removed)
4/20/1940 <FREEZE>
MATT KEMPF 000-00-0000
<FREEZE>
MDB SISSY 000-00-0000
<FREEZE>
b) Then you delete the lables from the 2nd section
c) scooch the 2nd section up a little bit
d) change the recordsources to work off of a db-driven variable named
'isFrozen'
e) sorry-- programmatically set the height of the top session to
simulate having locked rows at top
or soemthing along those lines
im sure we could do something other than a simple db-driven variable
but this would act just like freezing-- you could lock certain rows at
the top of your datasheet; and it woudln't be that hard to do
ps - you guys are a bunch of assholes for giving me a hard time. MDB
is crap and you guys are all a bunch of wimps. I spit in your face,
MDB sissies
P
(PeteCresswell)
Per (e-mail address removed):
I think maybe there is a semantic issue here:
Freeze Rows: As in make rows non-editable.
Freeze Rows: As in make one row persist on the screen when other rows are
scrolled.
I took the OP to refer to the second one.
cuz i freeze rows ALLL THE TIME via conditional formatting for this
point of sale system i've got
I think maybe there is a semantic issue here:
Freeze Rows: As in make rows non-editable.
Freeze Rows: As in make one row persist on the screen when other rows are
scrolled.
I took the OP to refer to the second one.
A
aaron.kempf
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
the only part that would be difficult at all would be detecting how
many rows to display; i mean-- it wouldn't be as cut and dry as it
sounds; since if could have 300 rows frozen; but you could only display
40 rows at a time; what would oyu do then (add a scroll bar to the top
section; aka just set the vertical scrollbar on)
i mean; when you have 10 rows that are frozen; how tall do you make the
frozen section?
thats the only thing that would take me 30 seconds
shit can i just email people examples?? straight out of northwind?
it'll take me a day im kneedeep with some deadlines
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
the only part that would be difficult at all would be detecting how
many rows to display; i mean-- it wouldn't be as cut and dry as it
sounds; since if could have 300 rows frozen; but you could only display
40 rows at a time; what would oyu do then (add a scroll bar to the top
section; aka just set the vertical scrollbar on)
i mean; when you have 10 rows that are frozen; how tall do you make the
frozen section?
thats the only thing that would take me 30 seconds
shit can i just email people examples?? straight out of northwind?
it'll take me a day im kneedeep with some deadlines
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.