Beach Access Software
bchacc at san.rr.com
Fri Jan 5 15:32:17 CST 2007
THAT'S CHEATING! (I use that to automate Excel - record a macro in Excel then crib the code out of Excel and paste it into my module.) Rocky Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of rusty.hammond at cpiqpc.com Sent: Friday, January 05, 2007 9:33 AM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Syntax for Allow Edits Subform Rocky, Me either, so what I do is open the form in design view, create a temporary macro, choose SetValue in the Action column, then in the Item property I click the expression builder and use that to choose the control I'm trying to reference. That gives me the syntax I need to use. HTH Rusty -----Original Message----- From: Beach Access Software [mailto:bchacc at san.rr.com] Sent: Friday, January 05, 2007 11:07 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Syntax for Allow Edits Subform Rusty: That worked. Thank you. (I'll never get that syntax!!) Rocky Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of rusty.hammond at cpiqpc.com Sent: Friday, January 05, 2007 8:47 AM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Syntax for Allow Edits Subform Rocky, Try taking the s off the end of forms ie: Me.subfrmBundleVerification.Form.AllowEdits = False That's the only thing I can see different from what I have in a working app (A97) Rusty -----Original Message----- From: Beach Access Software [mailto:bchacc at san.rr.com] Sent: Friday, January 05, 2007 10:37 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Syntax for Allow Edits Subform Dear List: I need to set Allow Edits to false on a subform. Both Me.subfrmBundleVerification.AllowEdits = False and Me.subfrmBundleVerification.Forms.AllowEdits = False fail. What is the correct syntax? MTIA Rocky Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ********************************************************************** WARNING: All e-mail sent to and from this address will be received, scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc. corporate e-mail system and is subject to archival, monitoring or review by, and/or disclosure to, someone other than the recipient. ********************************************************************** -- 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.432 / Virus Database: 268.16.5/616 - Release Date: 1/4/2007 1:34 PM -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ********************************************************************** WARNING: All e-mail sent to and from this address will be received, scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc. corporate e-mail system and is subject to archival, monitoring or review by, and/or disclosure to, someone other than the recipient. ********************************************************************** -- 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.432 / Virus Database: 268.16.5/616 - Release Date: 1/4/2007 1:34 PM