Results 1 to 4 of 4
  1. #1
    BruceUK is offline Advanced Beginner
    Windows 7 64bit Access 2003
    Join Date
    Sep 2011
    Posts
    48

    Access doesn't update application name for compiling VB code!

    Hi everyone,



    I'm using Access 2003. I wanted to create a significantly modified version of an existing application so I copied the .mdb file to another name (e.g. Name1.mdb is copied to Name2.mdb). However, I've noticed a strange quirk. When I re-compile VBA code in the new Name2 application, the Compile menu option is still being displayed as "Compile Name1.mdb".

    No harm seems to be done because of this, but it does seem weird. Is this a known "bug" in Access?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,624
    Should not be bug. There is a property for the project called Application Title. I suspect it was set in the original with the file name. Change it for the copy. I usually assign a name that does not include the mdb/accdb extension.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    BruceUK is offline Advanced Beginner
    Windows 7 64bit Access 2003
    Join Date
    Sep 2011
    Posts
    48
    Quote Originally Posted by June7 View Post
    Should not be bug. There is a property for the project called Application Title. I suspect it was set in the original with the file name. Change it for the copy. I usually assign a name that does not include the mdb/accdb extension.
    I don't think this is relevant. The Application Title only determines the title shown in the application window. Resetting it doesn't change the application name displayed in the Debug|Compile menu option when VBA code is to be re-compiled.

    Any other thoughts?

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,624
    Ooops, you're right. I jumped to a conclusion and didn't verify. However, this works. From the VBA editor Tools>Properties>type the Project Name you want.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. My query code doesn't work
    By blacksaibot in forum Programming
    Replies: 2
    Last Post: 03-08-2012, 02:59 PM
  2. Code to Update Excel from Access
    By portmancp in forum Programming
    Replies: 2
    Last Post: 03-10-2010, 03:06 AM
  3. Query doesn't work when launched by code
    By stephenaa5 in forum Queries
    Replies: 1
    Last Post: 10-24-2009, 09:52 AM
  4. Replies: 0
    Last Post: 08-26-2008, 09:22 AM
  5. Access application to Web based application
    By admaldo in forum Access
    Replies: 0
    Last Post: 06-12-2008, 06:22 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums