Access 2007 form won't open?
in [Form]
|
From: Sandroid on 2 May 2010 13:11 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.
From: Jeanette Cunningham on 2 May 2010 17:26 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" <santeri.virtanen(a)gmail.com> wrote in message news:17e967c5-7bb0-4775-93f2-2a74ef33e1e4(a)b18g2000yqb.googlegroups.com... > 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.
From: Jeanette Cunningham on 2 May 2010 17:29 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" <santeri.virtanen(a)gmail.com> wrote in message news:17e967c5-7bb0-4775-93f2-2a74ef33e1e4(a)b18g2000yqb.googlegroups.com... > 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.
|
Pages: 1 Prev: Allen Browne’s date range vba for more reports Next: After Event to automatically fill |