Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Wed Jul 25 08:09:38 CDT 2007
Yeah, I always forget about that TAG property. I've used it before - to allow the user interrupt a long process for example by pressing a key. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darren D Sent: Tuesday, July 24, 2007 11:56 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Allow Edits Hi Rocky Glad you got it sorted In these situations where I DO want certain fields to be editable or visible - and others not I setup and interrogate the control's TAG property EG I set up the TAG to say something meaningful like "CanBeEnabled" etc Then in the relevant code I call something like this Private Sub ps_EnableSomeControls() Dim ctl as Control For each ctl in me.controls 'The whole form If ctl.TAG = "CanBeEnabled" then 'you can even set if ctl.type = XXX (EG disable all the combos etc) ctl.enabled = true 'or 'ctl.visible = true Else 'Can write an else here End if Next ctl End sub -----Original Message----- From: Rocky Smolin at Beach Access Software [mailto:rockysmolin at bchacc.com] Sent: Wednesday, 25 July 2007 12:37 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Allow Edits David: Perfect! Enter and Exit versus Click and AfterUpdate. Who knew? Thanks so much for the quick response. My bacon been saved again! Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David Emerson Sent: Tuesday, July 24, 2007 6:09 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Allow Edits Rocky, Put some code on the Enter event of the combo box to allow edits, then on the Exit event determine from the value of the combo box whether to set AllowEdits to true or false. Regards David Emerson Dalyn Software Ltd Wellington, New Zealand At 25/07/2007, you wrote: > >Problem is that the combo box isn't editable so after a name is chosen >which is NOT the current user and AllowEdits is set to False, they >can't choose another record. The combo box won't update. > >========If you're inhibiting edits, why would you want to allow one? > >Susan H. > >-- >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 No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.476 / Virus Database: 269.10.16/914 - Release Date: 7/23/2007 7:45 PM -- 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 No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.476 / Virus Database: 269.10.17/915 - Release Date: 7/24/2007 1:50 PM