Solved

What causes an Access form to grey out when it opens?

Posted on 2008-10-17
13
320 Views
Last Modified: 2013-11-28
I have form that was completely functional yesterday. Today when I opened it, the entire form is greyed-out in Form/Layout views. All the details can been seen in design view.

Tried decompile/compact/repair... exporting to a blank database... still the same.

Didn't find anything like this in searching EE, or the internet... any ideas?

Thanks.
greyed-out-form.bmp
0
Comment
Question by:Destiny947
13 Comments
 
LVL 65

Expert Comment

by:Jim Horn
ID: 22744877
First thought, the RecordSource of the form returns zero records.
Second thought, you're using Access 2007, so who the heck knows..
0
 
LVL 16

Expert Comment

by:Sheils
ID: 22745028
Go to the property of the form and click on the data tab. If you don't have any data in your record source you have to have "Allow Addition" set to "yes".

What are you using as record set a query or a table
0
 
LVL 28

Expert Comment

by:omgang
ID: 22745164
<<Second thought, you're using Access 2007, so who the heck knows.>>

made my day jimhorn....thanks!
OM Gang
0
 

Author Comment

by:Destiny947
ID: 22745188
Hi Jim,

>Access 2007.... :) exactly how I feel.

sb9

I'll check my properties, even though I haven't worked on this form in a couple of weeks...

brb
0
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 22745209
Are you running this across the WAN we discussed in earlier questions?

I'd suspect corruption ... do you have a recent backup? In the case of extensive corruption you may not be able to recover.

I'd also STRONGLY suggest you do your development work in 2007 ... 2007 users can run a 2003 database, and the 2003 format is much more stable than the 07 format.
0
 

Author Comment

by:Destiny947
ID: 22745225
Hi sb9,

Yep... Allow Additions is set to yes...

Lovely, 2007... so very unpredictable...
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)

 

Author Comment

by:Destiny947
ID: 22745266
Hi LSM,

I am developing on a laptop with 2007 setting at 2002-2003. And I have countless backups...

This does seem like corruption.
0
 

Author Comment

by:Destiny947
ID: 22745336
Also... thanks for all of your fast responses!
0
 

Author Comment

by:Destiny947
ID: 22745373
Hi LSM,

Is using 2007 with the default file format set at 2002-2003 is what you meant?
0
 
LVL 84
ID: 22745692
<Is using 2007 with the default file format set at 2002-2003 is what you meant?>

Not really, although it's better that using the .accdb format. 2003 is much more stable than is 07, which is why you would be better off developing in 2003, even if your endusers will be using 2007.
0
 

Author Comment

by:Destiny947
ID: 22745834
Hi LSM,

Thanks again for your input. Develop in 2003 only. That's what I need.

As far as the corruption issue. Do you suspect that this will continue to occur until I change from 2007 to 2003?
0
 
LVL 84
ID: 22747633
Working in 2007 with the 2003 format seems to give me more problems than other configurations. Granted I don't use 07 a lot, but I have a couple of clients who have moved to 07 and I do like to finish up those code sessions in Access 2007 just to be sure.

If you must work in 07, then build a new blank database in 07 (in the .mdb format) and import everything to it. This seems to work better than anything else for reduce the chances of corruption.
0
 

Author Comment

by:Destiny947
ID: 22749724
Hi LSM,

Had to think real hard on that one... :-)  And am going to do just that.

LSM... I think that is going to work!

Thanks so much!
0

Featured Post

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)

Question has a verified solution.

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

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

929 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

12 Experts available now in Live!

Get 1:1 Help Now