[AccessD] Syntax question about control references

Arthur,

You can actually move the column to the left by using
DoCmd.RunCommand acCmdFreezeColumn.

If you have other columns that you'd like to the left
of the column with the correct date, you'll have to create
an array of controls in which you'd
SetFocus
DoCmd.RunCommand acCmdFreezeColumn
til they were in the order that you want.

(Otherwise, there are Scroll APIs that you can get
from one of Stephen Lebans creations www.lebans.com)
----

Michael R. Mattys
Mattys MapLib for Microsoft MapPoint
http://www.mattysconsulting.com



----- Original Message ----- 
From: "Arthur Fuller" <artful at rogers.com>
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Sent: Wednesday, September 08, 2004 12:31 PM
Subject: RE: [AccessD] Syntax question about control references


> Hi. No it is not set to continuous forms. (Frankly, except for very
> limited situations, I HATE continuous forms, but that's another story.)
> It's set for datasheet view. It's easy enough to set the focus to the
> desired control, but that's only half what I need. I need to scroll the
> form such that the control with focus is in the first unfrozen position.
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Michael R
> Mattys
> Sent: Tuesday, September 07, 2004 10:59 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Syntax question about control references
>
>
>
> ----- Original Message ----- 
> From: "Arthur Fuller"
>
>
> > My form has controls whose names derive from the EoM() of a given
> > date. That is, the end of a month. The control's name will be
> > something such as "12/31/2004", etc. I need to set the focus to the
> > column corresponding to today's date. For the date on which I am
> > writing this message, the correct column is named "9/30/2004".
> ...
> > The EoM() function (which I wrote) returns a date. I need to take this
>
> > value and turn it into a reference to a column, such that I can write:
> >
> > Me.columnName.SetFocus
>
> Arthur,
>
> It looks like you mean to say that you have
> a subform set to "continuous forms." If that's
> the case, you'd say
>
> Me.SubformName.Form.Controls("EOMDate").SetFocus
>
> ----
>
> Michael R. Mattys
> Mattys MapLib for Microsoft MapPoint
> http://www.mattysconsulting.com
> -- 
> _______________________________________________
> 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