[AccessD] Freeze panes

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


How do you keep the two lists synchronized?

Rocky
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Steele
Sent: Saturday, February 18, 2012 9:27 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Freeze panes

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<http://database
> advisors.com/mailman/listinfo/accessd>
> Website: 
> http://www.databaseadvisors.**com<http://www.databaseadvisors.com>
>
--
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