Cannot save Access 2007 Form after making changes in Form?

Posted on 2008-11-19
Last Modified: 2013-11-29
I have been using an Access Database since I created it in Access 97, then upgraded to Access 2002 (XP) and now in Access 2007.  I have Modifed some of the forms which I originally created in Access 97 and 2002, but now they will not save when modified in Access 2007.  I have read some similar instances on the Internet which people seem to have solved this by "deleting a blank module behind the form".  Is this a possible issue and how wouild I determine if I have a blank form and how wouild I delete it using Access's GUI since I do not know VB?
Question by:cmsamford
    LVL 84

    Accepted Solution

    The best method to use is to build a new, blank database in 2007 (use the .mdb format), then import all your objects to that new database. There have been many issues reported when "upgrading" to 2007, and this methods seems to solve the bulk of them.

    I haven't heard of any issues with a blank module error. Forms do not, by default, have an associated Code Module, and only are provided one if you enter VBA code. YOu can review the modules present in your project from the VBA editor window ... and you can remove a form's Code Module by setting the HasModule property to No (this is done in the Properties window).

    Author Closing Comment

    Setting the HasModule to no worked.  That was it!!!
    Thank you.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now