Kamis, 26 Juni 2014

Re: [MS_AccessPros] event on subform datasheet view

 

Liz-


The simple answer is no.  Even though you see a Datasheet, Access handles only one row at a time.  The rows other than the current row that you see on the screen are simply painted on the screen by Access - they're not real records until you move the focus there.  Access on a form has no concept of a "set" of records - it's one at a time, and you get After Update for each one.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
SQL Queries for Mere Mortals 
(Paris, France)




On Jun 26, 2014, at 4:37 PM, Liz Ravenwood liz_ravenwood@beaerospace.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Pros,  I'm wanting to run code that happens after an update on a subform, but the subform is in datasheet view and I don't want the event to fire after each individual item, but after the set.

 

Is there an event or a clever way to run a piece of code just once after the set has been messed with?

 

Respectfully,

Liz Ravenwood

Programmer / Analyst

B/E Aerospace | Super First Class Environments

 

1851 S Pantano Road | Tucson, Arizona 85710

Office +1.520.239.4808 |

beaerospace.com

Passion to Innovate. Power to Deliver

 


This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

__._,_.___

Posted by: John Viescas <johnv@msn.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)

.

__,_._,___

Tidak ada komentar:

Posting Komentar