PC Review


Reply
Thread Tools Rate Thread

Access 2007 form won't open?

 
 
Sandroid
Guest
Posts: n/a
 
      2nd May 2010
Hi
I have a problem. I created a asset form from asset table and tested
it with test data. After that I imported data from Excel and now the
form won't open anymore? Any of the views won't open. I've tried to
reboot Access. Other forms works normally.
 
Reply With Quote
 
 
 
 
Jeanette Cunningham
Guest
Posts: n/a
 
      2nd May 2010
If it won't open in design view, then import that form from your most recent
backup to replace the form that won't open.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

"Sandroid" <(E-Mail Removed)> wrote in message
news:17e967c5-7bb0-4775-93f2-(E-Mail Removed)...
> Hi
> I have a problem. I created a asset form from asset table and tested
> it with test data. After that I imported data from Excel and now the
> form won't open anymore? Any of the views won't open. I've tried to
> reboot Access. Other forms works normally.



 
Reply With Quote
 
Jeanette Cunningham
Guest
Posts: n/a
 
      2nd May 2010
Sometimes this will work:
If you have a button somewhere that uses code to open this form, set a break
point in that code.
Often this will get you into the code for the form that won't open.
This may help if you comment out all the code for the form that won't open,
then try to open it in design view.

If still no joy, then assume the form is corrupted.
Either you the form from your backup or create it again from scratch.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia



"Sandroid" <(E-Mail Removed)> wrote in message
news:17e967c5-7bb0-4775-93f2-(E-Mail Removed)...
> Hi
> I have a problem. I created a asset form from asset table and tested
> it with test data. After that I imported data from Excel and now the
> form won't open anymore? Any of the views won't open. I've tried to
> reboot Access. Other forms works normally.



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Open Access 2007 with a form already open Mark909 Microsoft Access 2 10th Dec 2008 01:43 PM
Access 2007 Open forms with FilterOn and form fails to open merwcat Microsoft Access Form Coding 5 7th Aug 2008 01:18 PM
How do you set a form to open as a switchboard in MS Access 2007? Database Switchboards Microsoft Access Forms 6 6th Apr 2008 02:17 AM
How to open a form automatically in Access 2007 like a switchboard worked in Access 2002 Cindy H Microsoft Access 2 24th Mar 2007 11:45 AM
open form on startup in Access 2007 =?Utf-8?B?U2Vhbg==?= Microsoft Access 3 22nd Feb 2007 06:15 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:51 PM.