Solved

Form design view option disabled

Posted on 2013-10-26
6
587 Views
Last Modified: 2013-10-28
Hello,

I am unable to get an ACCDB for to show up on design view - the option is disabled. I can view the form in layout view, and then change to design but not to design directly. I have browsed for solutions but nothing has worked. This problem exists for ALL db's, existing ones or even a new one just created.
Things I've tried.
Decompile / recompile / import to new db - design disabled
Create new accdb, create & save form - design disabled

Has anyone heard of this scenario and/or any other suggestions
0
Comment
Question by:Howiee22
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
6 Comments
 
LVL 75
ID: 39602922
Can you upload a db that exhibits this behavior ?
0
 

Author Comment

by:Howiee22
ID: 39603245
Attached is the accdb. I did try this on my Access 2003 and I am getting the same issue on a 2003 mdb as well - the only difference is I can not go into design view after I load the form. Never had a problem like this before today.
REITS-BACKUP.zip
0
 
LVL 75
ID: 39603270
I am able to get into Form design directly, BUT ... I get this error message first - because I do not have the external (SQL ?) tables that the query driving Form1 is referencing - I guess.

1
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 75
ID: 39603279
Also, nothing is grayed out

1
0
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 39603756
This problem exists for ALL db's, existing ones or even a new one just created.
This would suggest a problem with the installation of Access on your machine. As illustrated by mx, he can move into Design view, so that means there's nothing wrong with the database.

Is your installation of Office/Access fully up to date, including all Service Packs? Also, is your Windows installation fully up to date? Check these to be sure, and also try restarting your machine.

You may also have a corrupt user profile that can cause issues like this. Try creating a new user on your machine and log in as that user. If the new user does not have the same issues, you'll need to rebuild or recreate your original user profile.
0
 
LVL 75
ID: 39607610
Please post how you resolved the issue.

thx.mx
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

756 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