Solved

Form design view option disabled

Posted on 2013-10-26
6
567 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
  • 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
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 
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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
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.

707 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

16 Experts available now in Live!

Get 1:1 Help Now