Results 1 to 12 of 12
  1. #1
    Lounger
    Join Date
    Apr 2001
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Clear AppTitle Property in Startup Options (A2k Sr1)

    Can the "AppTitle" property be reset to Nothing using VBA?

    Sample code that won't work:

    Function SetandClearAppTitle()

    Dim Dbs As Object

    Set Dbs = CurrentDb.Properties

    Dbs("AppTitle").Value = "MyApplication"

    Debug.Print Dbs("AppTitle").Value

    Dbs("AppTitle").Value = Nothing ' *** Has no effect

    Debug.Print Dbs("AppTitle").Value

    End Function


    Thanks

  2. #2
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Clear AppTitle Property in Startup Options (A2k Sr1)

    Try using a single space.... " " <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Clear AppTitle Property in Startup Options (A2k Sr1)

    Ordinarily, you reset the Apptitle to the default "Microsoft Access" rather than nothing.
    Charlotte

  4. #4
    Lounger
    Join Date
    Apr 2001
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Clear AppTitle Property in Startup Options (A2k Sr1)

    I've successfully changed the AppTitle to a single space but that is not the best solution. Is there a way to remove the AppTitle property from the database's collection so that it reverts to the default?

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Clear AppTitle Property in Startup Options (A2k Sr1)

    The default is "Microsoft Access". If that's what you're trying to change it back to, just set the AppTitle to that string. Or were you trying to set it to something else?
    Charlotte

  6. #6
    Lounger
    Join Date
    Apr 2001
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Clear AppTitle Property in Startup Options (A2k Sr1)

    What I'm trying to accomplish is to completely remove any text in the Tools==>Startup AppTitle box, like it is on a new database. The same would apply if there was an AppIcon set and I wanted to reset it to nothing or I wanted to clear all the summary info on the File==>Database Properties ==>Summary Tab.

    On a New database these properties do Not exist in the collections until they are set. This is why I'm thinking that I need to remove or delete the property from the collection to clear it.

    I'm probably wrong, that's why I'm asking the pros.

  7. #7
    Lounger
    Join Date
    Apr 2001
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Clear AppTitle Property in Startup Options (A2k Sr1)

    Charlotte,

    I found that I cannot force the AppTitle back to it's original value any other way than setting it to "Microsoft Access" Ref A2k Dev Handbook Vol 1 Pg 1453. The warning at the top of the page.

    I guess this is what you have been trying to tell me all along. I just needed to know that there is no way to remove it completely (with VBA) like the Access User interface does in the Startup dialog box.

    Thanks

  8. #8
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Clear AppTitle Property in Startup Options (A2k Sr1)

    Actually, I think you're misinterpreting the startup dialog. The reason AppTitle is null there is because you haven't given it anything different to use. In that case, it defaults to "Microsoft Access", which is the built-in app title.
    Charlotte

  9. #9
    Lounger
    Join Date
    Apr 2001
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Clear AppTitle Property in Startup Options (A2k Sr1)

    Thanks

    I got the picture. The only thing I'm missing then is the Built-in AppIcon value. Would you happen to know what it is or can you point me to the reference?

  10. #10
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Clear AppTitle Property in Startup Options (A2k Sr1)

    As far as I know, the built-in icon is whatever is in the Msaccess.exe file.
    Charlotte

  11. #11
    Lounger
    Join Date
    Apr 2001
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Clear AppTitle Property in Startup Options (A2k Sr1)

    I was afraid of that. Well, Mark J's solution of setting a single space seems to work with no detrimental effects so far.

    Thanks for all your help

    Maybe I should open the actual dialog boxes using
    DoCmd.RunCommand acCmdStartupProperties
    Wish me luck with opening the dialog on a remote database.

  12. #12
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Clear AppTitle Property in Startup Options (A2k Sr1)

    May the Lounge be with you! <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •