Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Taranaki, New Zealand
    Posts
    193
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Mismatch of expression (2000)

    I just read an earlier post on this subject and Hans suggested to delete fields one by one. However, I can't even open the form in form view or design view.
    It's suppose to be a simple database with only 3 tables and the bother it is giving me !!

    Is the best option just to start again ??

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Mismatch of expression (2000)

    If you cannot open a form, your database is probably corrupt. Depending on hpw much you have changed since the last backup, you can:

    - go back to a non-corrupt backup and take it from there, or

    - create a blank new database and import all database objects (tables, queries, forms, ...) except the corrupt form from the problem database into the new one. then either import the form from a non-corrupt backup or create it anew.

Posting Permissions

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