John B.
john at winhaven.net
Wed Sep 17 10:47:51 CDT 2003
A custom shortcut menu. You were right :o) > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Charlotte > Foust > Sent: Wednesday, September 17, 2003 10:23 AM > To: Access Developers discussion and problem solving > Subject: RE: [AccessD] Lose Focus > > > John, > > Is this a custom shortcut menu or the built in context menu for the > form/subform? I assumed you were using a custom shortcut menu. > > Charlotte Foust > > -----Original Message----- > From: John B. [mailto:john at winhaven.net] > Sent: Tuesday, September 16, 2003 9:00 AM > To: Access Developers discussion and problem solving > Subject: RE: [AccessD] Lose Focus > > > I've been reading up on this and ADH recommends not using ActiveForm. > > Maybe I'm overthinking this and missing something obvious but I'm > definitely missing something :o) > > Can someone tell me how to save the record of the calling form when I > can't pass the Me object to the function because it's being called from > a shortcut menu? > > > -----Original Message----- > > From: accessd-bounces at databaseadvisors.com > > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of John B. > > Sent: Monday, September 15, 2003 5:41 PM > > To: Access Developers discussion and problem solving > > Subject: RE: [AccessD] Lose Focus > > > > > > Charlotte: > > That's what I'm experiencing. I have a function that is called by > > shortcut menu from a number of different forms. The record needs to be > > > saved before it will work correctly. I could save the record > > automatically in the after_update event but this would be saving the > > record after each update for something that rarely occurrs. > > > > The only time this is an issue is if someone adds a new row (this is a > > > continuos form) and then uses the shortcut function immediately. Of > > course a client just called and noted this. Click on another row first > > > is the immediate work around but not real obvious to them. > > > > I'm thinking I should be able to use ActiveForm to perform a > > SaveRecord when the shortcut menu calls the function. Any help on that > > > idea would be welcome. > > > > John B. > > > > > -----Original Message----- > > > From: accessd-bounces at databaseadvisors.com > > > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Charlotte > > > Foust > > > Sent: Monday, September 15, 2003 5:30 PM > > > To: Access Developers discussion and problem solving > > > Subject: RE: [AccessD] Lose Focus > > > > > > > > > Sort of. The exit event of the form doesn't occur, so context menu > > > won't automatically trigger a save of the current record. > > > > > > Charlotte Foust > > > > > > -----Original Message----- > > > From: Drew Wutka [mailto:DWUTKA at marlow.com] > > > Sent: Monday, September 15, 2003 2:12 PM > > > To: 'Access Developers discussion and problem solving' > > > Subject: RE: [AccessD] Lose Focus > > > > > > > > > It should because the popup menu would have the focus. > > > > > > Drew > > > > > > -----Original Message----- > > > From: John B. [mailto:john at winhaven.net] > > > Sent: Monday, September 15, 2003 4:57 PM > > > To: AccessD > > > Subject: [AccessD] Lose Focus > > > > > > > > > Does the Lose Focus event fire when then shortcut menu is popped up? > > > > > > John B. > > > > > > _______________________________________________ > > > 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 > > > _______________________________________________ > > > 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 > > > > > > > _______________________________________________ > 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 > >