on last enter start new blank form
in [General]
|
From: KenSheridan via AccessMonster.com on 19 Mar 2010 18:53 Sounds like you might have entered the code directly in the properties sheet, not in the event procedure. To enter code in an event procedure you select the event property in the properties sheet, click the 'build' button (the one with the three dots), select 'code builder', then enter the code in the VBA window which opens. Ken Sheridan Stafford, England JMD.Park wrote: >Receive error "can't find the object 'DoCmd'" > >> In the AfterUpdate event procedure of the control in question put the >> following code: >[quoted text clipped - 22 lines] >> >> >> >> . -- Message posted via http://www.accessmonster.com
From: JMD.Park on 24 Mar 2010 10:27 Tried in event procedure still not recognising docmd. "KenSheridan via AccessMonster.com" wrote: > Sounds like you might have entered the code directly in the properties sheet, > not in the event procedure. To enter code in an event procedure you select > the event property in the properties sheet, click the 'build' button (the one > with the three dots), select 'code builder', then enter the code in the VBA > window which opens. > > Ken Sheridan > Stafford, England > > JMD.Park wrote: > >Receive error "can't find the object 'DoCmd'" > > > >> In the AfterUpdate event procedure of the control in question put the > >> following code: > >[quoted text clipped - 22 lines] > >> >> > >> >> . > > -- > Message posted via http://www.accessmonster.com > > . >
From: JMD.Park on 24 Mar 2010 10:28 I think I will stick with the second option. Thanks. "John W. Vinson" wrote: > On Fri, 19 Mar 2010 13:55:02 -0700, JMD.Park > <JMDPark(a)discussions.microsoft.com> wrote: > > >Is working now, have to tab through buttons. Thanks! > > > > aha!!! > > You can set the Tab Stop proprety of a control to No if you want to avoid this > hassle. On the other hand, it's often helpful to have buttons in the tab > sequence - you can click the button by tabbing to it and pressing the > spacebar, and never need to touch the mouse at all. > -- > > John W. Vinson [MVP] > . >
From: KenSheridan via AccessMonster.com on 24 Mar 2010 11:46 Check that you have no missing or broken references. Ken Sheridan Stafford, England JMD.Park wrote: >I am using tab, and the cycle control is set to all records. Still doesn't >work. > >> >is there a way to have a new blank form start after entering last input of >> >information? Thanks in advance for the help! >[quoted text clipped - 6 lines] >> If you're using the mouse exclusively, then Access may not have any way to >> know when you're done. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access/201003/1
From: JMD.Park on 30 Mar 2010 08:36
Changed tab stop to no. Thanks to everyone for help "KenSheridan via AccessMonster.com" wrote: > Check that you have no missing or broken references. > > Ken Sheridan > Stafford, England > > JMD.Park wrote: > >I am using tab, and the cycle control is set to all records. Still doesn't > >work. > > > >> >is there a way to have a new blank form start after entering last input of > >> >information? Thanks in advance for the help! > >[quoted text clipped - 6 lines] > >> If you're using the mouse exclusively, then Access may not have any way to > >> know when you're done. > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access/201003/1 > > . > |