Freeze Panes

  • Thread starter Thread starter Shell
  • Start date Start date
S

Shell

In Access 2000, I have a form which esentially a display of a table through a
query.

Can I freeze columns in a manner similary to Excel. The data is too wide to
fit on the screen. I want to freeze some columns and be able to slide the
other columns. The frozen columns will be on the left.

Thanks
 
Shell said:
In Access 2000, I have a form which esentially a display of a table
through a
query.

Can I freeze columns in a manner similary to Excel. The data is too wide
to
fit on the screen. I want to freeze some columns and be able to slide the
other columns. The frozen columns will be on the left.
Click to expand...


The only way I can think of to do this is to use two correlated subforms,
side by side. One subform would show the "frozen" columns; one would show
the "slideable" ones. Fairly elaborate code would have to be used to keep
the scroll position and current records of the subforms in sync, and you
wouldn't really be able to select a complete row for, say, copy/paste
operations, because it would really be two separate rows (one on each
subform).

Stephen Lebans has done some work with manipulating column widths, including
freezing them, here:

http://www.lebans.com/autocolumnwidth.htm

However, I don't think that will let you get the effect you want.
 
Actually it is much the same as excel. In datasheet view

Select the column at the left you want frozen (click the tab at the top)

under the format menu choose freeze panes.
 
Shell said:
In Access 2000, I have a form which esentially a display of a table
through a
query.

Can I freeze columns in a manner similary to Excel. The data is too wide
to
fit on the screen. I want to freeze some columns and be able to slide the
other columns. The frozen columns will be on the left.

Thanks
Click to expand...

If your form is opened as a datasheet, then yes. Select the columns you want
to freeze (by dragging across the column titles), then go to Format ->
Freeze Columns.

Job done.
 
Chegu Tom said:
Actually it is much the same as excel. In datasheet view

Select the column at the left you want frozen (click the tab at the top)

under the format menu choose freeze panes.
Click to expand...


Wow, I didn't know that! Thanks!
 
Stuart McCall said:
If your form is opened as a datasheet, then yes. Select the columns you
want to freeze (by dragging across the column titles), then go to
Format -> Freeze Columns.
Click to expand...


I didn't know that! Thanks, Stuart!
 
Dirk Goldgar said:
The only way I can think of to do this is to use two correlated subforms,
side by side.
Click to expand...

Ignore this response, please -- it turns out to be utterly uninformed.
 
Dirk Goldgar said:
I didn't know that! Thanks, Stuart!

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)
Click to expand...

Hi Dirk

If you're like me you won't normally supply users with datasheets because
they're too powerful (ie its too easy to make unwanted changes), but I wrote
an app in A97 for one user who runs a vehicle fleet and he was perfectly at
home with datasheets. Once he grasped the concept of what rows and columns
mean in Access rather than Excel there was no stopping him. I learned that
trick (among others) from him.
 
Stuart McCall said:
If you're like me you won't normally supply users with datasheets because
they're too powerful (ie its too easy to make unwanted changes)
Click to expand...

Yes, for that reason and because I usually relate tables via surrogate keys
that wouldn't mean anything to the user if displayed in a datasheet. But
that doesn't mean I don't want to know everything that Access can do. :-)
 
Back
Top