Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Form design view option disabled

Posted on 2013-10-26
6
Medium Priority
?
610 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
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 
LVL 75
ID: 39603279
Also, nothing is grayed out

1
0
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

719 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