Solved

Form design view option disabled

Posted on 2013-10-26
6
577 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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Suggested Solutions

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
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.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

773 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