(Msg. 1) Posted: Thu Oct 01, 2009 9:32 pm
Post subject: How to force last row to be saved? Archived from groups: microsoft>public>access>gettingstarted (more info?)
I have a form of multiple rows (grades for different periods in the day).
When the Finish button is clicked, a subroutine deletes all the rows that
were created for a student if no scores were entered. My problem is that
the data in the last row the user worked on is not saved before that
subroutine is called. How can I force the save?
(Msg. 2) Posted: Thu Oct 01, 2009 10:08 pm
Post subject: Re: How to force last row to be saved? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Make this the first line of code before you begin deleting records:
"Laurel" <FakeMail DeleteThis @Hotmail.com> wrote in message
news:OUPNl$vQKHA.4244@TK2MSFTNGP06.phx.gbl...
>I have a form of multiple rows (grades for different periods in the day).
>When the Finish button is clicked, a subroutine deletes all the rows that
>were created for a student if no scores were entered. My problem is that
>the data in the last row the user worked on is not saved before that
>subroutine is called. How can I force the save?
>
> TIA
> LAS
>
(Msg. 3) Posted: Fri Oct 02, 2009 11:25 am
Post subject: Re: How to force last row to be saved? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Thanks!
Works like a charm!
"Ken Snell" <kthsneisllis9.RemoveThis@ncoomcastt.renaetl> wrote in message
news:%23A5$EVwQKHA.4028@TK2MSFTNGP05.phx.gbl...
> Make this the first line of code before you begin deleting records:
>
> Me.Dirty = False
>
> --
>
> Ken Snell
> http://www.accessmvp.com/KDSnell/ >
>
> "Laurel" <FakeMail.RemoveThis@Hotmail.com> wrote in message
> news:OUPNl$vQKHA.4244@TK2MSFTNGP06.phx.gbl...
>>I have a form of multiple rows (grades for different periods in the day).
>>When the Finish button is clicked, a subroutine deletes all the rows that
>>were created for a student if no scores were entered. My problem is that
>>the data in the last row the user worked on is not saved before that
>>subroutine is called. How can I force the save?
>>
>> TIA
>> LAS
>>
>
>
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office Other