Darrell Burns
dhb at flsi.com
Tue May 17 19:55:07 CDT 2011
Thanx to everybody for replying. I'm just responding to the most recent post. I have an Attachment control on a form. The control is named Asset_Attachment. I want the built-in Attachment dialog box to spring open as soon as I open the form. The only way I know to make that dialog appear is by dbl-clicking Asset_Attachment. I tried inserting Asset_Attachment_DblClick (-1) in the Form_Open event but I got a "Sub or function not defined" compile error. Is there a way to send those mouse-clicks to the control? Thx, Darrell -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Tuesday, May 17, 2011 2:41 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Force a dblclick event on a form control I don't think you can directly make an event stub public. You would have to build a public sub which called the event stub. John W. Colby www.ColbyConsulting.com On 5/17/2011 5:37 PM, Doug Murphy wrote: > Maybe I didn't read your question correctly. Do you want to trigger from > code or on the actual event? If from code, just put your code in the event > stub and then call it from where ever you want by the subroutine name, e.g., > sub controlName_dblClick. If your calling from outside the form you need to > make the subroutine public. > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darrell Burns > Sent: Tuesday, May 17, 2011 1:14 PM > To: 'Access Developers discussion and problem solving' > Subject: [AccessD] Force a dblclick event on a form control > > Anybody know how I could trigger a dbl-click event on a form control? > Thx, > -Darrell > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com