[AccessD] AppTitle Property

I couldn't use the code snip because SetProperties is not defined and I
didn't know what value to give varPropValue.

However, I just worked around the problem.  I opened a previous version of
the app, in which the AppTitle code was working, deleted all the objects,
imported from the version where it wasn't working, and not it works.

So your theory and Stuart's would seem to be correct - the property didn't
exist in the newly created mdb.  But I use that line of code in a LOT of
apps - I put the version and date in the Application Title and display it on
the opening form.  Never had to define it before. 

Another Access mystery.

Tks.

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Monday, May 19, 2014 11:10 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] AppTitle Property

Hi Rocky

Yes it will. But that doesn't help if the property doesn't exist.
Did you set the app title as Stuart suggested?

/gustav

-----Oprindelig meddelelse-----
Fra: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] På vegne af Rocky Smolin
Sendt: 20. maj 2014 02:12
Til: 'Access Developers discussion and problem solving'
Emne: Re: [AccessD] AppTitle Property

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