[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