DataSheet Sumary
in [Forms]
|
Prev: colours in the fomrs
Next: Repeat afterupdate code
From: mie via AccessMonster.com on 13 May 2010 22:01 Access 2007. I used that syntax in my applications. Have you heard anywhere that style will give problems in future? i have application with >12000 line of codes. if that style will give me trouble, better careful next time. Your opinion much appreciated.. Douglas J. Steele wrote: >What version of Access? Older versions let you be sloppy with the syntax: >Access 2007 (and presumably Access 2010) is much fussier, so using the >correct syntax is always a good idea. > >Is there a particular reason why you don't want to use the correct syntax? > >>i did simple test, both gave the same results.. >> >[quoted text clipped - 5 lines] >>>>>>> >>>>>>> . -- Message posted via http://www.accessmonster.com
From: Cesarini on 13 May 2010 23:56 Hi Againg guys, I´ve tried both ways, and they are giving me the "#Error" text instead of the sumary amount. As I said, the error message gets off and It shows the right amount after I click in the "+" sign of the DataSheet. Please I need to solve this. I have made tests too without sucess. :-( I do not understand why the error comes up if I click directly in the forms name in the Access toolbar. If I click in the view option in design mode, the error disapear and the sumary is shown. Many thanks for yours feedbacks Regards -- ------------------ César Parrales "Douglas J. Steele" wrote: > What version of Access? Older versions let you be sloppy with the syntax: > Access 2007 (and presumably Access 2010) is much fussier, so using the > correct syntax is always a good idea. > > Is there a particular reason why you don't want to use the correct syntax? > > -- > Doug Steele, Microsoft Access MVP > http://www.AccessMVP.com/DJSteele > (no e-mails, please!) > > "mie via AccessMonster.com" <u58255(a)uwe> wrote in message > news:a7f15626ecb54(a)uwe... > >i did simple test, both gave the same results.. > > > > Douglas J. Steele wrote: > >>Why would you? The former is the correct syntax. > >> > >>> Arvin , can we change the code > >>> > >>[quoted text clipped - 12 lines] > >>>>>> > >>>>>> . > > > > -- > > Message posted via AccessMonster.com > > http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201005/1 > > > > > . >
From: Douglas J. Steele on 14 May 2010 06:56 My advice would be to correct it now before you add more lines of code. As I've said, each version of Access has introduced stricter implementation of syntax checking, so it's always possible that sloppy syntax may work now, but not later. -- Doug Steele, Microsoft Access MVP http://www.AccessMVP.com/djsteele (no e-mails, please!) "mie via AccessMonster.com" <u58255(a)uwe> wrote in message news:a7f8395278bce(a)uwe... > Access 2007. I used that syntax in my applications. Have you heard > anywhere > that style will give problems in future? > > i have application with >12000 line of codes. if that style will give me > trouble, better careful next time. > Your opinion much appreciated.. > > Douglas J. Steele wrote: >>What version of Access? Older versions let you be sloppy with the syntax: >>Access 2007 (and presumably Access 2010) is much fussier, so using the >>correct syntax is always a good idea. >> >>Is there a particular reason why you don't want to use the correct syntax? >> >>>i did simple test, both gave the same results.. >>> >>[quoted text clipped - 5 lines] >>>>>>>> >>>>>>>> . > > -- > Message posted via http://www.accessmonster.com >
From: Cesarini on 15 May 2010 13:53 Help would be helpful Thanks, -- ------------------ César Parrales "Douglas J. Steele" wrote: > My advice would be to correct it now before you add more lines of code. > > As I've said, each version of Access has introduced stricter implementation > of syntax checking, so it's always possible that sloppy syntax may work now, > but not later. > > -- > Doug Steele, Microsoft Access MVP > http://www.AccessMVP.com/djsteele > (no e-mails, please!) > > > > "mie via AccessMonster.com" <u58255(a)uwe> wrote in message > news:a7f8395278bce(a)uwe... > > Access 2007. I used that syntax in my applications. Have you heard > > anywhere > > that style will give problems in future? > > > > i have application with >12000 line of codes. if that style will give me > > trouble, better careful next time. > > Your opinion much appreciated.. > > > > Douglas J. Steele wrote: > >>What version of Access? Older versions let you be sloppy with the syntax: > >>Access 2007 (and presumably Access 2010) is much fussier, so using the > >>correct syntax is always a good idea. > >> > >>Is there a particular reason why you don't want to use the correct syntax? > >> > >>>i did simple test, both gave the same results.. > >>> > >>[quoted text clipped - 5 lines] > >>>>>>>> > >>>>>>>> . > > > > -- > > Message posted via http://www.accessmonster.com > > > > . >
From: mie via AccessMonster.com on 16 May 2010 05:29
Cesarini wrote: >Hi Againg guys, > >I´ve tried both ways, and they are giving me the "#Error" text instead of >the sumary amount. > >As I said, the error message gets off and It shows the right amount after I >click in the "+" sign of the DataSheet. As far as i know, the only ways you can have "+" sign in "datasheet view" when you used "Table " as Source Object, and by " summary amount", do you mean "Totals"? If that the case, the syntax Arvin suggested will not worked... > >Please I need to solve this. I have made tests too without sucess. :-( > >I do not understand why the error comes up if I click directly in the forms >name in the Access toolbar. If I click in the view option in design mode, the >error disapear and the sumary is shown. > >Many thanks for yours feedbacks > >Regards > > -- >------------------ >César Parrales > >> What version of Access? Older versions let you be sloppy with the syntax: >> Access 2007 (and presumably Access 2010) is much fussier, so using the >[quoted text clipped - 13 lines] >> >> . -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201005/1 |