Stuart McLachlan
stuart at lexacorp.com.pg
Mon May 19 20:09:53 CDT 2014
> the form should work identically in the new db No. It won't work identically because the two "containers" are not identical. You had set the AppTitle in the old container at some early stage. You need to set it for the new container. > There must be some setting in the db container that's > different between the two versions The AppTitle property is the "setting" which is different. > I didn't have that code You can set properties on an Access container in two different ways: 1. Using the various Property Sheet/Wizards. 2. With VBA code. The code I gave you is how to do it in code. It is a piece of generic code which lets you set any database property (I use it to set/reseet such things as AllowByPassKey, AllowShortCutMenus etc) when I lock down an application). -- Stuart On 19 May 2014 at 17:12, Rocky Smolin wrote: > I could try that but the form should work identically in the new db as > the old, no? And I didn't have that code in the any of the previous > versions. There must be some setting in the db container that's > different between the two versions but I can't imagine what it is. > > R > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart > McLachlan Sent: Monday, May 19, 2014 4:14 PM To: Access Developers > discussion and problem solving Subject: Re: [AccessD] AppTitle > Property > > Generally, database properties in Access do not exist until they are > set for the first time. > > Set it either with the Options - Current Database (or whatever it was > in 2003 > > or in VBA with something like: > > Dim db As DAO.Database, prp As DAO.Property > Set db = CurrentDb > db.Properties(strPropName) = varPropValue > SetProperties = True > Set db = Nothing > > -- > Stuart > > On 19 May 2014 at 16:01, Rocky Smolin wrote: > > > Dear List: > > > > I had a 2003 mdb with a problem - not important what it was - had to > > do with odd mouse behavior in design view. > > > > Anyway, I imported all the objects into a blank mdb and everything > > works better except: > > > > lblVersion.Caption = "Version " & > > Right(CurrentDb.Properties("AppTitle"), _ > > Len(CurrentDb.Properties("AppTitle")) - 46) > > > > works perfectly in the previous version and all versions of this app > > going back to day 1. > > > > In this new one it throws the error 3270 - Property Not Found. > > > > Checked the references - identical between the two mdbs. > > > > Any idea what to look for next? > > > > MTIA > > > > Rocky > > > > -- > > 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 > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >