[AccessD] Freeze panes

Rocky Smolin rockysmolin at bchacc.com
Sat Feb 18 22:42:54 CST 2012


Thank you A.D.  Look like exactly what I need.  I didn't ask the client
about datasheet view but I can't see why that wouldn't work. Particularly if
I can force widths.

Rocky
  

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of A.D. Tejpal
Sent: Saturday, February 18, 2012 8:37 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Freeze panes

Rocky,

    If datasheet view is considered acceptable, my sample db named
Form_FreezeDataSheetColumnsAndSize (in Access 2000 file format) might be of
interest to you. It is available at Rogers Access Library. Link: 
http://www.rogersaccesslibrary.com/forum/forum_topics.asp?FID=45


    In this sample, the user can pinpoint the columns desired to remain
frozen. Such columns remain in perpetual view on left, during horizontal
scrolling. In addition, forcing fixed widths for desired columns is also
demonstrated.

    If at any stage you need to freeze certain rows in datasheet form,
another sample of mine, named FreezeDatasheetRows (available at same site)
would be pertinent. This sample demonstrates freezing of nominated rows in
datasheet view. Any combination of rows can be selected for this purpose
(not necessarily adjacent to start with). The selected rows are displayed at
the top and remain in perpetual view, while navigating through the
datasheet.

Best wishes,
A.D. Tejpal
------------

  ----- Original Message -----
  From: Rocky Smolin
  To: 'Access Developers discussion and problem solving' 
  Sent: Sunday, February 19, 2012 03:02
  Subject: Re: [AccessD] Freeze panes


  Possible - but since he wants to see all the fields for a record side by
  side I'd have to have two subforms and keep them synchronized.  Tricky.
  Actually the data will be in a subform because there's a couple of other
  functions with controls that need to be on the main form. 

  Thinking about it, instead of a horizontal scroll bar, I could have left
and
  right arrows.  Every time he hits the right arrow I could change the row
  source to eliminate one field and add another on the end.  

  Of course when I change the row source, the form will requery and set the
  record pointer back to the first record.  So that's a problem.  

  I could, of course, save the bookmark of the current record and position
the
  form back to that record again.   I've done that trick before.  However,
  that still makes the current record jump to the top of the form.

  Still...no, there's gotta be something better.

  R


  -----Original Message-----
  From: accessd-bounces at databaseadvisors.com
  [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David McAfee
  Sent: Saturday, February 18, 2012 12:36 PM
  To: Access Developers discussion and problem solving
  Subject: Re: [AccessD] Freeze panes

  What about using a subform?

  Only display the scrollbars for the subform.

  On Sat, Feb 18, 2012 at 9:27 AM, Doug Steele <dbdoug at gmail.com> wrote:

  > I did this once, but I cheated.  I have two sets of text boxes with
  > the 'frozen' data, one set at the left end of the screen and one just
  > out of sight past the right edge of the screen.  I don't give the user
  > a horizontal scrollbar.  When the user tabs or arrows off the right
  > hand end of the 'first' screen, I force the focus to a tiny field at
  > the right hand end of the current row.  This automatically makes the
  > second set of 'frozen' text boxes jump to the left hand side of the
  > screen, with the text boxes for the 'second' screen showing.  The
  > reverse happens when the user Shift-Tabs or left arrows to the left of
  > the first 'unfrozen' text box in the second screen.  I also let them
  > use the Home and End keys to switch back and forth between the two
views.
  >
  > Doug
  >
  >
  > >  Dear List:
  > >>
  > >> I have a client who wants a list of persons and companies on a
  > >> form, and following the person name and company, wants several
  > >> other fields. All
  > the
  > >> fields won't all fit on the display, so a horizontal slider bar is
  > >> OK to see the fields hidden off to the right off the screen.
  > >>
  > >> However, he would like the person name and company name not to
  > >> slide off to the left as he slides to the right - similar to the
  > >> Freeze Panes
  > function
  > >> in
  > >> Excel.
  > >>
  > >> I haven't really thought about a technique to do this, but maybe
  > >> there's some standard way to do this -  yet another Access function
  > >> that I don't know about?  Or someone like Lebans has already done
  > >> it?  Has anyone
  > done
  > >> this before?
  > >>
  > >> MTIA
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list