Sad Der
accessd666 at yahoo.com
Mon Oct 27 06:29:47 CST 2003
thnx everybody. A lot of answers with different solutions to the problem. Two subforms will work but I I'll go for the idea of Reuben, very nifty :-) Regards, Sander --- Rocky Smolin - Beach Access Software <bchacc at san.rr.com> wrote: > How about two subforms - one on the top of the form > where you only enter new > records, one on the bottom with all the current > records and no additions > allowed. In the After Update event of the top > subform, requery the bottom > subform. > > Rocky > > ----- Original Message ----- > From: "Charlotte Foust" <cfoust at infostatsystems.com> > To: "Access Developers discussion and problem > solving" > <accessd at databaseadvisors.com> > Sent: Friday, October 24, 2003 5:42 PM > Subject: RE: [AccessD] Subform => New Record first? > > > > It's the only way to get the "new record" at the > top of a continuous > > form, and it has the advantage of allowing for an > "undo" easily. > > > > Charlotte Foust > > > > -----Original Message----- > > From: Kath Pelletti > [mailto:SDSSoftware at optusnet.com.au] > > Sent: Friday, October 24, 2003 4:22 PM > > To: Access Developers discussion and problem > solving > > Subject: Re: [AccessD] Subform => New Record > first? > > > > > > Very clever. I like it > > ----- Original Message ----- > > From: Reuben Cummings > > To: Access Developers discussion and problem > solving > > Sent: Saturday, October 25, 2003 1:07 AM > > Subject: RE: [AccessD] Subform => New Record > first? > > > > > > Something I have done on several occasions to > handle this very thing > > is to > > basically ignore the subform as the solution, > but rather put unbound > > fields > > on the main form directly above the fields of > the subform. > > > > If you do not have the subform sunken you can't > hardly tell they are > > not in > > the subform (I usually leave mine sunken > though). > > > > The user inputs the new data into the unbound > fields of the main form, > > clicks an add button. You validate the data, > write the data to the > > table > > and requery the subform. And if that record > needs to be at the top > > then > > just set the sort order accordingly. > > > > Reuben Cummings > > GFC, LLC > > phone: 812.523.1017 > > email: reuben at gfconsultants.com > > > > > -----Original Message----- > > > From: accessd-bounces at databaseadvisors.com > > > > [mailto:accessd-bounces at databaseadvisors.com]On > Behalf Of Andy Lacey > > > Sent: Friday, October 24, 2003 9:00 AM > > > To: Access Developers discussion and problem > solving > > > Subject: Re: [AccessD] Subform => New Record > first? > > > > > > > > > Sander > > > I know what you mean. My users often don't > like this either. The > > answer to > > > your question is no (I think) but a workaround > is to place a > > > command button > > > in the header called "Add New Record" or > whatever and behind there > > put: > > > > > > DoCmd.GoToRecord , , acNewRec > > > > > > It still goes to the bottom of the list but at > least the user > > doesn't have > > > to scroll down. > > > > > > There is another technique which may work but > depends on your data > > to an > > > extent. If, say, the data your subform is > bound to has a date > > > created field, > > > and if your user is happy to see the data in > desc order of date (ie > > newest > > > at the top), then you can do the following: > > > > > > DoCmd.GoToRecord , , acNewRec > > > me!DateField=Now() > > > me.requery > > > > > > This will add the new record with the latest > date then the > > > requery will sort > > > it to the top. Doesn't always suit, but can > sometimes be effective. > > > > > > -- > > > Andy Lacey > > > http://www.minstersystems.co.uk > > > > > > > > > > > > > > > --------- Original Message -------- > > > From: "Access Developers discussion and > problem solving" > > > <accessd at databaseadvisors.com> > > > To: "Acces User Group" > <accessd at databaseadvisors.com> > > > Subject: [AccessD] Subform => New Record > first? > > > Date: 24/10/03 13:37 > > > > > > > > > Hi group, > > > > > > I've got a subform. When I scroll through the > records > > > it is possible to add a record. However I > first have > > > to tab through all records (or use the > scrollbar). > > > > > > Is it possible to have the new line (to insert > a new > > > record) appear on top (as the first line)? > > > > > > So you see an empty line and below it are all > > > detailrecords. > > > > > > Hope this makes sence. > > > > > > TIA > > > > > > SD > > > > > > __________________________________ > > > Do you Yahoo!? > > > The New Yahoo! Shopping - with improved > product search > > > http://shopping.yahoo.com > > > > _______________________________________________ > > > AccessD mailing list > > > AccessD at databaseadvisors.com > > > > http://databaseadvisors.com/mailman/listinfo/accessd > > > Website: http://www.databaseadvisors.com > > > > > > > ________________________________________________ > > > Message sent using UebiMiau 2.7.2 > > > > > > > _______________________________________________ > > > 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 > === message truncated === __________________________________ Do you Yahoo!? Exclusive Video Premiere - Britney Spears http://launch.yahoo.com/promos/britneyspears/