Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Form design view option disabled

Posted on 2013-10-26
6
Medium Priority
?
616 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
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 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Suggested Courses

824 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