Opening a database with a new form
in [Getting Started]
|
Prev: Anchoring a form to the top of the form when moving from page to p
Next: Pass field value selected in Combo Box to SQL Query
From: forest8 on 6 Mar 2010 11:40 Hi I am creating a database in which when users open it, it defaults to a single form. At the moment, when they open it, it opens on a record. Is it possible to open it so that it's a new form (i.e. record) instead of a previously created record> Thank you in advance for your help.
From: Jeanette Cunningham on 6 Mar 2010 19:06 You can set the data entry property of that form to No. It will open ready to add a new record. If you want users to be able to go back to other records, you can use code in the load event to make the form go to a new record (without setting the data entry property to No). DoCmd.GoToRecord, , acNew Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia "forest8" <forest8(a)discussions.microsoft.com> wrote in message news:70B79C0E-263F-49B0-8583-AA64BC0E09D7(a)microsoft.com... > Hi > > I am creating a database in which when users open it, it defaults to a > single form. At the moment, when they open it, it opens on a record. > > Is it possible to open it so that it's a new form (i.e. record) instead of > a > previously created record> > > Thank you in advance for your help. > >
From: forest8 on 7 Mar 2010 15:51 This is exactly what I needed. Thank you "Jeanette Cunningham" wrote: > You can set the data entry property of that form to No. > It will open ready to add a new record. > > If you want users to be able to go back to other records, you can use code > in the load event to make the form go to a new record (without setting the > data entry property to No). > > DoCmd.GoToRecord, , acNew > > > Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia > > > "forest8" <forest8(a)discussions.microsoft.com> wrote in message > news:70B79C0E-263F-49B0-8583-AA64BC0E09D7(a)microsoft.com... > > Hi > > > > I am creating a database in which when users open it, it defaults to a > > single form. At the moment, when they open it, it opens on a record. > > > > Is it possible to open it so that it's a new form (i.e. record) instead of > > a > > previously created record> > > > > Thank you in advance for your help. > > > > > > > . >
From: J_Goddard via AccessMonster.com on 8 Mar 2010 16:05 Hi Jeanette - I think that should be "...set the data entry property of that form to Yes" John Jeanette Cunningham wrote: >You can set the data entry property of that form to No. >It will open ready to add a new record. > >If you want users to be able to go back to other records, you can use code >in the load event to make the form go to a new record (without setting the >data entry property to No). > >DoCmd.GoToRecord, , acNew > >Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia > >> Hi >> >[quoted text clipped - 6 lines] >> >> Thank you in advance for your help. -- John Goddard Ottawa, ON Canada jrgoddard at cyberus dot ca Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/201003/1
From: Jeanette Cunningham on 9 Mar 2010 01:23
Thanks for spotting that. ;) Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia "J_Goddard via AccessMonster.com" <u37558(a)uwe> wrote in message news:a4b7d51cbf6c4(a)uwe... > Hi Jeanette - > > I think that should be "...set the data entry property of that form to > Yes" > > John > > > > Jeanette Cunningham wrote: >>You can set the data entry property of that form to No. >>It will open ready to add a new record. >> >>If you want users to be able to go back to other records, you can use code >>in the load event to make the form go to a new record (without setting the >>data entry property to No). >> >>DoCmd.GoToRecord, , acNew >> >>Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia >> >>> Hi >>> >>[quoted text clipped - 6 lines] >>> >>> Thank you in advance for your help. > > -- > John Goddard > Ottawa, ON Canada > jrgoddard at cyberus dot ca > > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/201003/1 > |