[AccessD] Freeze panes

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


Really?  Exactly what I was looking for.

Thank you.

Rocky

P.S.  This list isn't as useful to me as it used to be.  You all used to
save my bacon 5 times a day.  I'd say now not more than once a day. :)
 

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

Set the  display mode to  Datasheet mode.
Select the columns, shift+ right click and select "Freeze columns"
Save the Form.

If you want to make sure it is always that way:

Private Sub Form_Load()
personname.SetFocus
DoCmd.RunCommand acCmdFreezeColumn
companyname.SetFocus
DoCmd.RunCommand acCmdFreezeColumn
End Sub

--
Stuart

On 18 Feb 2012 at 8:49, Rocky Smolin wrote:

> 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
>  
> Rocky Smolin
> Beach Access Software
> 858-259-4334
> www.bchacc.com <http://www.bchacc.com/> www.e-z-mrp.com 
> <http://www.e-z-mrp.com/>
> Skype: rocky.smolin
>  
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: 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