Andy Lacey
andy at minstersystems.co.uk
Fri Apr 18 03:14:49 CDT 2003
That'd certainly be the case Lambert. Thanks for the tip. Strange though that fields on other forms are also being populated and the AllowEdits works for them. I'll follow this tip up though. Thanks for responding. Andy Lacey http://www.minstersystems.co.uk > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of > Heenan, Lambert > Sent: 17 April 2003 18:43 > To: 'accessd at databaseadvisors.com' > Subject: RE: [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 >> > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/a> ccessd > Website: > http://www.databaseadvisors.com > >