John W. Colby
jcolby at colbyconsulting.com
Mon Dec 22 11:56:58 CST 2003
Then simply use the syntax Forms!MyFormName.SomeEvent. However... if an event is passed in a value you can't do this. Better to place the code in a function, then call that function from the form's event as well as from outside the form. John W. Colby www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Charlotte Foust Sent: Monday, December 22, 2003 12:49 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Calling an event procedure The procedure you call has to be declared as public or you can't call it. Charlotte Foust -----Original Message----- From: Lonnie Johnson [mailto:prodevmg at yahoo.com] Sent: Monday, December 22, 2003 9:41 AM To: Access Developers discussion and problem solving Subject: [AccessD] Calling an event procedure I know I have done this before (at least I thought I had). I just want to call the Event Procedure of one form from another one. So if I am in Form1, I want to call the After_Update event of a text box in Form2. I thought it was Forms![Form2].TextBoxName_AfterUpdate() I'm brain dead. Thx for any help. "Steven W. Erbach" <serbach at new.rr.com> wrote: Jim, >> PCAnywhere, for all its weirdnesses does create a suede VPN << Suede?!? A little mis-typing there or is this a new, hip adjective? The host system that my client has is on a cable modem, so that's no problem. However the remotes will all be dial-up. Does this present any problems? I used PCAnywhere v. 8 quite a lot with dialup a few years ago to do remote control work on a client's system. But what you're suggesting here is a "live" replication, not indirect. My main concern with this is the number of graphi images added to the database. I've trained the users to make sure that all the graphics are converted to GIFs before being pasted into Access...but there will still be a significant number of them. This looks workable. I'm meeting with my client tomorrow morning and I will suggest it to him after eating some humble pie regarding my too-optimistic presentation of Replication as a good tool for his situation. Regards, Steve Erbach Scientific Marketing Neenah, WI 920-969-0504 Message created with Bloomba Disclaimer: No tree was killed in the transmission of this message. However, several coulombs of electrons were temporarily inconvenienced. _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==> http://www.prodev.us --------------------------------- Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing _______________________________________________ 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