[AccessD] AllowEdits

In the past I have found that if AllowEdits is set (at runtime) AFTER any
field on the form in question has been changed, then editing remains
possible. Check for things like Date fields getting automatically populated.

Lambert

> -----Original Message-----
> From:	Andy Lacey [SMTP:andy at minstersystems.co.uk]
> Sent:	Thursday, April 17, 2003 12:26 PM
> To:	accessd at databaseadvisors.com
> Subject:	[AccessD] AllowEdits
> 
> I've a form with a number of subforms. In certain circumstances I want the
> whole lot to be read-only. So I set the form and all subforms to
> AllowEdits=False. Works fine EXCEPT on one of the subforms which continues
> to allow changes. Debug shows its AllowEdits is False but I can edit it.
> Any ideas why?
> 
> --
> Andy Lacey
> http://www.minstersystems.co.uk
> 
> 
> 
> 
> 
> 	--------- Original Message --------
> 	From: "Gary Kjos" <garykjos at hotmail.com>
> 	To: "accessd at databaseadvisors.com" <accessd at databaseadvisors.com>
> 	Subject: Re: [AccessD] Oracle into Access
> 	Date: 17/04/03 13:23
> 	
> 	
> 	Hi Mike,
> 	
> 	Not entirely clear on what a "Custome Package" is in Oracle. But I
> use
> 	Access front ends to Oracle databases every day, primarily using
> ODBC Linked
> 	tables. I have a couple applications that I use pass-through
> queries. With a
> 	pass-through query you create an Oracle SQL statment and it is then
> sent
> 	directly to Oracle without interpretation by Access. This allows you
> to do
> 	anything you could do using another SQL to Oracle interface,
> including
> 	calling Oracle Stored Procedures or custom functions. So I think the
> answer
> 	to your question is YES.
> 	
> 	Have a look in the Access help on "Pass-Through Query" and perhaps
> it will
> 	get you started.
> 	
> 	Gary Kjos
> 	garykjos at hotmail.com <mailto:garykjos at hotmail.com>
> 	
> 	
> 	
> 	
> 	
> 	>From: "Gowey Mike W" <Mike.W.Gowey at doc.state.or.us>
> 	>Reply-To: accessd at databaseadvisors.com
> <mailto:accessd at databaseadvisors.com>
> 	>To: <accessd at databaseadvisors.com>
> 	>Subject: [AccessD] Oracle into Access
> 	>Date: Wed, 16 Apr 2003 09:59:33 -0600
> 	>
> 	>
> 	>Hi Everyone,
> 	>
> 	>Has anyone know if it is possible to call a custome package from
> Oracle
> 	>and run it in Access? Is this possible?
> 	>
> 	>Thanks,
> 	>
> 	>Mike Gowey, MCP
> 	>Technical Support Analyst
> 	>SRCI ISSD Team Leader
> 	>
> 	>_______________________________________________
> 	>AccessD mailing list
> 	>AccessD at databaseadvisors.com
> 	>http://databaseadvisors.com/mailman/listinfo/accessd
> 	>Website: <http://www.databaseadvisors.com/>
> 	
> 	
> 	_________________________________________________________________
> 	Help STOP SPAM with the new MSN 8 and get 2 months FREE*
> 	<http://join.msn.com/?page=features/junkmail>
> 	
> 	_______________________________________________
> 	AccessD mailing list
> 	AccessD at databaseadvisors.com <mailto:AccessD at databaseadvisors.com>
> 	<http://databaseadvisors.com/mailman/listinfo/accessd>
> 	Website: <http://www.databaseadvisors.com/>
> 	
> 	
> 	
> 	
> 	
>  << File: ATT10829531.txt >>