[AccessD] Freeze panes

I still do all of my primary development in A2003.  It works for me.

I've tried it on a main form, a subform and a form embedded in a tab control and it works 
everytime in the On_Open.

Are you sure the Default View of the form is Datasheet.  You will get that error if it is set to 
anything else.


-- 
Stuart

On 19 Feb 2012 at 13:42, Rocky Smolin wrote:

> I get an error - that command is not available now.  I'm putting it in the
> _Open event but go the same problem in the _Load event.   But I'm using
> A2003.  
> 
> Any idea why it won't let me run that command?
> 
> TIA
> 
> Rocky
> 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Simms
> Sent: Sunday, February 19, 2012 10:08 AM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Freeze panes
> 
> Thanks for that Stuart. That command never worked for me....Now I see why !!
> I didn't SETFOCUS !!
> > companyname.SetFocus
> > DoCmd.RunCommand acCmdFreezeColumn
> 
> 
> --
> 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
>