paul.hartland at fsmail.net
paul.hartland at fsmail.net
Thu Jul 15 08:11:17 CDT 2004
thanks, I owe you one.....can't believe I never thought of that... Paul Message date : Jul 15 2004, 02:06 PM >From : "Joe Rojas" To : "'Access Developers discussion and problem solving'" Copy to : Subject : RE: [AccessD] OT-Call Click Routine From Form Behind I believe it is because the OptUpdateAvailability_Click is private. Private Subs are not visible to other forms and may only be called from the form that "owns" the sub. Try making Public sub on the Personnel form that only calls the OptUpdateAvailability_Click sub. Public Sub UpdateAvailability() OptUpdateAvailability_Click() End Sub JR -----Original Message----- From: paul.hartland at fsmail.net [mailto:paul.hartland at fsmail.net] Sent: Thursday, July 15, 2004 8:40 AM To: accessd Subject: [AccessD] OT-Call Click Routine From Form Behind To all, Visual Basic 6 question, I have a personnel form with the option to block assign their availability for certain days, which is another form which opens in front of the personnel form. I have a menu on the personnel form which includes and update option, which in turn has a click routince Private Sub OptUpdateAvailability_Click(). On the form which appears in front of the personnel form I have a button, when the button is pressed I want to call the OptUpdateAvailability_Click() rountine. I have tried Call frmOrrPersonnel.OptUpdateAvailability_Click but get the following error when I try a compile: Method or Data Member Not Found Anyone any ideas how I can cal the routine ? Thanks in advance for any help. Paul Hartland -- Whatever you Wanadoo: http://www.wanadoo.co.uk/time/ This email has been checked for most known viruses - find out more at: http://www.wanadoo.co.uk/help/id/7098.htm -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com This electronic transmission is strictly confidential to TNCO, Inc. and intended solely for the addressee. It may contain information which is covered by legal, professional, or other privileges. If you are not the intended addressee, or someone authorized by the intended addressee to receive transmissions on behalf of the addressee, you must not retain, disclose in any form, copy, or take any action in reliance on this transmission. If you have received this transmission in error, please notify the sender as soon as possible and destroy this message. While TNCO, Inc. uses virus protection, the recipient should check this email and any attachments for the presence of viruses. TNCO, Inc. accepts no liability for any damage caused by any virus transmitted by this email. -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- Whatever you Wanadoo: http://www.wanadoo.co.uk/time/ This email has been checked for most known viruses - find out more at: http://www.wanadoo.co.uk/help/id/7098.htm