Senin, 24 Oktober 2011

[MS_AccessPros] Re: Tabbing stuck on a subform

 

Thanks Justin! I'll keep that in my back pocket. May just change the form to a datasheet since this was created in the early days and I obviously was not consistent.

Connie

--- In MS_Access_Professionals@yahoogroups.com, "juiceplustim" <tritter@...> wrote:
>
>
>
>
> Connie,
> I haven't had a reason to try this, but on the subforms that are not in datasheet view there is a way to easily simulate a "tab out". After what appears on the subform as a the last field/control to tab to, add a text box and make it's width zero(0) and set it as the next tab location. In the "On Enter" event, add some code similar to this to move the focus back to somewhere on the main form, then what follows to move it on to the next subform:
>
> Private Sub SkinnyControl_Enter()
> Me.Parent!WhicheverControl.SetFocus
> 'The following lines also if you need to move on to another sub
> Me.NextSubform.SetFocus
> Me.NextSubform!FirstTabControlOnSub.SetFocus
> 'Replace WhicheverControl, NextSubform, and FirstTabControlonSub
> 'with the appropriate form and control names
> End Sub
>
> I am not a code expert, but this would seem to be a good workaround to the inconsistency Access displays here from a user perspective. I know I never have much luck with saying "just use control+tab to do that"!
> Tim Ritter
> Fort Wayne, IN
>
> --- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@> wrote:
> >
> > Connie-
> >
> > Well, I tested it in a form in Northwind, and discovered - to my amazement -
> > that a subform in Datasheet view WILL tab out to the outer form when you tab out
> > of the last field. A subform in Single Form or Continuous Form view will NOT.
> > In addition, it sounds like the subform where you are "stuck" also has its Cycle
> > property set to Current Record. That will also keep you on the current subform.
> >
> > John Viescas, author
> > Microsoft Office Access 2010 Inside Out
> > Microsoft Office Access 2007 Inside Out
> > Building Microsoft Access Applications
> > Microsoft Office Access 2003 Inside Out
> > SQL Queries for Mere Mortals
> > http://www.viescas.com/
> > (Paris, France)
> >
> >
> >
> > -----Original Message-----
> > From: MS_Access_Professionals@yahoogroups.com
> > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of mrsgoudge
> > Sent: Thursday, October 20, 2011 10:44 PM
> > To: MS_Access_Professionals@yahoogroups.com
> > Subject: Re: [MS_AccessPros] Tabbing stuck on a subform
> >
> > If this is a second similar message ignore it--thought I had sent one. Another
> > subform on the Sales form tabs through. It is a datasheet form. Why would that
> > one tab through and this one not. On that one until I enter something the *
> > stays on the left of the line rather than changing to the arrow like this one
> > does.
> >
> > Thanks,
> > Connie
> >
> > --- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@> wrote:
> > >
> > > Connie-
> > >
> > > Once you're inside a subform, you have to use Shift+Tab or Ctrl+Tab to get out
> > > of it and back onto the outer form.
> > >
> > > John Viescas, author
> > > Microsoft Office Access 2010 Inside Out
> > > Microsoft Office Access 2007 Inside Out
> > > Building Microsoft Access Applications
> > > Microsoft Office Access 2003 Inside Out
> > > SQL Queries for Mere Mortals
> > > http://www.viescas.com/
> > > (Paris, France)
> > >
> > >
> > >
> > > -----Original Message-----
> > > From: MS_Access_Professionals@yahoogroups.com
> > > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of mrsgoudge
> > > Sent: Thursday, October 20, 2011 9:57 PM
> > > To: MS_Access_Professionals@yahoogroups.com
> > > Subject: [MS_AccessPros] Tabbing stuck on a subform
> > >
> > > Hi again. I have a form "Sales" and 3 subforms on it along with the regular
> > > controls. Once I'm in the middle form, when I tab it does not go to the next
> > > subform (which is next in line in the Tab Order). When I'm on the blank line
> > > the * turns into an arrow and the cursor keeps going back an forth between the
> > > two controls. This subform is a continuous form.
> > >
> > > Thanks!
> > > Connie
>

__._,_.___
Recent Activity:
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

.

__,_._,___

Tidak ada komentar:

Posting Komentar